Customer+Order+Data+Dictionary+Task

An online furniture company stores details of its customers and the orders they place. Every customer has to have an e-mail address.



Notes: Customer Number is a number between 0 and 9999 Customer Title is either Mr, Mrs, Miss or Ms Order Number is a 7-digit number Catalogue Number is 4 characters, text and number The most expensive Item Cost is £1500 The maximum number of items (Number Ordered) is 10 items Order Date is stored in the form dd/mm/yyyy

Back to Data Dictionary Page