Transform the following E-R diagram into relations. Hotels Rooms Hotel ID. Room Number Zipcode Room Type Reservation City 太 Rates State Room location Reservation Number Phone Number Number of beds...

Transform the following E-R diagram into relations

Extracted text: Transform the following E-R diagram into relations. Hotels Rooms Hotel ID. Room Number Zipcode Room Type Reservation City 太 Rates State Room location Reservation Number Phone Number Number of beds Check in date Check out date Status Number of guests Reservation date Billing Customer Billing Customer ID Room charge 主 Last_Name Misc charges Phone number Credit card No First_Name Раyment Date City State Zip code


Extracted text: Conceptual Data Modeling Process • In this sample conceptual data model: 1. Rectangels represent major categories of data. 2. Lines connecting rectangles represent business relationships. Supplies Submits SUPPLIER CUSTOMER ORDER Submitted_by Sends + Requests Supplied_by Sent_by/\ Requested_on Includes Used_in SHIPMENT ITEM PRODUCT Included_on Uses Key Cardinalities ot ENTITY TYPE Relationship Mandatory One Optional One Mandatory Many Optional Many FIGURE 8-3