• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

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

Extracts from this document...


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. ...read more.


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. ...read more.


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. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Planning a spreadsheet database for a gun shop.

    and making a V-LOOKUP table this is a good method of calculation two separate sheets for stock control and invoices so they are on 2 different pages and it's easier for Mr Aden to see and understand this information without losing it or making mistakes I also made these documents

  2. Designing a leaflet to advertise an electronics shop.

    All the pictures in the leaflet are the same size. The special offers are on last page of the leaflet. The leaflet is colorful and attractive, it also meets all the users objective which I was meant to achieve User feedback critical and relevant Dear Haseeb

  1. Database design for a games shop.

    Microsoft is also needed to write and print letters. Hardware The hardware that I require for this is a 3.06 processor because a lower processor is slower. A 4GB memory ram to enhance the computer's memory, a storage hard-drive with 2 GB capacity for transfer of files.

  2. AQA GCSE ICT Specification B

    I will implement questionnaires and discussion groups, as well as observing users doing their jobs to achieve this. Finally, I will decide upon the most economically viable and effective solution to the problem. Specification I will further detail the requirements of the system, addressing each one individually and planning exactly how the system will function.

  1. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    But I think you can improve it. I want you to add information that provides the customers with a map and some information about free delivery, vacancies, etc. After doing this I think that your designed application will be fine. I have also seen your designed logo for my shop I think you can improve that as well.

  2. Database analysis of 'a video lending library'.

    In this way it's easy to record the no. of customers and the no. of cassettes coming in and out of the shop. 2. Use cards: this is also another manual way of maintaining the shop. It is also an easy manual way.

  1. Excel - Analyse

    I will Use DDR Ram because it beats SD ram in terms of specifications and in performance. There are no advantages of SD ram, as DDR is now cheaper. Mouse A mouse will be needed to navigate around the system, and to operate the system.

  2. Project 1b; Film Database

    One thing that makes Excel partly suitable for this task is the typed in data enabled of being in a variety of formats.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work