Hi guys, it's been a long time since I've had to build a database and am struggling with one section for a seat reservation system.
I currently have 4 simple tables as follows:
Customer-
+CustomerID
-Surname
-Forename
-Telephone
Play-
+PlayID
-Title
-Author
-LeadActor
Playbill-
+PlaybillID...