Creating a table called Bookings

Business Rules: Each booking must have

  • Booking_ID [PK, Integer]
  • customer name [varchar, 100],
  • customer phone number [varchar, 15],
  • date of booking [char, 10],
  • booking start time [char, 4],
  • booking start location [varchar, 200],
  • Start postcode [varchar, 8],
  • booking finish location [varchar, 200],
  • finish postcode [varchar, 8],
  • achieved [Char, 1, Default 0]
  • assigned driver [FK, Integer],

Notes:

  • UK phone numbers are targeted to be less than 15 digits in length
  • UK Postcodes are up to 8 characters in length
  • Date is defined as “17-10-2017”
  • Time is defined as “1020”

Tutorial:

 

Creating a table called Bookings
Rate this post

    Comments are closed.