Reference no: EM13670249

Practical experience in using Entity-Relationship and Relational Database modelling techniques.

You are required to design using an E-R diagram an entity-relationship model of the problem, convert the model into a relational model, and assess the normal form of each schema.

The design document should contain:

1. An entity relation (E-R) diagram that models the problem which includes:

a. all entities, relationships (including names) and attributes;
b. primary (underlined) and foreign (italic) keys identified;
c. cardinality and participation (optional / mandatory) symbols; and
d. assumptions you have made, e.g. how you arrived at the cardinality/participation for those not mentioned or clear in the business description, etc.

The E-R should be completed using the standards of this course (crow's feet).

2. Relational data structures that translate your E-R diagram which includes:

a. relation (table) names,
b. attribute (column ) names and field types (as required by WAMP),
c. primary and foreign keys identified;

The data structures should be shown using the standards of this course.

3. Normalisation of relations which identifies:

a. dependency diagram for each relation
b. the level of Normalisation achieved for each relation;
c. the reasons for any relation that is maintained NOT in 3NF.