Blends Record Company
| Field Name | Data Type | Field Length | Validation | Description |
| ID | ||||
| Artist | text | 25 | preferred name | |
| Surname | text | 25 | ||
| Forename | text | 25 | ||
| Date of Birth | date | 10 | <=now() | |
| When Signed | date | 10 | <=now() | |
| When contract expires | date | 10 | >=now() | |
| Music genre | text | 25 | preferred genre | |
| Gender | text | 1 | ||
Advertisement
curtt1 said,
October 19, 2006 at 1:47 pm
This is a good start to your database. I like the way you have used now() in your validation. To improve further you need to add some other validations (maybe one for a text field and one for a number field) and make sure that ID has an autonumber datatype.
Grade 3: Good