Transforming ERD into a relational database schema The Luxury Lodgings Reservati

Question

Transforming ERD into a relational database schema

The Luxury Lodgings Reservation database design is on the next page. Your task is to transform (map) this ER Diagram into a complete relational schema. Your schema should satisfy the following requirements:

1.Each schema of a relation is given a list of attributes pertaining to the relation. The list is enclosed in parenthesis and the attributes are separated by commas. The relation name precedes the parenthesis. For example:

ADVISOR (AdivsorID, FirstName, LastName, Department)

2. The attribute(s) that compose the primary key are underlined.

3. The foreign key(s) in the relation, if it exists, is indicated under the relation that contains the foreign key as:

STUDENT(StudentID, FirstName, LastName, GPA, Major, AdvisorID)

FK: Foreign Key AdvisorID references ADVISOR

Do not include attribute values in your schema. Be sure to include the foreign key(s) in the appropriate schema tables.

HOTEL Hotel ID Name City Assumptions Each guest has unique phone numbers Each guest reservation is for one check in date ROOM TYPE Room Type RoomRate Nu ROOM HotellD RoomNum PhoneExt GUEST PHONE Phone Phone Type RESERVATION Guest ID Check InDate Check out Date -O Num Persons GUEST Guest ID FirstName astNa Address City State Zipcode

Explanation / Answer

ROOM_TYPE(RoomType, RoomRate, NumBeds)

ROOM(HotelID, RoomNum, PhoneExt)

HOTEL(HotelID, Name, City)

RESERVATION(GuestID, CheckInDate, CheckOutDate, NumPersons)

GUEST_PHONE(PhoneNumber, PhoneType)

GUEST(GuestID, FirstName, LastName, Address, City, State, Zipcode)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.