MCSL 210 Solved Assignment 2021-22

 

MCSL 210 Solved Assignment 2021-22

 

Course Code : MCSL 210

Course Title : DBMS and Java Lab

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

Maximum Marks : 100

Weightage : 30%

Last Date of Submission : 15th November, 2021 (for July session)

 

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.

MCSL 210 Solved Assignment 2021-22, MCSL 210 Solved Assignment 2021-22, MCSL 210 Solved Assignment 2021-22, MCSL 210 Assignment, IGNOU Assignment MCSL 210 2021-22- Gandhi National Open University had recently uploaded the assignments of the present session for Programme for the year 2021-22. MCSL 210 Solved Assignment 2021-22 Students are recommended to download their Assignments from this web page itself. They don’t got to go anywhere else when everything regarding the Assignments are available during this article only.

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

For Students - MCSL 210 Solved Assignment 2021-22 Students are advised that after successfully downloading their Assignments, you'll find each and each course assignments of your downloaded Programme. MCSL 210 Solved Assignment 2021-22 Candidates need to create separate assignment for the IGNOU Master Course, in order that it's easy for Evaluators to see your assignments.

IGNOU Assignment Status 2021-22

MCSL 210 Solved Assignment 2021-22 Those students who had successfully submitted their Assignments to their allocated study centres can now check their Assignment Status. MCSL 210 Solved Assignment 2021-22 Alongside assignment status, they will also checkout their assignment marks & result. All this is often available in a web mode. MCSL 210 Solved Assignment 2021-22 after submitting the assignment, you'll check you IGNOU Assignment Status only after 3-4 weeks. it'd take 40 days to declare.

MCSL 210 Solved Assignment 2021-22 once the TEE assignments are submitted to the Centres, it's send to the evaluation department. After which the evaluation of IGNOU Assignment Solutions takes place.

Related Links :

MCSL 209 Solved Assignment 2021-22

MES 007 Solved Assignment 2021-22

MCS 207 Solved Assignment 2021-22

MES 004 Solved Assignment 2021-22

MCSL 210 Solved Assignment 2021-22 :- Those students who had successfully submitted their Assignments to their allocated study centers can now check their Assignment Status. Alongside --assignment status, they will also checkout their assignment marks & result. All this is often available in a web mode. After submitting the assignment, you'll check you MCSL 210 Solved Assignment 2021-22 only after 3-4 weeks. MCSL 210 Solved Assignment 2021-22 it'd take 40 days to declare MCSL 210 Solved Assignment 2021-22

For IGNOU Solved Assignment PDF & Hand Written

Subscribe YouTube : My IGNOU Solutions

WhatsApp Contact : 9958676204