BCA Assignements : TMA CS – 06 Introduction to DBMS

BCA Assignements : TMA CS – 06 Introduction to DBMS

Course Code : CS-06
Course Title : Introduction to DBMS
Assignment Number : BCA(4)-06/TMA/05
Maximum Marks : 10
Last Date of Submission : 15th April, 2005

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.

Comment for BCA Assignements : TMA CS – 06 Introduction to DBMS
critically examine two different dbms and compare the functionalities they offer?

Home > BCA Tutor Mark Assignments > BCA Assignements : TMA CS – 06 Introduction to DBMS
Comments are closed.