I need help with question 4.9 I cant get mysql command line running on my mac because I forgot mysql password.

solution: https://www.chegg.com/homework-help/Database-Systems-6th-edition-chapter-4-problem-9E-solution-9780132943260

TextBook: database systems a practical approach to design implementation and management 6th

Exercises The following tables form part of a database held in a relational DBMS: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, type, price) Booking (hotelNo guestNo, datefrom, dateTo, roomNo) Guest (guestNo guestName. guestAddress) where Hotel contains hotel details and hotelNo is the primary key s room details for each hotel and (roomNo, hotelNo) forms the primary key Rooking contains details of bookings and (hotelNo, guestNo, dateFrom) forms the primary key Guest contains guest details and guestNo is the primary key. in this schema Explain how the entity and referential integrty rules apply to these re es for these relations that observe the relational integnity rules. Suggest some ge 4.9 Produce some sample tables relations relat constraints that would be appropriate for this schema. alternate keys, foreign keys, relational integrity, and views altermate, and foreign keys, and appropriate relational integnr that you are currently using Determine the support the system provides for primary keys 4.1I Implement the previous schema in one of the RDBMSS you currently use. Implement, ns, where possble the p