Information Technology Management (Business Intelligence)
malmershed
ASGN-7-Template.xlsxEntities and Relationships
| ASGN-7 | |||||||
| [Your Name] | |||||||
| [Your email address: [email protected]] | |||||||
| Part A - Entities and Attributes | |||||||
| Theater | Auditorium | Entity 2 | Entity 3 | ||||
| PK | TheaterKey | PK | AuditoriumKey | PK | Entity 2 Primary Key | PK | Entity 3 Primary Key |
| Name | Name/Number | Attribute 1 | Attribute 1 | ||||
| Address | Attribute 2 | Attribute 2 | Attribute 2 | ||||
| City | . . . | . . . | . . . | ||||
| State | . . . | . . . | . . . | ||||
| Zip Code | FK | TheaterKey | |||||
| Entity 4 | |||||||
| PK | Entity 4 Primary Key | ||||||
| Attribute 1 | |||||||
| Attribute 2 | |||||||
| . . . | |||||||
| . . . | |||||||
| Part B - List of Relationships | Part C - Additional Amenities | ||||||
| Theater To Auditorium (One to Many) | Additional Amenities | Attribute | Entity | ||||
| General Admission (Adult), Matinee, Senior, Child | ? | ? | |||||
| VIP21, D-Box | ? | ? | |||||
| GiantScreen|Dolby Atmos | ? | ? | |||||
| Real 3D | ? | ? | |||||
| $5 Tuesdays | ? | ? |
Note: This is read as "One theater can contain many auditoriums, but an auditorium can only be in one theater"
