MCA Assignements : CS-06 TMA Database Management Systems

MCA Assignements : CS-06 TMA Database Management Systems

Course Code : CS-06
Course Title : Database Management Systems
Assignment Number : MCA (2)-6/TMA/04
Maximum Marks : 10
Last Date of Submission : 15th October, 2004

This is a Tutor Marked Assignment. There are five questions in this Assignment. Answer all the questions. Each question carries equal weightage. You may use illustrations and diagrams to enhance explanations.

Question 1: Discuss the advantages and disadvantages of object oriented database management system in comparison with RDBMS. Discuss types of applications suitable for object oriented DBMS and RDBMS.

Question 2: Discuss the concept of data independence and explain its importance in a database environment with the help of a suitable example.

Question 3: Describe the problems that are associated with redundant data. Can data redundancies be completely eliminated when the database approach is used? Why or why not?

Question 4: Describe the concept of functional dependency. How is this associated with the process of normalization?
Question 5: Describe the rules for deriving relations that represent strong entity types, weak entity types, one-to-one binary relationship types, one-to-many relationship types, multi-valued attributes, and superclass / subclass relationships.

Home > Tutor Mark Assignments - MCA > MCA Assignements : CS-06 TMA Database Management Systems
Comments are closed.