Business Data Analysis, Entity Identification and E R Diagram

PatronsPatrons

SeatsSeats Seat CategorySeat Category

ProductionProduction PerformancePerformance

TicketTicket

Patron_IDPatron_IDPKPK

First_NameFirst_Name

Last_NameLast_Name

Addr1Addr1

Addr2Addr2

CityCity

StateState

ZipZip

PhonePhone

EmailEmail

Seat_NumSeat_NumPKPK

Seat_CatSeat_CatFKFK

SCat_IDSCat_IDPKPK

SCat_NameSCat_Name

SCat_PriceSCat_Price

Prod_IDProd_IDPKPK

Prod_TitleProd_Title

Prod_TypeProd_Type

Perf_IDPerf_IDPKPK

Perf_ProdPerf_ProdFKFK

Perf_DateTimePerf_DateTime

Perf_TypePerf_Type

Ti cket_IDTi cket_IDPKPK

Ti cket_PatronTi cket_PatronFKFK

Ti cket_PerfTi cket_PerfFKFK

Ti cket_SeatTi cket_SeatFKFK