مشروع Hotel Project DB

اريد مساعدة في رسم الER الخاص بهذا المشروع بالشكل المطلوب والصحيح 

Database Project Description  

Requirements & Specification  

• InterContinental hotel chain owns many hotels in KSA. Every hotel has a Hotel Numbers identifier, Address (Street number, Street Name, and City), Email Address, and Phone Number.
• InterContinental hotel chain hires many employees. Every employee has SSN (identifier), Name, Address, and Hired Date. Every employee works in only one hotel. There are three kinds of jobs, hotel manager, senior and junior. Every junior has a supervisor. The supervisor can be a hotel manager or a senior in the same hotel.
• Every hotel has many categories of rooms, single room, double room 1-bed, double room 2-bed, suite, conference room, etc. usually same category rooms have the same price. Hotel rooms have a unique room number.
• The Guest of InterContinental could order many rooms in the hotel chain. But a room could only be ordered by one guest on the same day. If a guest has ordered rooms, each order has an order number (identifier), order date, ordered room, and stay date. Every guest has SSN (identifier), Name, Address, and Contact Phone Number.
• Every hotel has restaurants. There are many kinds of restaurants, Italian food, Mexican food, and Chinese food, etc. The restaurant does belong to the hotel, and it has a restaurant number, which is distinct in the same hotel, and restaurant name. The restaurant will pay rent to the hotel. The rental prices are different for the restaurants. The Restaurant has its employees, which includes management, chef, cashier, and waitress. The employee of the restaurant has the same attributes as the employee of InterContinental. An Employee of the restaurant cannot be hired by InterContinental at the same time.

HotelProject.docx