Mr B Monk has asked me to help him develop a database system for his new upgraded video shop.

Data Needed

To develop the database I will need the following data:

> Customer's first name

> Customer's surname

> Address

> Telephone number

> Date of Birth

> Customer ID

> Video ID

> Video/DVD films

> Rating

> Genre

> Date borrowed

> Date returned

I will get this information from the video shop. My client will provide me with this data from their structure.

Field Size

Field type

In the customers table I also had to include field type. For the customer ID I decided to use 'auto number'. This means that when I type in the data for the customer ID the numbers will come automatically in ascending order. For the customer's first name, customers last name, address and phone number I used 'text' for obvious reasons. I decided to write the date of birth in 'date/time', so that it will be presented in that format.