How did identify the primary key and foreign key

Reference no: EM132911707

Radisson Blue Hotels stores information about their hotels in different countries. Every hotel is identified by hotel id, hotel name, hotel address, city and URL. Every country is identified by country code, country name and country currency. Guests staying in the hotel is identified by guest number, guest name, guest address and guest city. Every room in the hotel is identified by room number, and room floor. Every room booking is identified by booking id, starting date, and ending date. There are different types of rooms in the hotel. Each room type is identified by room type code, room standard rate, and description. In each country, there may be no hotels or more than one hotel. A hotel may have one or more rooms. A guest can book one or more rooms and a room may be booked by one or more guests. A hotel may have one or more bookings and each booking is associated with exactly one hotel. Each room type may have one or more rooms and a room belongs to one room type.

Problem 1: Identify the primary key and the foreign key in each of the relations.

Problem 2: How did you identify the primary key and foreign key? Explain.

Reference no: EM132911707

Questions Cloud

Define the risk management process : Define the risk management process. Explain the role of risk management in the project planning process.

What ways did iso affect the standards for network security : What do you think were the critical factors that fueled the need for IT governance? In what ways did ISO affect the standards for network security?

Determine the future value of this annuity due : Your friend Anne is planning to invest $400 each year for four years and will earn a rate of 6 percent per year. Determine the future value of this annuity due

Hacking and invasion of the computers of others : Describe a case that has been in the news recently and describe what harm can be done by the unlawful intrusion into the computer of another.

How did identify the primary key and foreign key : How did you identify the primary key and foreign key? Explain. Radisson Blue Hotels stores information about their hotels in different countries.

University common core requirements : Analyze your selection of the University Common Core Requirements (UCOREs-Arts, Sciences, Diversity, Capstone, etc.), concentrations or areas

What the employer total fica payroll tax for this employee : An employee earned $42,500 working for an employer in the current year. What the employer total FICA payroll tax for this employee

Calculate the direct materials input rate variance : Calculate the direct materials input rate variance and the direct materials efficiency variance. What would you do differently if you were the sourcing manager

What is increase in expected monthly product contribution : What is the increase in the expected monthly product contribution for each of the possible changes? Assume long-run production equals sales

User Account

All Pages