Create an ER diagram for the following requirements. Use cardinality ratio and participation constraints to indicate the relationship constraints. Design a database for a hotel chain. Each hotel has a...

Extracted text: Create an ER diagram for the following requirements. Use cardinality ratio and participation constraints to indicate the relationship constraints. Design a database for a hotel chain. Each hotel has a name, code, address and a category (the number of stars). The total number of beds is known. Each hotel has many rooms, and each room has a number (unique within the hotel). Rooms may be of two types (single or double). Some rooms have TVs. For each employee, his/her employee number should be stored, as well as the name, address, home phone number, job position and salary. Each employee works for just one hotel. An employee manages at most one hotel, but not all employees are managers.