Zoom
Choose an option to filter: All Departure places
BoatID
BoatName
Seat
Booked
DepartPlace
Name
Ticket Type Is full?
B001
Sug
12
3 Ha Noi
Standard
B002
Mil
10
6 Ho Chi Minh
VIP
B003
App
5
5 Da Nang
SuperVIP
X
B004
Roo
7
6 Ha Noi
VIP
B005
Bee
11
4 Ho Chi Minh
SuperVIP
B006
Boo
9
7 Da Nang
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 Tyne is taken in the [TicketNamel of the [Tickets] table that corresponds to the
+ 100%
Close
