IGNOU MCA -mcs-023 solved assignments 2012 -2013

Course Code : MCS-023

Course Code : MCS-023
Course Title : Introduction to Database Management Systems
Assignment Number : MCA (2)/023/Assign /12
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th October, 2012 (For July 2012 Session)
15th April, 2013 (For January 2013 Session)
This assignment has five questions. Answer all questions of total 80 marks. Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation. Answer to each part of the question should be confined to about 300 words.

Question 1: Describe briefly all the possible applications of a database
system in a University? (15 Marks)

Question 2: Identify all the associated entities for a Study Centre Management System, their corresponding attributes, relationships and cardinality and design an ER
diagram for it. (20 Marks)

Question 3: Consider the E-R diagram of Question 2 and design the tables. Perform Normalization till the required normal form. Implement it using MS-Access. (25 Marks)

Question 4: Consider a “Project Management System” that maintains the database using the following tables: (10 Marks)
Project (pid, ptitle, startdate, enddate, duration_in_months, cid, Cost)
Clients (cid, cname, caddress, cphone)
Employee (eid, name, address, phone)
Project-person (pid, eid)
Please note that an employee may be working on more than one project in the organization at any given time. Write and run the following SQL queries on the tables:
(a) Find the cid and cname of the clients who have given only one project to the company.
(b) List the details of all the employees whoever are working on the project with project code (pid) = 111.
(c) List all the project details those are currently under development.
(d) Find the projects whose cost is more than 11 lakhs.
(e) Find the employee who is not working on any of the project.
Note: Make suitable assumptions, if any.

Question 5: Consider the Relation R={A, B, C, D, E, F, G, H } and the set of
functional dependencies. (10 Marks)
A→C B→CG AD→EH C→DF A→H
What is the key for R? Decompose R into 2NF, 3NF and finally in BCNF relation.

 IGNOU Coaching for BCA, MCA, MBA in Jaipur 

IGNOU JAIPUR

Regional Director,
IGNOU Regional Centre,
70/79,
Sector - 7,
Patel Marg,
Mansarovar
Rajasthan - 302020
India
Ph :+91-0141-2785763 / 2785750
Fax :+91-0141-2784043