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 1 year 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...
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...
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...
Differentiate between centralized and distributed generation system.
Differentiate between centralized and distributed generation
system.
Five Seasons Hotel is a chain with 10 hotels. Strategically, the chain implements a cookie-cutter approach...
Five Seasons Hotel is a chain with 10 hotels. Strategically, the
chain implements a cookie-cutter approach to building and running
its hotels, in that all hotels are practically identical. Five
Seasons invested $150 million in acquiring the land for all hotels
and $500 million in building and furnishing the 10 hotels to a
guest-ready stage. Each hotel has 150 rooms. Each room has a rack
rate of $200 per night but the hotel gives an average of discount
of $30...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Explain technology and informatics role in PCMH
- For the following bond, Par value: $1,000 Coupon rate: 8% paid annually Time to maturity: 3...
- Effective leaders are pillars of success for an organization and a nation. From your personal experience...
- Marvel Parts, Inc., manufactures auto accessories. One of the company’s products is a set of seat...
- Suppose you now work for a small specialty chemical manufacturer. You are tasked with providing recommendations...
- Question 2: Job Description is also referred to as a document that provides information regarding the...
- What is disruptive leadership ? what is characteristics/trait of disruptive leader. ( Plagiarism check, 500 word...
ADVERTISEMENT