Design of an E-R Database Scheme -
The E-R data model provides a wide range of choice in designing a database scheme to accurately model some real-world situation.
Some of the decisions to be made are:-
-> Using a ternary relationship versus two binary relationships.
-> Whether an entity set or a relationship set best fit a real-world concept.
-> Whether to use an attribute or an entity set.
-> Use of a strong or weak entity set.
-> Appropriateness of generalization.
-> Appropriateness of aggregation.
The E-R data model provides a wide range of choice in designing a database scheme to accurately model some real-world situation.
Some of the decisions to be made are:-
-> Using a ternary relationship versus two binary relationships.
-> Whether an entity set or a relationship set best fit a real-world concept.
-> Whether to use an attribute or an entity set.
-> Use of a strong or weak entity set.
-> Appropriateness of generalization.
-> Appropriateness of aggregation.