ITICT107A - Introduction to Databases - Report Writing - IT Assignment Help

Assignment Task

Background Information for Sample Database Project 
A local Sydney hotel requires a database system to manage their bookings and payments. 

When a guest rings up or comes into the hotel to book a room for the first time they are asked to provide their name, address, and telephone number.   

Guests may make reservations for a room which includes the date and time, number of adults, number of children, expected arrival date & time, expected departure date & time, and notes. Reservations may be confirmed and / or cancelled. 

When the guest checks in to the hotel reception enter a record of the room number, and check in date & time.  Guests may also check in without a reservation. 

When the guest checks out then the checkout date & time, and number of days are entered into the database.  The number of days is calculated but may be overwritten by a manager and the guest is charged for the accommodation plus additional service charges including restaurant, dry cleaning, valet parking, room service, etc.  

Once the checkout details have been completed then the guest is invoiced for the accommodation and also additional service charges.  Payments are recorded for each room booking. Payments are expected to be in full.  However, the system allows multiple payments to be recorded against each room booking. 

The database system also needs to keep a record of database users, staff, rooms, room type, facilities, payments, payment types, and guest notes. 

Assumptions 
Some service charges have a fixed cost. However, the charge amount may be adjusted up or down when charges are entered against the guest booking record. Total charges are calculated by the system by multiplying the charge amount (price) by the quantity. 

System Requirements 
The system is a prototype system and as such is not a full production version. You will be required to enter a representative sample data into your tables in order to test the design and operation of your database. You are required to import the sample data provided into your tables and you are required to enter at least two new records of your own in some of the tables.  

Project Specification
1. Part A
You are provided an Excel file that contains a partial ERD, suggested table definition, and also some sample data.  See HMS_Data.xlsx 

Use the Excel workbook file HMS_Data.xlsx to perform the following tasks. 

Your first task is to study the sample data and determine appropriate data definitions. Check that the spreadsheet data has been normalized to third normal form. Study the partial ERD on the first sheet that provides a suggested schema. The file has various other worksheets including: 
Bookings 
Country Lookup 
Facility List 
Guests 
Notes 
Payment Methods 
Payments 
Reservations 
Room Facilities 
Rooms 
Room Type 
Service Charge 
Service Types 
Staff 
Users 

2. Create an Entity Relationship Diagram (ERD) to help you decide on the relationships.

Your entity relation diagram that models your database design should: 

A. Include all entities, relationships (including names) and attributes. 
B. Identify primary and foreign keys. 
C. Include cardinality/ multiplicity and show using crow’s feet or UML notation. 
D. Include participation (optional / mandatory) symbols if applicable. 

The E-R should be created as part of a Microsoft Word document.  Hand-drawn diagrams will not be accepted.  It is recommended that you complete your ERD using Sybase Power Designer although other tools like Visio may be used.

This ITICT107A - IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.