Relational databases

Easy
123456789101112131415161718192021222324252627282930313233343536373839
Question 32
Easy

Beverage

BeverageIDNameCategoryPriceCustomerRating
B01EspressoCoffee2.504.65
B02LatteCoffee3.204.12
B03Green TeaTea2.803.80
B04Hot ChocolateCocoa3.504.35
B05ChamomileTea2.904.05

Transaction

TransactionIDBeverageIDOrderDateQuantityTakeaway
T101B0118/11/232True
T102B0318/11/231False
T103B0418/11/231True
T104B0119/11/233False
T105B0519/11/232True

State the most suitable database data type to use for the CustomerRating field.

[1]

Relational databases Questions

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