- Messages
- 73
- Reaction score
- 2
- Points
- 0
7 The following fields are to be stored.
• Customer name (to allow customer to be addressed properly when contacted)
• Customer telephone number (so that customer can be contacted when their order has
been completed)
• Date of original commission (so that customers are not kept waiting too long)
• Whether or not the order has been paid for.
(a) State a suitable data type for each of the four fields. [4]
(b) It is assumed that there will never be more than 1000 records
how to get the answer A and B
• Customer name (to allow customer to be addressed properly when contacted)
• Customer telephone number (so that customer can be contacted when their order has
been completed)
• Date of original commission (so that customers are not kept waiting too long)
• Whether or not the order has been paid for.
(a) State a suitable data type for each of the four fields. [4]
(b) It is assumed that there will never be more than 1000 records
how to get the answer A and B