• 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. Explain the difference between primary and secondary sources of data, with examples.

    The reliability of observational data collection methods is relatively low because observations are often personal and non-repeatable. Method: Participant observation Describe this method In participant observation the researcher would enter a group or situation who they were going to study, and try to get to know the group of people

  1. System requirements analysis

    Click on the cell under the drop-down menus, and click on 'freeze panes' Validation and Verification 14-11-06 Name ranges should be correct Some of the last names have not been selected in when I select the 'surnames' range Define the named range, ensure that all of the required data is now selected.

  2. Database design.

    You choose which fields you want to be in the form. Click next and the next window will appear. This window will ask what set up you want your form to be in I selected justified Basically this window asks you to select a background.

  1. I will design a new video database for the video shop that will also ...

    a mix of local official, knowledgeable individuals, members of impacted community regional officials, academic social officials academic social scientists.etc. - Can provide a broad analytical perspective on potential growth impacts - Can be used to reach consensus among groups hostile to each other Disadvantages * Judgements are those of a

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

    When someone returns a game they bring back the game to the counter. We then ask for their name and look through all of the cards till we find theirs. Seeing as there are approximately seventy cards in at all time, it takes a long time to find it.

  1. ICT Report 2b: ICT in Organisations

    Wireless keyboards are on the rise in the current market for keyboards; and I think this would prove to be an invaluable tool for managers writing reports and having to place the computer away from the desk to make more space.

  2. The information handling problems of MovieZone a small video rental shop in Stoke-on-Trent. The ...

    I have asked Hollywood Video Rental if he thinks this is a good idea and he agrees with me. He has also suggested that it might be a good idea if the new system could be used by his customers to choose records for their own discos.

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