• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  • Level: GCSE
  • Subject: ICT
  • Word count: 3115

I have been employed as an ICT consultant for DVD rentals, a business that rents DVDs via the Internet. I will assist DVD rentals by creating a database solution for storing DVD rental and customer details electronically.

Extracts from this document...

Introduction

AO1- Design a relationship database to fit the need of the organisation: Scenario: I have been employed as an ICT consultant for DVD rentals, a business that rents DVDs via the Internet. I will assist DVD rentals by creating a database solution for storing DVD rental and customer details electronically. User Requirements: The manager of DVD rentals wants the database to do the following: * Store customer's details. * Store DVD details. * Record which customers have rented which DVDs. * Be able to hold, manage and retrieve data in the database. * Run simple and complex queries. * Be able to add, edit and delete a customer through the tables. * Be able to add, edit and delete a customer through the forms created. * Be able to sort the data into ascending or descending order. * Be able to get to whichever table, form, query or report through the User Interface. * Be able to create and print off reports when needed. * Be able to save the database. * Be able to work through the database using a friendly interface. Design of Data Tables: Customer Details Table: This table will be used to store all of the customer's details. Field Name Data Type Field Size (Text/ Number fields) Field Format (Date Fields) Validation/lookups/ combo boxes/input masks Customer ID Auto Number Long Integer None - data is entered automatically by the computer Customer ID will be the primary key for this table. This field holds each customer's unique ID number. Name Text 225 Characters None - These cant be used in this field This field holds each customer's name. Address 1 Text 255 Characters None - These cant be used in this field This field holds the first line of the customer's address. Address 2 Text 255 Characters None - These cant be used in this field This field holds the second line of the customer's address. ...read more.

Middle

I have placed the data entry boxes clearly and allowed for easy used by also having clear command buttons. Relationships: These tables are related through the following fields. <-- Database matches the design work undertaken: Customer Details Database: Design View: Data View: These databases match the design plans in AO1 because they match the specified field names, field size, data type etc. The result of this is that my table is now properly set out and understandable. Categories Database: Design View: Data View: These databases match the design plans in AO1 because they match the specified field names, field size, data type etc. AO3 - Interrogate the database: Sort on one table: The DVD ID has sorted this table into ascending order. One query using simple criteria: Design View: This design shows that I have made a query using simple criteria. The DVD rentals in March query, was created as part of a survey showing which month was the best for DVD renting. Data View: This data view shows all the rentals during the month of March. Multiple queries on linked tables: Design View: Using the design view it is clear that I have used multiple queries that are linked on tables. These are the DVD releases in March and April with a running time of over 2 hours. I did this query to show when new releases are most likely, and, whether or not the running time is over 2 hours. Data View: This is the data view of the table showing how the tables were used. Sort the second query on at least two fields: I have sorted this query on at least two fields. These are the Comedy DVDs with a running time of over 90 minutes. I did this query to find those Comedy DVDs which still have a longer running time as most modern films are now shorter than 90 minutes. ...read more.

Conclusion

It works as expected and everything is normal. None To see if I can print the forms out successfully Print it out and by using the print button I created. It should print without any problems and should fit on the paper It worked it has been successfully printed with everything on the paper. None To see if it is easy to understand and use I asked a friend to see if he could understand it and see if it was easy for him to use. It should be easy to read and he should be able to get along. As expected it was easy to use and read. None Reports: What am I testing? How to test Predicted results Actual results Comments I am going to test my DVD comedy's Report Create report for comedy DVDs with running times of more than 90 and print. It should show the comedy DVDs with the running time of more than 90 minutes. It has worked and has been printed everything fits onto the paper. None I am going to test my DVDs rental report I am going to run the report and see if customers who rented DVDs in March and print it. It should show the people who have rented DVDs out in March and if they have returned them or not. It has worked and everything was printed everything was fitted on to the paper perfectly. None I am going to test my DVDs running time query I am going to run the report and see if it shows me all the DVDs that had a running time of over 90 minutes and print it. It should show me all the DVDs that have a running time of 90 mins or more and it should be able to print. It did show me all the DVDs that had a running time of over 90 mins and the printing was also successful everything fat on to the paper. None ?? ?? ?? ?? Adam Graham Pike :) OCR National ICT Unit 7 3 ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Creating a computer system for a video rental shop

    * Digital scales (for weighing parcels) - so weights have been calculated accurately * Computer mouse - to select different function options. * Screen Touch Screen - to speed up the input of data and other functions within the database system.

  2. ICT Report 2b: ICT in Organisations

    A capacitive touch screen panel is coated with a material, typically indium tin oxide that conducts a continuous electrical current across the sensor. When the sensor's reference state is altered by another capacitance field, i.e., someone's finger, electronic circuits located at each corner of the panel measure the resulting 'distortion'

  1. Write up an Analysis for an ICT solution for an organisation that has a ...

    My client does not want any changes to the current method of recording orders. The orders are hand written on carbonated paper and the duplicate sent to the kitchen. However my client wants to change the way he records the week to week list that he has to do for

  2. Database design.

    Click next and the following window comes up. This window asks what you want to call your form. Type that in and hit finish and up comes your form. Your form: To change the form you click the design view button at the top left-hand side.

  1. Database Analysis and Database Design Project - DVD library for moving images.

    Validation should be used. The users should find the system easy and attractive to use. They should have the ability to produce ad-hoc queries and print out other reports with the confidence that they will be correct. All data entry screens should be user friendly, which will include well laid

  2. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    Once we have the card we have to cross there details out of it either using a pen or tippex. Finally we put the card back into the game case and leave it on the trolley to be put back.

  1. Designing a database to manage stock in a clothes shop.

    1.8 Advantages and disadvantages of PC way Advantages *More organization *Better product information *Quick research *Easier to change, add or delete products Disadvantages *Difficult to create such database *Problematic for people who don't know how to use access *Any miss-type may lead to serious problems 1.9 Advantages and disadvantages of

  2. Designing a database for a supermarket. The current main problem is that the manager ...

    This method consists of creating a spreadsheet using Microsoft Excel. While learning I discovered a all new way of using excel. I mean that if the company creates as spreadsheet and inputs the amount of the product, the expiry date and include a photo and a brief description of the product and where it is located exactly.

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