Design, develop and implement a relational database for the case study assigned to you (go to the course web site to download). The required database should be developed according to the following stages: 1. Develop a conceptual data model reflecting the following requirements: • Identification of the relations (entity types). • Identification of relationship types and their participation and cardinality constraints. • Identification of attributes and association of attributes with entity or relationship types. • Determination of candidate and primary key attributes of entity types. • Determination of specialization/generalization and categorization relationships, whenever it is appropriate. • Enhanced Entity-Relationship (EER) diagram to reflect the requirements. 2. Develop a logical data model based on the following requirements: • Refinement of the conceptual model - including a refined Enhanced Entity-Relationship (EER) diagram. • Derivation of relations from the refined conceptual model. • Validation of logical model using normalization to BCNF. • Validation of logical model against corresponding user transactions. • Definition of integrity constraints including: — Primary key constraints.
Sample Solution