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):
Choose an option to filter: Ha Noi
BoatID BoatName Seat Booked DepartPlace Name Ticket Type Is full?
B001
Sug
3 Ha Noi
Standard
Zoom
+ 100%
12
Close