126815 Draw EER Diagram
- Status Closed
- Budget N/A
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%]Get free quotes for a project like this
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online