Make sure that you read the tables carefully. Your schemas 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 two database schemas electronically, and they cannot be hand$-$drawn. Follow the same 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

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 RateTypeID, 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, CleaningTime

Room$-$RateType: Many to Many FromDate, ToDate

Scenario $2$: Customer Service Outsourcing Company

Entity Entity Attributes

Manager ManagerID, FirstName, LastName, PhoneNumber, Address, SocialSecurity, JobTitle

Department DepartmentID, DepartmentName, Address

Employee EmployeeID, FirstName, LastName, PhoneNumber, Address, SocialSecurity

Customer CustomerID, FirstName, LastName, PhoneNumber, Address

CrowdsourcedFirm FirmID, FirmName, WebsiteUrl, CorporateExecutive, PhoneNumber, Address

Relationship Relationship Attributes

Manager$-$Employee: One to many

Department$-$Manager: One to many

Department$-$Employee: One to many

CrowdsourcedFirm$-$Customer: One to Many

Employee$-$Customer: Many to many Complaint, Solution