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