Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Writing For Hospitality

Authors: Peter Nyhiem, Vivienne J Wildes

1st Edition

0131715712, 9780131715714

More Books

Students also viewed these General Management questions

Question

please dont use chat gpt 3 5 4 . Question in Chemical Engineering

Answered: 1 week ago

Question

1. To take in the necessary information,

Answered: 1 week ago