| Course Code |
CS-06 |
| Course Title |
Database Management System |
| Assignment Number |
MCA(2)-06/TMA/2003 |
| Maximum Marks |
10
|
| Last Date of
Submission
|
15th October, 2003
|
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. Please go through the
guidelines regarding assignments.
| Question 1: |
Discuss the
problems that may occur when creating an ER model. |
| Question 2: |
"One of the main
objectives of physical database design is to store data in an
efficient way". How might we measure efficiency in this
context? |
| Question 3: |
Discuss the
differences between the candidate key and the primary key of a
relation. Explain what a foreign key means. How do foreign
keys of relations relate to candidate keys? |
| Question 4: |
Define the two
principal integrity rules for the relational model. Discuss
why it is desirable to enforce these rules. |
| Question 5: |
What is a
view? Discuss the difference between a view and a base
relation. Explain what happens when a user accesses a database
through a
view. | |