Using the Business Description below:
1. You are required to identify the functional Requirements for the Games Shop.
2. You are required to derive a top-down Initial Entity-Relationship Diagram (Logical Data Model) for the Games Shop.
3. Refer to the sample data given below. Normalise separately the Stock Enquiry, Membership & Rentals Enquiry, Reservations Enquiry, Rental History Data and Catalogue Data showing all appropriate Normal Forms for each normalisation task. You may include any additional attributes required for the new system that are not included in the examples given. State any assumptions you make.
4. Merge and optimise the sets of fully normalised relations that you have produced, giving them names and listing their attributes. Produce a Third Normal Form Entity Relationship Diagram derived from these merged relations.
5. Compare your Initial Data Model (question 1) and the Third Normal Form Entity Relationship Diagram you have just produced. Identify and explain any differences between these two diagrams and then produce a revised version of your EntityRelationship Model taking account of these differences. You do not need to label relationships that are clearly self-evident. State any new or changed assumptions. You should attempt to validate any assumptions that you make. You may request further information about any aspect of the case study. This additional information should be documented and included with your submission.
