Base on the scenario, file uploaded.
Step One Design a detailed conceptual model using EER to define the information needs of the College. 40%.
You should State clearly the assumptions that you made in developing the diagram
Identify all the real world entities. Give a candidate key and suitable attributes for each entity. Indicate clearly the multi-valued attributes. Show clearly the weak entities and determine its relationship with the owner entities
Identify the Super/ subtype entity available in the given scenario. Identify the constraints on the generalization/specialization as either disjoint or overlapping
Identify the relationships among the entities.
Indicate clearly the cardinality of each relationship. Show the attributes for each relationship, if any. Give any additional semantic feature of the relationships such as total participation or partial participation.
Draw a complete EER diagram.
Step Two Use the EER from Task 1 to derive the relations. Explain and justify the types of integrity constraints that will be imposed on the proposed database [40%]
Step Three Use any relational database software to implement the relations. Populate the database with sample data. Provide screen dumps of the implemented structures with supporting notes [20%]