Please give a step-by-step answer. The ER Diagram must contain the ER-Diagram Symbols. Design an EER diagram for an Hotel Management System. The hotel wants to keep track of all their employees, customers, bookings, rooms and services. They have hired you to help them design the database for that purpose. You can design your EER as you wish, but it must satisfy the following constraints: a. there should be at least one overlapping-partial specialization/generalization. b. There should be at least five regular/strong entities [excluding subclasses] c. There must be a recursive relationship. d. There must be at least one 1:1 relationship. e. There must be at least one multivalued-composite attribute. Show all important attributes, entities and relationships in order to represent a clear and complete scenario. The EER diagram should be logically accurate and realistic, representing the database of the given scenario.
Please give a step-by-step answer. The ER Diagram must contain the ER-Diagram Symbols.
Design an EER diagram for an Hotel Management System. The hotel wants to keep track of all their employees, customers, bookings, rooms and services. They have hired you to help them design the
You can design your EER as you wish, but it must satisfy the following constraints:
a. there should be at least one overlapping-partial specialization/generalization.
b. There should be at least five regular/strong entities [excluding subclasses]
c. There must be a recursive relationship.
d. There must be at least one 1:1 relationship.
e. There must be at least one multivalued-composite attribute.
Show all important attributes, entities and relationships in order to represent a clear and complete scenario. The EER diagram should be logically accurate and realistic, representing the database of the given scenario.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
