To gain experience in designing a database using Entity-Relationship (E-R) Diagram, Normalization, and Relational Database modelling techniques.
In the process of this assessment task you will: ï‚· plan, schedule and execute project tasks with a view to improving your personal productivity; ï‚· gain awareness of the typical challenges related to the design of practical databases; ï‚· learn that database design is an iterative process; and ï‚· use the E-R Diagrams, Normalization techniques, and Relational models to develop elegant conceptual and logical models for a database; From the DEO business requirements specified above, prepare a document according to the following: 1. A completed copy of the SITE Assignment Coversheet. 2. An appropriate title page that includes an acknowledgement of all students you have spoken to about the assignment. 3. A table of contents and automatically generated page numbers. 4. An entity relation (E-R) diagram using Crow’s Foot notation. The diagram should include: a) all entities, attributes, and relationships (including names and strength) ; b) primary keys (underlined) and foreign keys (italic) identified; c) cardinality and participation (optional / mandatory) symbols; and assumptions you have made, e.g., how you arrived at the cardinality and/or participation for those not mentioned or clear in the business description, etc. 5. Normalization status of the relations which identifies: a) dependency diagram for each relation b) the level of Normalization achieved for each relation c) the reasons for any relation that is maintained NOT in 3NF. 6. 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; 7. A bibliography containing all resources used to complete the assignment. If no resources have been used please indicate this appropriately.