مساعدة عاجلـــه الله يخليكم

مساء الخير

اذا ما عليكم امر عندي واجب لازم اسلمة بكرا وعقدني كتير

هاد الاول

Design ER Diagram for a hotel reservation database, your ER Diagram should include the following:

1- Hotel

2- Hotel Branch

3- Room

4- Customer

5- Employee

6- Supplier: supplies beds, bed sheets, pillows, ... etc

7- Customers can reserve rooms

*Think of attributes and relationships that you need to have in your ER Diagram.

*Your ER diagram should include entities, attributes, relationship and cardinality constraints.

-------------------------------------------------------------------------------------------------------------------------------------------------

وهاد التاني

1- Map the Hotel reservation system ER diagram into relations. The outcome here is:

- Relations

- Primary Key/ Foreign Key connections

2- Based on the relations you got, create tables that represent Hotel system DB

- Make sure to represent the primary keys/Foreign Keys in your DB

3- Insert about 5 records in each table

4- Write a select statement that find customer info and the room he is staying in.

5- Write a select statement that finds each supply service for "Holiday In" Hotel

In your lab project report, you need to have:

* DB Relations (schema)

* All SQL statements you used After submitting your lab project.

Everyone is required to demo his project to me. In other words, I might ask you about the way you used to transform your ER diagram to relations. I will also ask you to create the DB in front of me. So, keep a text file “commands.txt” which contains all SQL commands that you used for this project. When I ask you to build the DB in front of me, all you need to do is to copy all the commands from the text file and paste them at one time into SQL Plus program.

Good Luck

اعملت الـ ER

وعملت الـ Map بس مو متأكده منها ..ش

هاي الي اعملتو بالمرفقات

الباقي ما عرفت اعملوو .... الله يخليكم ويوفقكم بكرا لازم اسلموا ساعدوني