ITICT107A: Introduction to Databases – Database Report Writing - IT Assignment Help

Assignment Task:

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.

Project Specification
1. Part A (20 marks)
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.
1. 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.(10 marks)
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.

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.