Computer Science Assignment - The Kangaroo Inn database

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"; (10 marks)
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(15 marks):

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(35 marks):

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;