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.