Question: Suppose you are asked to design a web based system for reserving hotel rooms, home Stays and holiday rentals. A customer can contact any number

Suppose you are asked to design a web based system for reserving hotel rooms, home Stays and holiday rentals. A customer can contact any number of Home-Stay owners to enquire about the facilities. A Home stay owner can have upto five Home stays related to him. A Home-stay can be reserved by maximum of one customer. Draw the ER diagram and supply the (min,max) constraints. Make suitable assumptions where ever required.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Evaluate changes in the hotel /bed n breakfast industrys general environment (e.g., PESTEL analysis) to identify trends that represent both opportunities and challenges. What trends are the most...

rumal of Information Technology Teaching Cases 2011 CNC Mac 2016/1 Teaching case From theme park to resort: customer information management at Port Aventura Mariano A Hervs, Joan Rodon, Marc Planell,...

Make a PESTEL 2. Strategic Issues Analysis (Internal and External) Using the relevant analytical tools, conduct an analysis of both the internal and external environment as presented in the case. -...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Using Porter's Generic Strategies categorize Airbnb's original offering (spare rooms), Experiences offering, and Airbnb plus. Support your answer with data from the case. Using the Value Disciplines...

Basis below case , kindly answer ; Question to be Answered : What will be the best exit option for Nigel and Tammy if they decide to do so? Should We Stay or Should We Go? The Case of the Adventure...

Communications of the Association for Information Systems Volume 15 Article 5 1-26-2005 Outrigger Hotels and Resorts: A Case Study Gabriele Piccoli Cornell University, gp45@cornell.edu Follow this...

Case Study: MANAGING DIVERSITY IN THE HOTEL INDUSTRY : THE CASE OF YOGYAKARTA, INDONESIA Dr. James J. Spillane, S.J. I. INTRODUCTION One of the major developments in the global economy during the...

Discuss the regulatory and consumer preference challenges that airbnb face when expanding to new markets; Assess the different entry strategies that airbnb can pursue when expanding, and their...

How should Airbnb best position itself in China to ensure a successful expansion? Should it work with a local competitor and, if so, who? If it chose to instead continue expanding alone, should it...

What is the lost income from unoccupied rooms at the Grosvenor Hotel?

The corrosion rate is to be determined for some divalent metal M in a solution containing hydrogen ions. The following corrosion data are known about the metal and solution: (a) Assuming that...

assume that the bank pays 3 % interest per year. The interest is paid annually on the anniversary date of the deposit and is left in the account. What will the balance of the bank account be on march...

What responsibilities does the manager have in the management of stress? Describe some actions you might take as a manager to minimize organizational stress caused by technology.

5-17 Allowing employees use their own smartphones for work will save the company money. Do you agree? Why or why not? Just about everyone who has a smartphone wants to be able to bring it to work and...

5-18 What are the distinguishing characteristics of cloud computing and what are the three types of cloud services?

5-15 What management, organization, and technology factors should be addressed when deciding whether to allow employees to use their personal smartphones for work? Just about everyone who has a...