Reference no: EM13336048

1. List all the business rules for the database for Kangaroo Inn. An example of a business rule is: "An invoice is generated by only one customer";

2. Create an ERD that meets the Kangaroo Inn requirements. The ERD should show only Primary Key and Foreign Key attributes. (40 marks)
Part B. Create an RDM:

Tasks:

Using the ERD created in Part A:

1. Identify all attributes required for each table shown in the ERD;

2. Create an RDM for each table in the ERD;

Part C. Normalise the RDM to BCNF:

Tasks:

Using the RDM created in Part B:

1. Create a set of Dependency Diagrams for the Inn's database;

2. Normalise the tables to BCNF;

3. Create a new RDM for the normalised tables.

Rationale

This assignment has been designed to assess a student's ability to:
• Understand and interpret a set of business rules for a database;
• Create an Entity Relationship Diagram that models the requirements accurately;
• Create a Relational Data Model that accurately models the ERD and requirements; • Normalise the model to Boyce-Codd Normal Form;