Hello,
I am looking to try and have a SeatID that is composed of two attributes, SeatID (A1, A2, B2, etc) and PerformanceID (an abbreviation of the specific performance. How can I create a primary key attribute that pulls and combines these two into its own primary key?
Would I create entities for Seat and Performance, then another entity for the TICKET (combination of the two) have them as foreign keys, and shift click them both to be primary keys?
Basically I want to create this entity that keeps track of each seat in a theater for each performance, and then a sold YES/NO or checkbox too. And each time a new performance is scheduled I want this entity to automatically have the seats populate.
Is this possible?
I am looking to try and have a SeatID that is composed of two attributes, SeatID (A1, A2, B2, etc) and PerformanceID (an abbreviation of the specific performance. How can I create a primary key attribute that pulls and combines these two into its own primary key?
Would I create entities for Seat and Performance, then another entity for the TICKET (combination of the two) have them as foreign keys, and shift click them both to be primary keys?
Basically I want to create this entity that keeps track of each seat in a theater for each performance, and then a sold YES/NO or checkbox too. And each time a new performance is scheduled I want this entity to automatically have the seats populate.
Is this possible?