 |
The Business Rules for the Database have been defined, and an Access Database is available on request.
Note that the Model shows 2 alternative tables -
All_Performance_Seats
Booked_Performance_Seats
The first is suitable for small venues,
where you might want to see the status of all seats,
and the second is suitable where you want to record only booked seats.
I don't like to see more than 3 fields
in a Primary key for a table, as there are in the 2 Performance
Seats Tables, but I have shown it this way because it makes
the logic obvious. They could be replaced by surrogate (Auto-Increment)
keys when the Data Model is turned into a Database.
Barry Williams
6th. January 2003
Principal Consultant
Database Answers
|
|
|
