$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

ISY103 Database Management For Business

tag 1 Download3 Pages / 576 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

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
  1. Create an Entity Relationship Diagram (ERD) to help you decide on the relationships.

Your entity relation diagram that models your database design should:

  1. Include all entities, relationships (including names) and attributes.
  2. Identify primaryand foreign
  3. Include cardinality/ multiplicity and show using crow’s feet or UML notation.
  4. 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 Visio or try(Search for ERD gliffy to get started.).

  1. Using MySQL, you are required to develop a demonstration prototype system that handles hotel bookings and payments.  Use MySQL to create a new database called HMS.  Create tables according to your ERD.  Follow a standard naming convention for table names and also field names.    Avoid using spaces and any special characters in table and also field names.  Use underscore_caseor use camelCase to separate parts of a name.
  2. Create relationships between tables and enforce the referential integrity as shown below.

Relationships:

  • Guests can have one or more bookings.  
  • Each room booking can have numerous service charges associated with it.
  • Each room is classified by room type, such as deluxe, suite, or twinshare.
  • Each room is also provisioned with various facilities such as TV, spa, etc.
  • Each guest record may require one or more notes so as to keep a history of information related to the guest record.
  • Notes may be assigned to a particular staff person (or database user) to follow up.
  • Each room booking may have one or many payments and each payment is identified as to the payment method.
  1. The database should include suitable validation and integrity checks as well as appropriate referential integrity checks.  That is, AS A MINIMUM, your system should ensure that the following events cannot occur:

Referential Integrity Constraints:

  • A booking record cannot be entered for a guest that does not exist.
  • A guest cannot be deleted for which a reservation or a booking has been recorded.  Similarly a guest cannot be deleted once notes have been entered for the guest record.  Likewise, staff (users) cannot be deleted once staff persons have been assigned to follow up a note.
  • A booking cannot be deleted once the booking has a service charge or payment details associated with it.  Similarly a service type cannot be deleted once the service type has been entered against any service charge detail record for a guest booking.
  • Only service types that have been entered into the service types table may be entered as charges for service charge details.
  • Rooms cannot be deleted once rooms have been assigned to a guest room booking record.
  • Payment methods cannot be deleted once payment methods have been recorded against payments and room bookings that have matching payment details cannot be deleted once payment records have been entered.
  1. Save the data in the Excel file provided in a CSV file format and import the data into your tables in MySQL.
    1. Save a copy of xlsxas HMS_ERD.xlsx and for each sheet delete the definition and arrange the data so that the sample data appears immediately below the column headings.  Position the data for each table starting from cell A1.
    2. Import your normalised data from Excel into your tables.  Save your data in Excel in a CSVfile format.  Select your table in MySQL, click the Operations tab and then import the data from the CSV file.  Refer to the document titled Import CSV into MySQL to learn how to save in a CSV format and import into MySQL.
  2. Add at least two new records into the appropriate tables to include your details as a guest, room booking details of your own, and notes details related to your guest record.
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 3 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Database Management For Business. Retrieved from https://myassignmenthelp.com/free-samples/isy103-database-management-for-business/create-reservations.html.

My Assignment Help (2021) Database Management For Business [Online]. Available from: https://myassignmenthelp.com/free-samples/isy103-database-management-for-business/create-reservations.html
[Accessed 26 September 2021].

My Assignment Help. 'Database Management For Business' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/isy103-database-management-for-business/create-reservations.html> accessed 26 September 2021.

My Assignment Help. Database Management For Business [Internet]. My Assignment Help. 2021 [cited 26 September 2021]. Available from: https://myassignmenthelp.com/free-samples/isy103-database-management-for-business/create-reservations.html.


MyAssignmenthelp.com has appointed best assignment experts who are wizards of words. Our writers know every trick of crafting high quality write-ups within a short period. With years of experiences, we have become one of the most prolific assignment help services in the USA. We deliver custom-made help to students with writing different types of assignments. We guarantee total need-based and timely service, and this is why increasing numbers of students prefer to buy assignment online.

Latest Database Samples

COIT20247 Database Design And Development

Download : 0 | Pages : 2

Answer: Introduction  The database implementation detail is given in the report. The MS Access database is built for CQMC in the assignment. The important features and points of the relational database are being shown below. Normalization  ER Diagram Mapping to Relational Database    (holowczak.com 2016)  Functional Dependency   Patient  Patient (FiellddPatientId, FiellddPatientName, FiellddPatientCon...

Read More arrow Tags: Australia Melbourne Computer Science COIT20247 Database Design and Development  University of Melbourne Engineering 

ISY310 Data Mining And Business Intelligence

Download : 0 | Pages : 85

Answer: During the analysis, the set of data that are to be used has been collected from students of the university on the form of survey. In the survey the main roles played is by uncovering the modeling techniques and various analytics Data Mining. For the completion of this report, all the methods will be utilized as well as for the conventional questions to be answered, which are required to complete the analysis of this report. All these ...

Read More arrow

STAT 503 Design Of Experiments

Download : 0 | Pages : 2

Answer: Application of DOE in establishing Process Limits Design of experiments (DOE) is used as an approach in different industries for carrying out experiments for developing new products and initializing processes in a faster way, and for improving existing products and processes. Its proper application can decrease the time for marketing, decreasing development and production costs, and improving quality and reliability (Antony, 2014...

Read More arrow Tags: Australia Bloomington Management Educational Environment University of New South Wales MBA 

ITC516 Data Mining And Visualisation For Business Intelligence

Download : 0 | Pages : 4

Answer: The PCA analysis for the given data on US utilities data has been carried out with the aid of XLMiner and the relevant matrix consisting of the applicable Eigen values has been presented in the output below. Result Analysis and Component Analysis One of the key requirements to analyze the above output is to decide the extent of variation that the researcher aims to explain. This is imperative since the significant principal component...

Read More arrow Tags: Australia Hawthorn Engineering University of New South Wales 

ITECH1006 Database Management Systems

Download : 0 | Pages : 6

Answer: Australian Premier League (APL) is about to implement a new system for managing the league. The system will have to run on a very effective database to avoid cases of redundancy in data. This document shows they system can be modelled by showing the entity relationship diagram and a set of normalized relations derived from the ERD. The ERD diagram for the new Australian premier league is shown below. The diagram shows all the entities...

Read More arrow
Next

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

ribbon
callback request mobile
Have any Query?