• 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. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    The automatic date and time field tool allows you to automatically update the date and time, if you click the update automatically tick box. Every time you open the document the date and time will have been updated. This is very useful if used on a template as a template

  2. Different types of technology How I use ICT at home and at school

    interactive whiteboard through the projector and that is how an interactive whiteboard works. It emits an image from a computer to a screen and then allows you to write on the screen which acts in correspondence with the computer. What's special about the interactive whiteboard is in the name, its interactivity.

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

    1.4- Select data type. 1.5- Add any descriptions needed. 1.6- Then click the icon on the top left to see it in 'datasheet view'. 1.7- Then insert the name of the table. 1.8- Write in the data. 2. Create Form 2.1- Open Database. 2.2- Go to 'Forms' tab.

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

    You should save it on your PC's desktop or in 'My Documents' also it would be intelligent to save documents on two other or externel hard disks or send it to your own e-mail. The size of the file depends on the type, for example if it is done in

  1. Describe a wide range of technologies used by an adult in employment, with evaluation ...

    She will select the excel application when she wants to open up a saved customer quote. She will also open up word or power point when she wants to view a customer presentation. In her free time she uses excel for calculations which make it much easier for her.

  2. Implementation of my database for Emma's DVD rental shop.

    Now my business is doing well and more members are joining everyday. A new business park is due to open shortly. And I expect that lots of people who work there will come and use my rental shop and come and hire them during there lunch break and take them home in the evenings.

  1. GCSE Database Project ICT

    Service Pack 2 (2600.xpsp_sp2_qfe.070227-2300) Print technology Printing method 4-colour inkjet printer with Dual Black Ink System, Epson Micro Piezo(tm) print head Nozzle configuration 360 nozzles Black / 59 x 3 nozzles Colour (cyan, magenta, yellow) Droplet size 3 Pl (minimum)

  2. Database Design Guideline

    Fields Used Patient ID, forename, surname, gender and ward. Query Design - this is what the 3rd query will look like in my Microsoft access database document: Field: Patient ID Forename Surname Gender Ward Tables: patient patient patient patient patient Sort: Show: ?

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