Question: 3. Design a database for a hotel chain. Each hotel has a name, code, address and a category (the number of stars). The total number

3. 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, hisfher 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
