CS-06 Data Base Management System June-2001
Q.2(a). Describe the problems that are caused by data redundancies. Can data redundancies be completely eliminated, when database approach is used? Give reasons in support of your answer.
(b) Draw E-R diagram for any one of the following two organisations: (i) University, (ii) Hospital, after determining the entities of interest and the relationships that exist between these entities.
©Define the following terms:
(i) Association
(ii) Relationship
(iii) Aggregation