Answered step by step
Verified Expert Solution
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 schemas
Part : Create a database schemafor each scenario. There are two scenarios.
Make sure that you read the tables carefully. Your schemas should reflect all entities, relationships, an attributes in the table. Use the relationship types ie cardinality given onetoone, onetomany, or manytomany and figure out minimum cardinality optional or mandatory on your own.
You must create two database schemas electronically, and they cannot be handdrawn. Follow the sam process as in ICA and use MySQL Workbench to create your diagrams. When you finish creating your database schemas, attach the screenshot of each in the word document and submit to canvas. Make sure the image is big enough so that ITA can correctly grade your work
Scenario : Hotel
tableEntityEntity AttributesCustomerCustomerlD, FirstName, LastName, Address, PhoneNumber, EmailAddressRoomRoomID, RoomType, FloorReservationReservationID, ReservationDate, CheckinDate, CheckoutDatePaymentPaymentID, Amount, PaymentDateHouseKeeperHousekeeperlD, FirstName, LastName, WorkingDays
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started