A hotel uses a booking system that needs to store, per booking, the room num- ber,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A hotel uses a booking system that needs to store, per booking, the room num- ber, the duration of the booking (start date, end date), a reference number for the guest, and finally the reference number (RN) of the employee who made the booking. There are various room types to chose from for every booking. The room types include, for instance, single bedrooms, suites, queen's palace and everything in between. Bookings can be made per room, or a group may book a combination of rooms for their stay. Every room is cleaned by an assigned employee or cleaner. Draw the EERD that will support the business requirements set out above. A hotel uses a booking system that needs to store, per booking, the room num- ber, the duration of the booking (start date, end date), a reference number for the guest, and finally the reference number (RN) of the employee who made the booking. There are various room types to chose from for every booking. The room types include, for instance, single bedrooms, suites, queen's palace and everything in between. Bookings can be made per room, or a group may book a combination of rooms for their stay. Every room is cleaned by an assigned employee or cleaner. Draw the EERD that will support the business requirements set out above.
Expert Answer:
Answer rating: 100% (QA)
Here is an EERD that can support the business requirements In this EERD there are two main entities ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these general management questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
What criteria are used to determine whether a government is engaging in a suspi-cious form of discrimination?
-
On page 4-14 (Section 4-3b), the text says that, when a bond is sold between interest payment dates, the interest for the period between the dates must be allocated between the buyer and the seller....
-
Requirement 1. Journalize the partners' initial contributions. (Record debits first, then, credits. Select the explanation on the last line of the journal entry table.) Begin by journalizing the...
-
Consider a company that manufactures and sells personal computers (lets call the company Bell Computers). Recently the company lowered its prices dramatically. The company is very efficient and needs...
-
The data set of die rolls given in DS 6.1.1. Use a statistical software package to obtain sample statistics and boxplots for the following data sets. What do the sample statistics and boxplots tell...
-
For the following data set: a. Construct the multiple regression equation b. Predict the value of y when x1 = 10.1, x2 = 8.5, x3 = 26.2. c. What percentage of the variation in y is explained by the...
-
Guardian Security Services was established on August 15, 2010, to provide security services. The services provided during the remainder of the month are listed below. Aug. 18. Issued Invoice No. 1 to...
-
Taking a look at the current real estate development environment, please read: Tishman Speyer announced that it has acquired The Eddy, a recently-constructed, high-rise apartment tower located on the...
-
Fast Snacks is a food franchise that sells outlets to entrepreneurs interested in opening their own businesses. The business sells a variety of healthy snacks and drinks that can be prepared rapidly....
-
You are currently working at a publicly traded company. The risk-free rate in the economy right now is 0.99%. You believe the market will average 7.80% per year over the long run. And you would...
-
Section 1: Compulsory question to be answered by all: 1. Critically explore the term 'Strategic Management'. Using examples as appropriate, discriminate between prescriptive and emergent models and...
-
The management of Wengel Corporation is considering dropping product B 9 0 D . Data from the company's accounting system appear below: Sales $ 7 3 6 , 4 0 0 Variable expenses $ 3 8 2 , 6 0 0 Fixed...
-
Consider the following credit card activity for the month of October: Date Balance Number of Days October 1 $ 2544 October 5 $ 3765 October 1 2 $ 4718 October 1 9 $ 5 8 1 5 October 2 4 $ 6 5 2 5...
-
Michelle s Kreations just completed its best year, generating income of $ 6 2 , 0 0 0 from selling decadent wedding cakes and desserts. For a business that is only two years old and run from Michelle...
-
Cosmopolitan what contend that everyone, including both compatriots and noncitizens, is entitled to equal moral rights and consideration and that allowing open borders is the key to eliminating the...
-
Question 41 (1 point) Credit card balances are included in: O a) neither M1 nor M2. b) both M1 and M2. Oc) M1 only. d) M2 only.
-
Fred Farmer needs to prepare a balance sheet for his bank. He spent the day getting the following information. Fred needs your help to build a balance sheet and evaluate it. The information was...
-
In 2012, Margaret and John Murphy are married taxpayers who file a joint tax return with AGl of $25,000. During the year they incurred the following expenses: Hospitalization insurance...
-
Olive Corporation was formed and began operations on January 1, 2012. The corporation's income statement for the year and the balance sheet at year-end are presented below. The corporation made...
-
Jim (age 50) and Martha (age 49) are married with three dependent children. They file a joint return for 2012. Their income from salaries totals $50,000, and they received $10,000 in taxable...
-
The efficiency of the viscous-shear pump of Fig. P8.29 is given by \[\eta=6 q \frac{(1-2 q)}{(4-6 q)}\] where \(q=Q / a b R \omega\) is a dimensionless flow rate, \(Q\) is the flow rate at pressure...
-
A continuous belt, passing upward through a chemical bath at speed \(U_{0}\), picks up a liquid film of thickness \(h\), density \(ho\), and viscosity \(\mu\). Gravity tends to make the liquid drain...
-
A wet paint film of uniform thickness, \(\delta\), is painted on a vertical wall. The wet paint can be approximated as a Bingham fluid with a yield stress, \(\tau_{y}\), and density, \(ho\). Derive...
Study smarter with the SolutionInn App