• 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
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  • Level: GCSE
  • Subject: ICT
  • Word count: 7576

Database Coursework

Extracts from this document...

Introduction

Task Description Dazzling DVD's is a DVD rental shop owned by Nicholas Smith, which many people visit when they want to buy or rent DVD's. The shop is situated in Ilford outside the exchange. They have many customers who would like to buy DVD's from there as they have cheap and affordable prices. The shop collects the information of the DVD's via phone calls, but they also get suppliers who come in person to give the DVD details or they get it on the web via emails. The details of the DVD's are taken: Name, age rating, release date, the barcode, the genre, the quantity and the description and the DVD. The details are taken down on a paper-based system by the receptionist. The name and age rating are important in any system to know which DVD's are allowed to be rented to which aged customer; the release date is needed so that the customer can see which DVD's have been released recently. The barcode, the quantity, the description and the genre are needed so that the suppliers can be contacted for any problems which need to be sorted out such as not the right amount has been delivered. Unfortunately, mistakes are common such as writing the wrong details because of bad communication on the phone. This can lead to big problems in the future because when the shop try and contact the supplier, they may end up calling a wrong number because of the receptionist's mistake. Sometimes, the receptionist doesn't even make a mistake in the details, but could be interpreted wrongly because of the bad handwriting. Another problem the company have faced is buying the wrong amount of DVD's. Because of the receptionist's writing the wrong amount of the DVD's may be ordered, once the details are sent to the suppliers, it cannot be changed. However, the main problem for the company arises when they are renting. ...read more.

Middle

Also the names of are not aligned and there are slanted this makes the form look unprofessional. In addition the form belongs to the Dazzling DVDs and the form does not have logo. I have changed the original form to a better one. I have decided that entering the customer details would be where the main data inputs are, which would therefore need a suitable form that would be linked to the data input screen. I created the data input from using Microsoft Access 2007 to enter all the data from. From this I created forms but one that will be used to store the data. I did this by using the switchboard manager icon. I have used a silver colour background because I think that it looks more professional. Also I used the Comic Sans MS font because it looks more bold and clear than the other fonts. This is a very simple and basic. Even though it has the essential details and the record operations and navigation bar is there the box sizes are not appropriate and that the sizes are really big and not necessary. Also the names of are not aligned and there are slanted this makes the form look unprofessional. In addition the form belongs to the Dazzling DVDs and the form does not have logo. Also the title is add a new DVD but you can delete a DVD and well as edit it so it is a bad title choice. I have decided that entering the DVD details would be where the main data inputs are, which would therefore need a suitable form that would be linked to the data input screen. I created forms but one that will be used to store the data. I did this by using the switchboard manager icon. I have used a silver colour background because I think that it looks more professional. ...read more.

Conclusion

Simple reminders: the reminders that show up at the start of the program should be simple to read. They should have a simple colour scheme, and shouldn't be too hard to close. The good thing about my system is that there are hardly any reminders that come up, and if they do, they're very easy to read. The good thing about my system is that it's very easy to manoeuvre around the system, so it saves a lot of time instead of spending ages doing nothing. Also, it's very easy to edit the information for each record since they're all in edit mode. However, this can also be a bad thing because it means that someone who's not authorised can easily change the information. Also, there are a lot of things that I need to do to improve my system such as creating a mail merge, or improving the queries that I've already created, and maybe creating more useful queries (that apply for books as well, not only customers). Also, my loan forms appear to have some sort of problem recognising the customers in the drop down bar. This is another thing that needs to be solved since loans are probably the most important part of my system. Some other ways I could improve my system is by using more useful technology such as Barcode Readers. This would speed up my system (especially when creating the loans) because it means that instead of typing in the name of the book, and the author and all the other details, it would automatically add them in because each barcode carries its own information. An0ther useful piece of technology I could use is Touch Screen. This would make it much better than using a mouse because it's more natural to use your hands rather than a mouse. This too would end up speeding up the process of the whole system. However, using a keyboard cannot be avoided because it would be needed when writing letters, or filling in the details of customers/books. ?? ?? ?? ?? ...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. Different types of technology How I use ICT at home and at school

    censoring system also stops people from accessing 'bad' or 'dirty' sites or pictures Summary of disadvantages * Censoring system is highly flawed, important sites like Google Translate are blocked * Research becomes hard to do with a lot of good sources being blocked * Computers crash really often * Computers

  2. Designing a Car Mechanic's Database

    text and number data types, as I will have things such as models, makes and drives (which will be text) and lengths, widths and heights (which will be number). I can also include gearbox, engine size and other measurements. The worker list will include things such as name, telephone, speciality, training and availability, most of which will be text.

  1. Creating a computer system for a video rental shop

    Studies showed users holding the mouse with their fingertips not palms, it could lead to pain in user's hand in long run 80W speakers Standard PC speakers to hear Audio output. It will take the sound being sent from the computer's sound card to allow the user to hear the sounds.

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

    * Word documents take time to load into the viewer. * If not all users have Word installed then seeing the Word document using Microsoft WordPad may be a less satisfying experience. Excel Advantages * Time-saving: Data is entered once and can be selectively linked to other data to use for many purposes (timesheets, reporting hours, etc.)

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

    Data Modelling (Learning outcome 1.1 and 1.3) Build a Conceptual Data Model of the system using Entity Relationship Modelling Techniques and produce the following: * Draw an Entity Relationship Model (ERM) for the system showing cardinality using Chen notation for the above narrative.

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

    When a game is loaned from 'HMV' the employee/manager removes the green card and writes the name and address of the person who borrows it. They also write down the date it is borrowed and the due date. Currently you have the game for three weeks.

  1. IT Project Evaluation. The design part of my wages system, data capture form, letterhead ...

    The other slides should consist of text based information, a few pictures, links to the other pages and external sources of information as well as my logo. The only exception to this is the page containing the data capture form, which will include my logo, links to the other pages

  2. Computer Studies Past paper definitions

    Buffer temporary store/memory holds data being transferred between devices often used to compensate for different speeds of devices examples printer, disk, etc.[2] 2006 (a) smart card integrated chip card data held in tiny silicon chip replaces the need for magnetic stripes harder for criminals to copy/change data used by banks, mobile phones, satellite TV receivers [2] (b)

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