• 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. a level ict project

    Address Line 1, to get the full benefits of this function, the exact address must be entered, partial entries won't give the proper information 4. Telephone number, once again the full 11 digits must be entered correctly, since it is a relatively large entry, errors are more likely Note: upon

  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. System requirements analysis

    If it were a large hospital a lot of storage would be required and the hospital may not be able to provide that. The information will not last for a very long time as it can get destroyed easily. The data cannot be altered and it is vital that a few back up copies are made, just in case.

  2. Creating a computer system for a video rental shop

    and a network with the computers and hardware devices must be established. As letters are handwritten at the moment some of them may not be understandable to read, to solve this problem I have decided to create and include a button within the database programme which will be linked to

  1. Moviezone video rental system.

    edited and stored quickly, easily and accurately; � allow video details to be searched to answer customer enquires quickly and easily; � produce a list showing the videos due back each day; � produce a summary report showing the member and video details for videos still overdue at the end

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

    Our first and most important problem is that it takes too long. When someone wants to take a game out we have to have to take the card out of the games case. Then we write all the appropriate information on it and store it away.

  1. Database design.

    I am able to change, edit or delete a record. How to use a form To fill a form in first you need to fill in the empty boxes.

  2. Database Design Guideline

    ? ? ? Criteria: "male" "green" Or: o Query 4 Table Used Doctor Query Criteria Doctors specialising in ENT and working in the orange ward. Expected Result Records of all Doctor's in the orange ward and specialise in ENT's should be returned.

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