Part 1: Entity-Relationship Diagram (ERD) (10 Points):

Draw the Entity-Relationship Diagram (ERD) for your application to show the entities and relationships. Make sure to clearly show the following:

1- All entities (i.e., objects) that are needed to implement your application

2- Each entity must be identified by a primary key and described by a set of attributes.

3- List clearly all relationships between entities (Business Rules). For example, the relationship between Customer and Invoice entities is described as Each customer can have more than one invoice, however, an invoice can belong to only one customer.

4- Relationship cardinalities for all relationships in your ERD (1-to-1, 1-to-M, or M-to-M).

Part 2: Relational Schema (10 Points):

Convert the ERD that you designed in Part 1 into the corresponding relational schema. The relational schema should include the following:

Table names

Attribute names and data types

Primary keys

Foreign keys

Note: Use the tables that you identified in Project Step 1

Please make it copy and pastable

Project Hotel Booking System

Information needed I provided some table please add more.

Tables

Customer

Employee-

Rooms

Reservation-

Admin-

Please add more entitys

Customer (customer_id, customer_name, gender, city, street, state, zip_code)

Employee- (employee_id, employee_name,

Rooms (Room id, room_number, room_type)

Reservation- reservation _number, reservation_info

Admin- (admin_id, admin_name,)