Business Data Analysis, Entity Identification and E R Diagram

Patrons Entity

Attribute Data Type

Patron_ID Int PK, auto increment

First_Name Varchar(50)

Last_Name Varchar(50)

Addr1 Varchar(50)

Addr2 Varchar(50)

City Varchar(50)

State Varchar(2)

Zip Varchar(5)

Phone Varchar(10)

Email Varchar(100)

Seats Entity

Attributes Data Type

Seat_Num Varchar(3) PK

Seat_Cat Int FK (Seat Category Scat_ID)

Seat Category Entity

Attributes Data Type

Scat_ID Int PK, auto increment

Scat_Name Varchar(50)

Scat_Price Decimal(5,2)

Production Entity

Attributes Data Type

Prod_ID Int PK, auto increment

Prod_title Varchar(100)

Prod_type Varchar(100)

Performance Entity

Attributes Data Type

Perf_ID Int PK, auto increment

Perf_Prod Int FK (Production Prod_ID)

Perf_Datetime Datetime

Perf_Type Varchar(20)

Ticket Entity

Attributes Data Type

Ticket_ID Int PK, auto increment

Ticket_Patron Int FK (Patrons Patron_ID)

Ticket_Perf Int FK (Performance Perf_ID)

Ticket_Seat Varchar(3) FK (Seats Seat_Num)