In Progress

126815 Draw EER Diagram

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%]

Skills: Anything Goes, Article Rewriting

See more: will draw, types of data structures in c, types of data structures, types data structures, two types of data structures, feature article design, draw you in, draw you, disjoint, define disjoint, define data structures in c, data structures types, data structures in c notes, bernhardt design, article model, entity relationship, draw, diagram, derive, college database, multi step, relationship database diagram, diagram relational model, data structures complete notes, software draw

About the Employer:
( 2 reviews )

Project ID: #1872983