Your Status: Logged out Log in

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

Member rating: No Rating | Words: | Submitted: Mon Mar 22 2004

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

Database Report!!! User Requirements Mr B Monk has asked me to help him develop a database system for his new upgraded video shop. I will do this by using 'Microsoft Access'. This will hopefully give my client a clear understanding of what videos each customer has taken out and which customer has returned or not returned the videos. This will enable my client to analyse the data and will also be able to see visually what videos have been taken out? 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...

Get instant access



  • Instant, unlimited access to our documents in full
  • Swap your work for free access, or pay £4.99
  • To see the full version of this document and 150,112 others
Register Now