I need an ER diagram for the following informationFor Hotel: HotelID (unique) and ANoOfRooms (number of rooms in the hotel)For Hotel: HotelID (unique) and ANoOfFloors (number of floors in the hotel)For each Room: RNO (partially unique, unique in the hotel) and ANoOfBeds (number of beds in the room)For each customer: CID (unique), CName (unique),For each manager: MID (unique), MFullName (composed of MFName and MLName), MBonus (not every manager has a bonus), MSalary, multiple MPhonesFor each employee: EID (unique), ENameEach hotel has one or more roomsEach room is located on exactly one floorEach room is cleaned by one or two employeesEach employee cleans 1-3 floorsEach employee cleans 6-15 roomsEach customer has one or many roomsEach customer has booked one or mamy rooms Each room is booked by a customer or no oneEach floor has one or many roomsEach manager resides in exactly one roomEach manager resides on exactly one floorEach hotel either has one manager residing in it or no manager residing in it Each salestransaction has exactly one customerEach customer has one or many salestransactions Each salestransactions occurred at one hotelEach hotel had multiple salestransactions

Q. For Hotel: HotelID (unique) and ANoOfRooms (number of rooms in the hotel) For Hotel: HotelID…

Answered: For each customer: CID (unique), CName…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

I need an ER diagram for the following information

For Hotel: HotelID (unique) and ANoOfRooms (number of rooms in the hotel)
For Hotel: HotelID (unique) and ANoOfFloors (number of floors in the hotel)
For each Room: RNO (partially unique, unique in the hotel) and ANoOfBeds (number of beds in the room)
For each customer: CID (unique), CName (unique),
For each manager: MID (unique), MFullName (composed of MFName and MLName), MBonus (not every manager has a bonus), MSalary, multiple MPhones
For each employee: EID (unique), EName
Each hotel has one or more rooms
Each room is located on exactly one floor
Each room is cleaned by one or two employees
Each employee cleans 1-3 floors
Each employee cleans 6-15 rooms
Each customer has one or many rooms
Each customer has booked one or mamy rooms
Each room is booked by a customer or no one
Each floor has one or many rooms
Each manager resides in exactly one room
Each manager resides on exactly one floor
Each hotel either has one manager residing in it or no manager residing in it
Each salestransaction has exactly one customer
Each customer has one or many salestransactions
Each salestransactions occurred at one hotel
Each hotel had multiple salestransactions

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions