Part $1$: Create a database schema$|$for 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 $($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 two database schemas electronically, and they cannot be hand$-$drawn. Follow the sam process as in ICA$1$ 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 $1$: Hotel

$\backslash$table$[[$Entity$,$Entity Attributes$],[$Customer$,$CustomerlD, FirstName, LastName, Address, PhoneNumber, EmailAddress$],[$Room$,$RoomID, RoomType, Floor$],[$Reservation$,$ReservationID, ReservationDate, CheckinDate, CheckoutDate$],[$Payment$,$PaymentID, Amount, PaymentDate$],[$HouseKeeper$,$HousekeeperlD, FirstName, LastName, WorkingDays$]]$