I have created the SeatZone table in the database.

Here is my SeatZone table:

CREATE TABLE SeatZone (
ZoneID char(10) NOT NULL,
HallID char (9) NOT NULL,
TheatreID char (5) NOT NULL,
ZoneSeat varchar(1) NOT NULL,
ZoneVacancy int NOT NULL,
CONSTRAINT PK_SeatZone PRIMARY KEY NONCLUSTERED
(
ZoneID
),
CONSTRAINT FK_SeatZone_HallID FOREIGN KEY
(
HallID
) REFERENCES Hall (
HallID
),
CONSTRAINT FK_SeatZone_TheatreID FOREIGN KEY
(
TheatreID
) REFERENCES Theatre (
TheatreID
)
)
GO

For the ZoneSeat column, I am thinking of inserting the Seating Zone of the theatre hall. E.g: A, B, C etc. However, I realize that how am I suppose to insert all the various zones? I can’t possibly insert all in a column. Thus I am thinking of the other way like having 2 columns. One of it is the StartingZone and the other is that EndingZone. E.g A – J; StartingZone will be A and EndingZone will be J. Then there’s problem arise again. How to retrieve these Zones in such a way that all A – J Zones can be display in the dropdownlist?

Hope that you guys can understand what I mean.

Pls: reply asap. Thank You!