126815 Draw EER Diagram

  • Status Closed
  • Budget N/A

Project Description

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online