Question
In: Computer Science
Star Inn is a chain of hotels. The reservation system is uses a centralized reservation database....
Star Inn is a chain of hotels. The reservation system is uses a centralized reservation database. The database contains booking information on all hotels of Star Inn. The following is a description of the conceptual model of the hotel reservation database at Star Inn.
The database contains information about hotels, hotel rooms, customers, and reservation. A hotel can be identified by its identification number (hotel_id). It is also described by hotel_name, address and phone_no. Rooms are identified by room_no which is unique for a hotel. The same room_no may exist in different hotels of Star Inn. Rooms are also described by type and rate.
Customers are identified by customer_id and are described by name (customer_name), address (customer_address), and phone number (customer_phone). When a customer makes a reservation, he/she is asked to specify the hotel, the room type, the arrival date (arrival_date) and duration of stay (duration). A specific room is then booked for the customer. A customer can book the same room more than once. Therefore, a reservation is identified by a reservation number (reservation_no).
Please use Visible Analyst or any other CASE tool to draw the ERD.
Solutions
venereology answered 2 years agoRelated Solutions
Pacific Hotels operates a centralized call center for the reservation needs of its hotels. Costs associated...
Pacific Hotels operates a centralized call center for the
reservation needs of its hotels. Costs associated with use of the
center are charged to the hotel group (luxury, resort, standard,
and budget) based on the length of time of calls made (time usage).
Idle time of the reservation agents, time spent on calls in which
no reservation is made, and the fixed cost of the equipment are
allocated based on the number of reservations made in each group.
Due to...
Pacific Hotels operates a centralized call center for the reservation needs of its hotels. Costs associated...
Pacific Hotels
operates a centralized call center for the reservation needs of its
hotels. Costs associated with use of the center are charged to the
hotel group (luxury, resort, standard, and budget) based on the
length of time of calls made (time usage). Idle time of the
reservation agents, time spent on calls in which no reservation is
made, and the fixed cost of the equipment are allocated based on
the number of reservations made in each group. Due to...
Pacific Hotels operates a centralized call center for the reservation needs of its hotels. Costs associated...
Pacific Hotels operates a centralized call center for the
reservation needs of its hotels. Costs associated with use of the
center are charged to the hotel group (luxury, resort, standard,
and budget) based on the length of time of calls made (time usage).
Idle time of the reservation agents, time spent on calls in which
no reservation is made, and the fixed cost of the equipment are
allocated based on the number of reservations made in each group.
Due to...
Pacific Hotels operates a centralized call center for the reservation needs of its hotels. Costs associated...
Pacific Hotels operates a centralized call center for the
reservation needs of its hotels. Costs associated with use of the
center are charged to the hotel group (luxury, resort, standard,
and budget) based on the length of time of calls made (time usage).
Idle time of the reservation agents, time spent on calls in which
no reservation is made, and the fixed cost of the equipment are
allocated based on the number of reservations made in each group.
Due to...
Create a Database Schema for a hotel reservation system. indicate the Primary Keys, Foreign Keys, and...
Create a Database Schema for a hotel reservation
system. indicate the Primary Keys, Foreign Keys, and the
one-to-one or one-to-many relationships between the tables. Also
describe in a small paragraph the scope of the back-end database,
by explaining the different tables and their relations in
your schema.
An airline reservation system suffers a 10% rate of no-shows. A new reservation system is then...
An airline reservation system suffers a 10% rate of no-shows. A
new reservation system is then instituted in hopes of REDUCING this
no-show rate. After implementation of the new procedure, a SRS of
2500 reservations showed a 10.24% (256 out of 2500) no-show
rate.
A) what is the population?
B) variable of interest?
C)what are the null and alternative hypotheses?
D)determine the value of the appropriate observed test statistic to
perform this test (note: 10.24%=0.01024 & 10%=0.1000)
E)whats the p-value?
Suppose your company has built a database application that runs on a centralized database, but even...
Suppose your company has built a database application that runs
on a centralized database, but even with a high-end computer and
appropriate indices created on the data, the system is not able to
handle the transaction load, leading to slow processing of queries.
What would be some of your options to allow the application to
handle the transaction load?
On January 3rd, 2009 Holiday Inn Hotels entered into a contract with Great Designs Inc., an...
On January 3rd, 2009 Holiday Inn Hotels entered into a contract
with Great Designs Inc., an interior decorating firm, to have their
hotel rooms re-decorated with new carpeting, bedspreads, curtains
and wall art. Holiday Inn Hotels paid Great Designs Inc., $100,000
upfront and the work was to be completed by June 1st, 2009. On June
1st, 2009 work in 30% of the rooms was still not complete. The
Hotel had a large conference group checking in on June 30th, 2009...
Net Present Value Method—Annuity for a Service Company Welcome Inn Hotels is considering the construction of...
Net Present Value Method—Annuity for a Service Company
Welcome Inn Hotels is considering the construction of a new
hotel for $70 million. The expected life of the hotel is 10 years
with no residual value. The hotel is expected to earn revenues of
$19 million per year. Total expenses, including depreciation, are
expected to be $14 million per year. Welcome Inn management has set
a minimum acceptable rate of return of 10%. Assume straight-line
depreciation.
a. Determine the equal annual...
Consider the database of a car rental company that contains three tables drivers, cars and reservation...
Consider the database of a car rental company that contains
three tables drivers, cars and reservation tables.
Drivers:
Reservation:
Cars:
Dno
Dname
age
Dno
Cno
Day
Cno
Cmake
Color
22
Dustin
45
22
101
10/10
101
BMW
Blue
29
Brutus
33
22
102
10/10
102
VW
Red
31
Lubber
55
22
103
10/8
103
OPEL
Green
32
Andy
25
22
104
10/7
104
FIAT
Red
58
Rusty
35
31
102
11/10
64
Horatio
35
31
103
11/6
71
Zorba...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Draw a DFA for the following ( ∑ = {0,1}): Set of all strings with.
- In the article from Forbes notes that the goal of a leader is not to clone...
- Many people keep time using a 24 hour clock (11 is 11am and 23 is 11pm,...
- UNIX ONLY -- DIFFICULT LAB ASSIGNMENT This is an extremely difficult subject for me. Could you...
- Do you know why your credit card can be refused even though you are profitable?
- The Following Java expression: S/10 * 10 + 10 – S = C Show that this...
- Year Cash Flow 0 −$9,700 1 5,800 2 2,500 3 3,400 &nb
ADVERTISEMENT