Assignment title: Information
From the CTS's business requirements specified above, prepare a document according to the followings: 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) ; b) primary keys (underlined) and foreign keys (italic) identified; c) cardinality and participation (optional / mandatory) symbols; and d) 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 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: d) relation (table) names, e) attribute (column ) names and field types (as required by WAMP), f) 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.