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

    different point of view, so using interviews or questionnaires along side this research method is advised. This research method is very time consuming as to collect valid information, as the group would need to be studied for a long time.

  2. Access Database

    With more tables, there could be more forms. More different subjects, and so the database can be made. The main reason was so I can create relationships. The reason for the relationships are so I can relate or link the tables with each other.

  1. a level ict project

    These tasks range from how to start up the application to troubleshooting errors that are most likely to occur, and including numerous other essential tasks that allow efficient as well as effective use of the system. Getting Started This chapter dictates the first steps into using this system, illustrating the

  2. System requirements analysis

    The drawbacks of using Microsoft Excel is that when you are using the formulas then you have to learn about the special signs and how you have to write something for the computer to do something. Another disadvantage of using Microsoft Excel is that it does not look very nice

  1. Creating a computer system for a video rental shop

    * Analysis of the documents used to record information about how to record information about members, videos and borrowing .etc * Analyse all the existing documentation such as reports, letters, and transaction. etc * Identifying data which may be internally generated within the system.

  2. Database design.

    will be like this when you click on it: Creating a relational database When all the tables have been created then we have to create a link between the tables; this is called a relational database. To do this I must click on a button on the toolbar at the

  1. Moviezone video rental system.

    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.

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

    If you need more sophisticated form processing than FrontPage provides, you can still use Transform or custom CGI programs with the forms you create in FrontPage. * Web searches: FrontPage Server Extensions provide a simple web search engine. Searches are confined to your FrontPage web or subweb.

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