Too Tired? Too Anxious? Need More Time? We’ve got your back.
Travel Classics” (TC) is a newly establish company in tourism industry. Company is planning to launch a website to facilitate travelers to find necessary information regarding travel lodging facilities and places of interest.
Company is planning to have two public user groups as travelers and hotels. Hotels have to register
with site and one logging will be given for the hotel. Travel Classics is providing a web page for each
hotel and through hotel logging hotel users can add information about the hotel. New website is planning to provide search function to search hotel based on country, city and street. Hotel might have many additional facilities such as swimming pool, gymnasium etc.. Travel Classics has defined set of common facilities and every hotel has to use these define facilities. If a hotel wants to add new facility which is not available in the given list they have to make a request and TB will add to the system.
Every hotel has many accommodation options and should specify how many rooms are available under each category. Same option might be available on many hotels. Under each category there can be many related information such as description, conditions and also price of a room will differ
from room to room and hotel to hotel.
Travelers can register by providing necessary information. Travelers have to add their information such as name, addresses, email, country …etc. and for each traveler unique reference id is given. Further they can add reports of their travels to a specific country or a location. Once they register in the website, they can make reservations for destinations. Travelers could add report on their travelling experiences to the website. This report might contain many information on particular destinations and there should be small description and a title. Other could view these posts.
Travel Classics website is also providing function to make reservation for a hotel room for a particular duration. One traveler could reserve multiple rooms as well and should add no of guests. Information regarding each reservation should be kept in the system. For each reservation, unique reservation id is generated. Only the registered travelers can make reservation for a particular hotel and they have to pay 10% at the reservation. All transactions should be log with unique transaction ID, date and time.
Students can add any functionality which will enhance the system and make the proposed solution more comprehensive.
Use Harvard referencing to properly acknowledge all the external sources you use.
Tasks:
Design the database with the constraint that the available technology is relational.
Explain what is data model, critically compare different data models and explain why older data models are being replaced by new data models. (LO1) (10 Marks)
Analyze and briefly explain the different approaches to database design. (LO1) (10 Marks)
Draw an entity relationship diagram for given scenario with proper standards. Identify important keys and represent different types of attributes and relationships. (LO2) (10 Marks)
Draw Relational Schemas. Effectively map conceptual data models with relational database schema according to the mapping algorithm. All the steps should be clearly mentioned. (LO2) (10 Marks)
Normalize Schema upto 3NF. (Clear Show the Steps) (LO2) (15 Marks)
Too Tired? Too Anxious? Need More Time? We’ve got your back.