1. Draw an Entity Relationship (ER) Diagram for the database. Do show attributes on this diagram. Ensure the ER Diagram addresses all the Business Rules above.2. Construct a data dictionary containing:- Data Stores - Data Elements3 marks3. Answer the following questions:(a) What is functional dependence and how does it relate to your solution?(b) Why is it important to find the natural structure of data?(c) For the report, provide the unnormalised representation? (Hint: Refer to the workbook for further information)(d) Why would we use normalisation and how is it accomplished?
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here