MCSL 210 Solved Assignment 2021-22

 

MCSL 210 Solved Assignment 2021-22

DBMS and Java Lab

MCSL 210 Solved Assignment 2021-22 : All assignments are in PDF format which would be send on email/WhatsApp (9958676204) just after payment.

Course Code : MCSL 210

Course Title : DBMS and Java Lab

Assignment Number : PGDCA(2)/L-210/Assignment/2021-22

Maximum Marks : 100

Weightage : 30%

Note: This assignment has two sections. Answer all questions in each section. Each Section is of 20 marks. Your Lab Records will carry 40 Marks (20 Marks for each section). Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the programme guide for the format of presentation.

Note: You must execute the program and submit the program logic, sample input and output along with the necessary documentation. Assumptions can be made wherever necessary.

Section 1: DBMS Lab

A Central University has a main campus and a number of associated colleges. The University offers several types of programmes: Diploma (1 year duration), Bachelor’s degree (3 year’s duration), Post Graduation (2 years duration) and research degree programmes (5 years duration). A programme may be offered through the main campus or associated college. The university has a centralized database system. A student can register in a programme in the college of his/her choice in which programme is on offer. A student on taking admission pays the fee of the first year. For subsequent years a student should reregister in the next year of the programme and pay the fee of the next year. The fee payment is also done in a yearly mode. The final data of admission can be obtained by the colleges through a query to the central database. The University has a centralized examination system. It conducts the examination of the students in various subjects of various programmes. For simplicity you may assume that a programme of the University only has three compulsory subjects in a year. Perform the following tasks for the University. You may include following attributes in your design:

Student enrolment number, name, father’s name, date of birth, programme code (it should be a valid programmes), college, date of admission, fee payment details, subjects of the programme, marks of student in a course etc.

Please make and state assumptions, if any.

Question 1:

5

List the entities, their attributes and relationships for the description and make an ER-diagram for the University. You may use the concept of keys, aggregation, generalisation, cardinality etc. in a proper way. Design the suitable RDBMS tables for the ER-diagram so created. The database design should include keys, foreign keys, constraints and referential integrity constraints. Your database design must be normalized up to 3rd Normal form.

Question 2:

5

Implement the database design that you have created in question 1 using a RDBMS with proper integrity constraints. Enter about 10-20 records of meaningful data in each of your table.

Question 3:

10

Write and run the following queries for your database using SQL commands:

a) Find the details of the programme having the maximum number of students.

b) Find the programme that has the maximum fee. Also find the number of students enrolled in this programme.

c) Find the student who have either failed the subject Database Management System at least once or has not given the examination for this subject. You may assume that this subject is taught in BCA 2nd Year and MCA 1st year.

d) Find the student who has topped in BCA 2nd Year examination.

e) Find the number of programmes run in each college.

f) List the college with maximum number of students.

g) List the programme, the colleges in which they are being offered and the list of subjects of the programme.

h) List the student of BCA who have paid the fee of all three years of the programme.

i) List all the students of BCA who have paid the fee of all the three years as above and have passed all the subjects of that programme.

j) Find the total fee paid by all the students so fat to the university.

Section 2: Java Lab

Question 1:

5

Write a java program to demonstrate use of public, private and protected access specifiers. Define appropriate classes, constructors and methods in your program. Give suitable comments to increase readability/understanding of program.

Question 2:

5

Write a java program to create an Account class and define constructors in it. Inherit Saving_Bank_Account class and Current_Bank_Account class from the Account class. Override constructors of Account class in Saving_Bank_Account and Current_Bank_Account classes. Define appropriate methods to operate these accounts. Make necessary assumptions.

Question 3:

5

Write a java program to demonstrate use of File class and its methods.

Question 4:

5

Write a program to demonstrate use of ResultSet Interface in JDBC programming.

Related Links :

MCSL 209 Solved Assignment 2021-22

DCE 3 Solved Assignment 2021-22

MCS 208 Solved Assignment 2021-22

DCE 2 Solved Assignment 2021-22

MCSL 210 Solved Assignment 2021-22 : All assignments are in PDF format which would be send on email/WhatsApp (9958676204) just after payment.

POST GRADUATE DIPLOMA IN AUDIO PROGRAMME PRODUCTION P.G. Diploma Programmes (PGDCA) ASSIGNMENTS

Dear Learner,

You have to submit one assignment in each course, i.e. MCSL 210, MCSL 210. All these are Tutor Marked Assignments (TMAs). Before attempting the assignments, please read the instructions provided in the Programme Guide carefully.

Kindly note, you have to submit these assignments to the Coordinator of your Study Centre within the stipulated time for being eligible to appear in the term-end examination. You must mention your Enrolment Number, Name, Address, Assignment Code and Study Centre Code on the first page of the assignment. You must obtain a receipt from the Study Centre for the assignments submitted and retain it. Keep photocopies of the assignments with you.

After evaluation, the assignments have to be returned to you by the Study Centre. Please insist on this and keep a record with you. The marks obtained by you will be sent by the Study Centre to the Student Evaluation Division at IGNOU, New Delhi.

Guidelines for Doing Assignments

There are five questions in each assignment, all carry equal marks. Attempt all the questions in not more than 500 words (each). You will find it useful to keep the following points in mind:

Planning: Read the assignments carefully. Go through the units on which they are based, make some points regarding each question and then rearrange them in a logical order

Organization and Presentation: Be analytical in your selection of the information for your answer. Give adequate attention to the introduction and the conclusion. Make sure that your answer is logical and coherent; has a proper flow of information.

For IGNOU Solved Assignment PDF & Hand Written

Subscribe YOUTUBE : ASSIGNMENT SOLUTION

WhatsApp Contact : 9958676204