BoatID BoatName Seat Booked DepartPlace Name
X
Zoom
B001
Sug
B002 Mil
3 Ha Noi
6 Ho Chi Minh
Standard
VIP
B003
App
5 Da Nang
SuperVIP
B004
6 Ha Noi
VIP
Roo
4 Ho Chi Minh
Bee
SuperVIP
B005
B006
Boo
12
10
5
7
11
9
7 Da Nang
Ticket Type Is full?
Standard
• Display the interface as above (excluding data taken from the database) (0.5 point)
• The "Choose an option to filter" selectbox must load data from [DepartPlaces] table. (1 point)
Reduce 1 point if cannot display departplaces (including "All Departure places" option) to the selectbox.
• The table must load data from [Boats] table (1 point) and add some more requirements:
DepartPlace Name is taken in the [DepartPlaceName] of the [DepartPlaces] table that corresponds to the DepartPlaceID in the [Boats] table. (0.5 point)
Ticket Type is taken in the [TicketName] of the [Tickets] table that corresponds to the TicketID in the [Boats] table. (0.5 point)
"Is full?" column: if seat-booked, display "X". Otherwise, nothing is displayed. (0.5 point)
2. When users select an option in the "Choose an option to filter" selectbox, load all information of the boats that their DepartPlace Name equals to the selected option to the table. (1 point):
+ 100%
Close
