Design - In my project I am using three tables, the customer table, the hire table, and the stock table.

Authors Avatar

Design

In my project I am using three tables, the customer table, the hire table, and the stock table.  Below I will sketch out an outline of the tables.

Customer

  • Customer No – Autonumber to represent the customer ID number
  • Title – Title of customer.  Lookup for Mr, Mrs, Miss, Sir and Rev.  Defaults to MR.
  • Initial – Customer’s first initial
  • Surname – Customer’s surname
  • Address – Address of customer
  • Post Code – Postcode of Customer
  • Phone Number – Phone number of customer.  Validation to make sure length is equal to 12
  • Ward Number – The ward in which the patient stayed/is staying.  Lookup for the 10 wards
  • Discharged – Whether or not the patient has left the hospital

Hire Table

Join now!

  • Item ID – Lookup to stock table for the ID of a stock item
  • Individual Stock Number – The stock number of the particular item
  • Customer No – Lookup to the customer table for the customer id number
  • Status – Current status of the item, available, on loan, or in for repair

Stock Table

  • Item ID – Two letter mnemonic code for item e.g. WJ for wheelchair – junior
  • Description – A description of the item e.g. Wheelchair – Junior
  • Cost Of Replacement – The amount of money required to replace ...

This is a preview of the whole essay