Question: Part 1. Create a database schema for each scenario. There are two scenarios. Make sure that you read the tables carefully. Your schema should reflect

 Part 1. Create a database schema for each scenario. There are
two scenarios. Make sure that you read the tables carefully. Your schema

Part 1. Create a database schema for each scenario. There are two scenarios. Make sure that you read the tables carefully. Your schema should reflect all entities, relationships, and attributes in the table. Use the relationship types (i.e., cardinality) given (one-to-one, one-to-many, or many-to-many) and figure out minimum cardinality (optional or mandatory) on your own. You must create your database schemas electronically, and they cannot be hand-drawn. Use Vertabelo to create your diagrams (https://www.vertabelo.com/). It's free when you sign up with your Temple email. When you finish creating your database schemas, export the schemas as a PNG file which can be placed into a Word document. Scenario 1: Hotel Entity Entity Attributes Customer CustomerID, FirstName, LastName, Address, PhoneNumber, EmailAddress Room RoomID, RoomType, Floor Reservation ReservationID, ReservationDate, CheckinDate, CheckoutDate Payment PaymentID, Amount, PaymentDate Housekeeper HousekeeperID, FirstName, LastName, WorkingDays RateType RateTypelD, TypeDescription, Rate Relationships Relationship Attributes Customer-Reservation: One to Many Room-Reservation: One to Many Reservation-Payment: One to One Room-Housekeeper: Many to Many CleaningDate, Cleaning Time Room-RateType: Many to Many FromDate, ToDate

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 General Management Questions!