Employees (job category: secretary, technicians, workers, staff, and cook). Every Manager ensures the safety of guests and the quality of food served to them. Each hotel branch has three categories of rooms (Deluxe, Executive and Standard) reserve every day on or before 11:00 AM depending on availability.The room may be reserved with prior booking and to avoid next day payment the guest should check out before 12:00 PM. Mentioned the following in EER-diagram description; 1- Entity Types (Strong and Weak) with key attributes or partial key attributes(if any). 2- Relationship types with cardinality ratio(if any). 3- Subclass/superclass specialization type(total/partial/overlap/disjoint) (if any). 4- Category/Union type (if any). Draw the relational database schema for EER model drawn above with clear description of the following; 1- Primary keys of each relation. 2- Which relation uses the primary key of any other relation as a foreign key. 3- EER-Relation mapping algorithm.
Draw the EER diagram(step1-4 as mentioned below) of a company that organizes
reservation system for its hotel chain. Each branch is managed by team lead, Manager, with a number of
Employees (job category: secretary, technicians, workers, staff, and cook). Every Manager ensures the
safety of guests and the quality of food served to them. Each hotel branch has three categories of rooms
(Deluxe, Executive and Standard) reserve every day on or before 11:00 AM depending on availability.The
room may be reserved with prior booking and to avoid next day payment the guest should check out
before 12:00 PM.
Mentioned the following in EER-diagram description;
1- Entity Types (Strong and Weak) with key attributes or partial key attributes(if any).
2- Relationship types with cardinality ratio(if any).
3- Subclass/superclass specialization type(total/partial/overlap/disjoint) (if any).
4- Category/Union type (if any).
Draw the relational
description of the following;
1- Primary keys of each relation.
2- Which relation uses the primary key of any other relation as a foreign key.
3- EER-Relation mapping
Step by step
Solved in 2 steps with 2 images
