الانتقال إلى المحتوى

مشروع Hotel Project DB


ojenana

Recommended Posts

اريد مساعدة في رسم ال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

رابط هذا التعليق
شارك

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   تمت استعادة المحتوى السابق الخاص بك.   مسح المحرر

×   You cannot paste images directly. Upload or insert images from URL.

جاري التحميل
×
×
  • أضف...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية