Database homework

Raging Rivers Hotels

Raging Rivers is a hotel chain that owns complexes in Washington, Oregon, California, and

Idaho. Each hotel complex contains anywhere from 100 to 606 rooms and suites, of varying

sizes. All accommodations are rented from 1 night to 30 nights upon request.

It is the company’s practice to hire one manager for each complex. As manager, he or she needs

to oversee the hotel staff. This oversight includes the front desk operation, the restaurant

operation, and maintenance to the building. The manager needs to maintain various records for

reporting. These reports are sent back to the parent company weekly and some daily.

Each manager is expected to send a series of reports back to the company headquarters in Seattle

every day. These reports summarize the occupancy rate (submitted daily) , the total revenues

(from the restaurant weekly by day), the total expenses in maintenance and repairs (weekly),

employees time sheets are sent weekly. Currently, managers fill out paper forms and mail them

back to headquarters. Many managers have complained that preparing this report is a timeconsuming

process. Also, the managers at corporate headquarters have expressed concerns about

the accuracy and verifiability of the reports. Corporate Headquarters has received complaints

from customers about their reservations being lost. All reservations are currently tracked at each

hotel by the staff in a log book. Accounting has complained due to the fact the residency report

does not always line up with the income reports.

Every manager has assigned to him a grounds keeper, a building superintendent, several day

clerks, several night clerks, a restaurant manager and staff.

To alleviate these concerns and to improve the ease and efficiency with which the hotel

managers conduct their daily business, the company is proposing to develop a centralized online

computer GUI driven system with a database that can be used by the managers to track the daily

business of their hotel operations and to prepare their report

Basing above case answer following questions

To do Chapter 2

1. Make a list of questions that you would ask about these forms and reports.

2. Identify the stakeholders for your selected scenario.

3. Create a plan for an hour-long interview with representatives of these

stakeholders. Then meet with the instructor to discuss possible answers to the

questions.

4. Create a questionnaire of at least five questions for the managers of hotels.

5. Look at the Job Shadow Report. Do you see any exceptions to the general rules?

Do you see any new business rules uncovered? What additional questions arise

from the report?

To do Chapter 3

1. Make a list of issues with the current system.

2. Make a list of the database requirements for each stakeholder involved in the

database.

3. Make a list of business rules.

4. List some major security rules for the database.

5. Take a look at each of the forms, and make a list of all the nouns in them. Do the

same for the interview, the questionnaire, and the Job Shadow Report. Then set

up some preliminary entities and attributes.

6. Identify some candidate keys.

7. Documentation: Store the list of the requirements and business rules in your

database notebook

8. Draw an logical E-R diagram in crow foot notations the chosen case?