IGNOU MCA BCA MCS-023 Solved Assignment 2019-20 Available Now
 |
| MCS-023 Solved Assignment 2019-20 |
Q1. (20 Marks)
Design an ER diagram for an ABC IT Training Institute that will meet the training needs for
individuals and employees of corporate offices. Clearly indicate the entities, relationships,
cardinality and the key constraints. The description of the environment is as follows:
The Institute offers 5 advanced courses of 3 months duration each. The Institute has 20 faculty
and can handle up to 40 trainees per batch. The training will be conducted batch wise. They can
accommodate maximum 5 batches per day (2 batches in the pre-lunch session and 3 batches in
the post-lunch session). The student can register up to 2 courses simultaneously. Training
consists of theory and practical. Theory and practical are scheduled on alternate days. Each batch
is assigned a faculty member who takes theory sessions as well as practical sessions. Sunday is
holiday for everyone. A test will be conducted per course every week to continuously evaluate
the performance of the student. The question paper will be set by the faculty concerned whoever
is teaching the batch. The result/grade will be declared at the end of the third month after
conducting course-end exam.
Q2. (10 Marks)
Design the Relational Schema for the E-R diagram that you have drawn for part Question 1. The
relations must be at least in 2 NF. Perform the following on the relations:
a) Enter about 5 sets of meaningful data in each of the relations.
b) Identify the domain of various attributes.
c) Identify the Primary keys of all the relations.
d) Identify the Foreign keys and referential integrity constraints in the relations.
Q3. (10 Marks)
(a) “For creating a Employee Management Information System of an Organisation a
database management system(DBMS) is better or a file management system.” Justify the
statement given above.
(b) Assume that you are assigned the role of Database Administrator for the Organisation
database, mention the key responsibilities you have to handle?
