Aim: to give you practical experience in using entity-relationship and relational modelling techniques. Assignment 1 – Database Modelling & Development of an ER Diagram and Schema Course Objectives:...

Aim: to give you practical experience in using entity-relationship and relational modelling techniques.
Assignment 1 – Database Modelling & Development of an ER Diagram and Schema
Course Objectives:
This assessment task focuses on the following course objective:
•    Use entity-relationship diagrams to design a relational database.
Due Date:
Sunday 7th May, 2017 by 11:59PM
Project Specification
You have been commissioned by the manager at a local hotel in Sydney to design a database to assist them with managing their hotel bookings and billing. The hotel has increased in size to a total of 100 rooms. Without automation the management of the hotel has become an unwieldy task. The end users’ day-to-day work of managing the hotel will be much easier with the database application. You are only required to provide the design of the database at this time.