Reference no: EM131373515

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

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?

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?