Relational databases

Easy
123456789101112131415161718192021222324252627282930313233343536373839
Question 38
Easy

Festival Ticket Database

TicketStyle

TicketIDDescription
WK01Weekend Pass
DA02Friday Only
DA03Saturday Only
VIP4VIP Weekend

Guest

GuestIDNameEmailOver18
G082Sam Patelsam@email.comTrue
G119Leo Duboisleo@email.comTrue
G304Anna Schmidtanna@email.comFalse
G045Zara Ahmedzara@email.comTrue

Reservation

ReservationIDGuestIDTicketIDBookingFee
R001G082WK014.50
R002G119DA021.50
R003G304DA031.50
R004G045VIP48.00
R005G082DA031.50

State the most suitable data type for the BookingFee field in the Reservation table.

[1]

Relational databases Questions

  1. GCSE
  2. /Computer Science
  3. /Relational databases