Sunday, December 12, 2010

CS403 Mid Term Current Paper (Dec 2010)

CS403 Mid Term Current Paper (Dec 2010)

Cs403 DBMS today mid term paper 

1. Differentiate total and partial completeness constraints? (5 Marks)
2. When is a functional dependency F said to be minimal? (5 Marks)
3. Name 3 kind of anomalies which can be eliminated through normalization? (3 Marks)
4. How to implement one to one relationship while designing tables? (3 Marks)
5. What is a data type? (2 Marks)
6. What do you know about the cardinalities relationship? (2 Marks)

CS403 Mid Term Current Paper (Dec 2010)

Give two types of Outer Joins? 2 Marks
Define forign Key ? 5 Marks
Define Cartesian product in relation Algebra? 5 Marks

No comments:

Post a Comment