|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
name one register involved in the fetch part of the fetch-execute cycle Customer Details Table 1. Customer ID is unique 2. First Name must be no more than 20 characters. 3. Surname must be no more than 15 characters. 4. Street and House No must be no more than 20 characters. 5. Town must be no more than 20 characters. 6. County must be no more than 20 characters. 7. Post Code not null 8. Phone No not null Customer Order Table 1. Customer ID number must be in Customer details table. 2. Customer order Number must be unique to a customer. 3. Customer order number must be only 5 digits. 4. Paperboy/girl ID must be in paperboy/girl table. 5. Date must be a valid date. 6. Date must be equal to or less than today. Cost of newspapers 1. Total cost, nothing needs to be done as it is calculated automatically 2. Cost of delivery, nothing needs to be done as it is calculated automatically 3. Individual Cost of newspapers, nothing needs to be done as it is calculated automatically 4.
Approximate Word count = 676
Approximate Pages = 2.7
(250 words per page double spaced)
|
|
|
|
|
|