اللي تعرف حق هالبرنامج الله يخليها اتسويه لي ...والله بدعيلها من خاطريه

برنامج الـــ Database Essentials

وهااا المطلوووب

UAE Hotel Management Database

Project Overview
A new hotel management group is to be established in UAE. This group will manage a number of hotels in UAE. These hotels are distributed over four regions (North, East, South, and West). Each region contains a number of hotels. The group has identified a need for developing a database system to keep track of its information.

The manager of group has listed the following objectives for the database:

The database should contain all information about the following entities:

o Clients
o Rooms
o Bookings
o Employees
o Regions
o Hotels

The Entities are related as follows:

o A client can book one or more rooms
o A room may have one or more bookings made for it
o A hotel employee makes the bookings for any hotel in the group
o A region has many hotels
o A hotel has many rooms
o A hotel has many employees

The database should be user-friendly.


Different queries/reports could be extracted from the database. You should have at least 4 queries with 4 reports linked to them. For example, the database should answer the following questions:

o Do you have a room in a certain region with a certain price range?
o Is a particular room booked at a given date in the year?
o Has a certain client stayed in any hotel before or during a certain period of time?
o What are the room prices for different periods of the year?

The manager has decided to give you the freedom to design the database the way you see fit as long as you fulfill the objectives. The manager will work closely with you to define the system. You will then be required to design and implement the database following the determined requirements.
Specifications

The database must have the following specifications
· The database must be implemented according to the rules of database design.
· The tables must be efficient in terms of data types, field properties, and data validation.
· The application must have:
o Appropriate data entry forms for all entities
o 4 Appropriate and well designed reports based on 4 suitable queries
o Each form / report must have a title
o Appropriate test data
o Appropriate pictures








Deliverables

You are responsible for the following deliverables:
The implemented database. (31 May 2011)

General Rules:

ü This is a group project. Groups will be made of 2 to 3 students.
ü This project is worth 8% of the final grade for the ITDP 110 course.
ü The project should be saved to the Assignment U Drive with your name and your partner’s name.
ü Besides fulfilling the above requirements, marks are awarded for user-friendliness, attractive design, and innovation.



بليييز ساعدوني ...التسلييم 31/5