database
design
appropriate validation rules
To make sure that any future addition to the database is valid, I have created several validation rules for some of the fields. Validation rules help the database function correctly and efficiently throughout its existence. Below are the validation rules I plan to have in the database.
rules for the CD entity:
| Name of field | Does it require a validation rule? | What is the rule? |
| CD Number | Yes | >L<LLL000000;;_ |
| CD_Title | No | - |
| Artist | No | - |
rules for the Order entity:
| Name of field | Does it require a validation rule? | What is the rule? |
| Order Number | Yes | >LL<L000000;;_ |
| CD Number | Yes | >L<LLL000000;;_ |
| Order Date | No | 00/00/0000 |
| NewCust_Title | Yes | Look-up Wizard |
| First Name | No | - |
| Last Name | No | - |
| Address Line 1 | No | - |
| Town | No | - |
| County | No | - |
| Post Code | Yes | >LL0\ 0LL;0;_ |
| Card Type | Yes | Look-up Wizard |
| Card Number | Yes | 9999999999999;;_ |
| Expiry Date | No | 00/00/0000 |
Click next to continue...