Design ER Diagram for a hotel reservation database, your ER Diagram should include the following: * Hotel * Hotel Branch * Room * Customer * Employee * Supplier: supplies beds, bed sheets, pillows,...

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



* Hotel



* Hotel Branch



* Room



* Customer



* Employee



* Supplier: supplies beds, bed sheets, pillows, ... etc



* 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.