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:
- Screenshot: Create a table in Oracle
- Screenshot: Add a Primary Key and a Trigger (auto-incrementing)