DATABASE ASSIGNMENT 2
[YOUR NAME]
[YOUR STUDENT NUMBER]
Tutor: Robert Evans
CUSTOMER
Field name | Data type | Length and format | Description | Validation | Primary Key |
Customer ID | Short text | 7 | A unique code that identifies the customer | C##### “Please type in C followed by 5 numbers” | Yes |
Title | Short text | 10 | The title of the customer | Drop down menu with choices | No |
First name | Short text | 14 letters | The first name of the customer | IS NOT NULL | |
Last name | Short text | 19 letters | The least name of the customer | IS NOT NULL | |
Address | Post code followed by street name and city | 69 letters | Where the customer lives | IS NOT NULL | |
DOB | Date and time | Short Date | Date, month and year | ||
Gender | M OR F | 1 letter | What gender is the customer | Is not null | |
Picture | OLE object | OLE | I | ||
Hyperlink | Hyperlink | Hyperlink | |||
Product ID | Foreign Key |
STOCK
Field name | Data type | Length and format | Description | Validation | Primary Key |
Films ID | Numbers | 3-30 letters | C##### “Please type in C followed by 5 numbers” | ||
Title | Short Text | 4-20 letters | The name of the movie | ||
Star | Short Text | 8-40 letters | A rating from 1-5 | ||
Director | Short Text | 8-60 letters | The name of the person who directed the movie |
| |
Year | Number | 4 | Any time from 1929-2017 | ||
Rating | Number | 1-5 stars | Good or bad | ||
Genre | Short Text | 4-15 | |||
Price | Number | From 0.01 to 99.99 | |||
Distributor | Short Text | 5-25 | |||
Language | Short Text | English |
SUPPLIER
Field name | Data type | Length and format | Description | Validation | Primary Key |
DESCRIPTION OF MY DATABASE AND ITS PURPOSE AND USER REQUIREMENTS
The purpose and user requriments
MY DATA DICTIONARIES
SCREENSHOT OF MY ENTITY RELATIONSHIP DIAGRAM
SCREENSHOTS OF MY FORM DESIGNS
MY TEST PLAN
(You will be doing the testing in assignment 3)