Drawio ER Diagram for Regional Cinema Company

Entities:

Theater $($TheaterID$,$ Name, City, State, PropertyValue$)$

Auditorium $($TheaterID$,$ AuditoriumNumber, Seats, ScreenSize, Speakers, SoundSystem, ProjectorModel$)$

IMAX $($AspectRatio$,$ Resolution$)($inherits from Auditorium$)$

Traditional $($SeatingType$,$ Aisles$)($inherits from Auditorium$)$

Staff $($StaffID$,$ Name, HourlyWage, HireDate, Tenure, Salary$)$

Relationships:

HasAuditorium $($TheaterID$,$ AuditoriumNumber, $1$:N$)$: A theater has multiple auditoriums $($identified by a unique combination of TheaterID and AuditoriumNumber$).$

ManagedBy $($AuditoriumNumber$,$ StaffID, N:M$)$: A traditional auditorium can be managed by multiple staff members, and one staff member can manage multiple traditional auditoriums.

Supervises $($StaffID$,$ SupervisedStaffID, N:M$)$: A staff member can supervise multiple other staff members, and one staff member can be supervised by multiple other staff members.

Assumptions:

TheaterID and AuditoriumNumber together uniquely identify an auditorium within a theater.

StaffID uniquely identifies each staff member $($usher or manager$).$

The Tenure attribute in the Staff entity is calculated based on the HireDate and the current date.

The Salary attribute in the Staff entity is specific to managers as ushers don't have salaries.

Drawio Implementation:

Create three entities: Theater, Auditorium, and Staff.

Define the appropriate attributes for each entity based on the provided information.

Use Crow's feet notation to represent the relationships:

One$-$to$-$many $(1$:N$)$ relationship between Theater and Auditorium $($Theater has the $"1"$ side$).$

Many$-$to$-$many $($N:M$)$ relationship between AuditoriumNumber and StaffID $($ManagedBy table, no need for additional entity$).$

Many$-$to$-$many $($N:M$)$ relationship between StaffID and StaffID $($Supervises table, no need for additional entity$).$

Use partial identifier $($AuditoriumNumber within the ManagedBy table$)$ to link traditional auditoriums and staff members managing them.

Use inheritance to create specialized "IMAX" and "Traditional" subtypes of the Auditorium entity, inheriting common attributes and adding specific attributes for each type.