locked
sql problem data redundancy RRS feed

  • Question

  • 1. Royale Inn is a leading chain of hotels in California with branches in Denmark, Argentina, Mexico, Macau, and Perth. The hotel is known for providing quality services to its customers. It provides two types of suites, deluxe and super deluxe. The deluxe suite provides basic facilities, such as housekeeping, air conditioning, refrigerator, and geyser. However, the super deluxe suite provides the laundry facility in addition to the basic facilities.

    Currently, the hotel management maintains booking details of the customers in the Booking file. The details stored in this file consist of booking ID, customer ID, customer name, gender, address, country, contact number, check in date, check out date, suite ID, suite name, suite type, and feedback from the customers. Similarly, the suite details are stored in the Suite file. The details stored in this file consist of suite ID, suite name, suite type, suite tariff, ID of the suite service employee, name of the employee, and booking status. In addition, details of the hotel employees are stored in the Employee file. The details stored in this file consist of employee ID, name, gender, address, department ID, department name, name of the department head, and salary. Moreover, details of all the branches of the hotel are stored in the Hotel file. The details stored in this file consist of hotel ID, hotel name, branch address, country, contact number, and number of suites and employees in the branch. 

    Due to its world-class services, the hotel has succeeded in getting a number of tourists. However, the management has found that managing details of the increased number of customers in a manual file system is difficult and causing inconvenience to the visitors. In addition, the employees are facing problems in keeping track of the branches and the services provided at each branch. Therefore, the management has decided to automate the hotel management system. It has approached AxelloTech Inc. to develop an application. 

    At AxelloTech Inc., Robert and his team have been assigned the task of creating the required application. Being the database developer in the team, you have been assigned the task of analyzing the application and creating the required database and tables.

    You need to analyze all the files in the given scenario and perform the following tasks: 

    1. Identify the entities that may cause data redundancy. Justify your answer. [5 Marks]
    2. Identify the problems that may arise due to data redundancy. Justify your answer. [5 Marks]

    Wednesday, May 27, 2015 4:03 PM

All replies

  • No one will help answer your exam case.
    You  need to summarize your question of SQL Server.
    • Edited by Cheer08 Thursday, May 28, 2015 8:29 AM
    • Proposed as answer by Koi Tsang Thursday, May 28, 2015 9:35 AM
    Thursday, May 28, 2015 8:28 AM