WEEK 10 - ERD DEMO AND SOLUTIONS

Question 1

develop a database management system for the Alice Springs Music Centre (ASMC) ticketing system
- entities include concert, ticket, patron and seat

Answer 1

1. identify entities and attributes
   - concert: concert ID (PK), Concert Title, Concert Date, Concert Time
   - ticket: Ticket ID (PK), Patron ID (FK), Seat ID (FK), Purchase Date
   - patron: Patron ID (PK), Patron name, patron email
   - seat: seat ID (PK), seat Row, Seat Number
2. define relationships:
   - each concert can sell 0 or many tickets
   - each ticket allows attendance to one concert
   - each patron can purchase 0 or many tickets
   - each ticket is sold to one patron
   - each seat can be reserved on 0 or many tickets
   - each ticket reserves one seat

Example ERD:
- use lines to connect entities, showing the cardinality and modality