• 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

    This wastes our quality lesson time and also makes working on the computers quite slow and difficult. Computers are extremely restricted. While this is done to prevent trouble, it prevents a lot of normal day computer use from happening. It also makes it harder to deal with errors due to the restricted computer's limited settings.

  2. Creating a computer system for a video rental shop

    Repetitive strain injury (RSI) is a common complaint of keyboard users ans a comfortable wrist posture helps to avoid it 3 button mouse A very common handheld pointing device it allows the user to navigate applications and icons. The mouse will allow the user to do tasks like selecting, drawing, scrolling pages and many other useful tasks.

  1. 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.)

  2. ICT Coursework (MarcoS)

    All the computers will have backup every week, into an external hard disk, to save all the data in a safety place that is difficult to be infected by viruses and to be hacked. Also the external hard disk will be protected by a password.

  1. GCSE ICT Coursework Write-up

    It can also be used for storing information which may be used to help diagnose illnesses or to look at patient's or family of a patient's history of diseases or illness. In all of these cases there could be a crash in the system, which if there were no support staff to look after the system would cause major problems.

  2. 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.

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

    Currently you have the game for three weeks. These green cards and then stored in a box in the managers office. The oldest loans will be at the back of the pile and the newer loans will be at the front. The employee/manager then stamps the piece of paper inside when the game should be due back.

  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