• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1102

My database is on a video rental shop.

Extracts from this document...

Introduction

Introduction: My database is on a video rental shop. My uncle Ronnie has been recording his data all by hand since 1982. He now wants to modernise his shop and record his video rental details on to the computer. He has asked me to create a database this will be created using Microsoft Access and this is my report on how the database was created. What will the database enable you to do when you to do? This database will enable me to: * See who took out the video * Which video they have taken out * When it is due back * If they paid or not * It will also let me focus more on the important aspects of the business, as the renting information will be much easier to access rather than me always writing the customers details when they rent a video from my shop. What data is needed? For this database to work well I will have to collect the following the data. ...read more.

Middle

* Then I have linked video ID from the table renting to video ID from the table video on a one to one relationship. Also linking these tables helps keep the information accurate as linking the tables enforces data integrity. I will link my tables together like this: * First I will drag customer id from the first table to customer id on the second and then video id on the second table to video id to the third table. 4. Describe how you put your plan for tables and relationships onto access. I will put my tables in my database by going to new and starting a new table. I will also add a primary key to all my tables. 5. Describe how you entered the data into your tables. I put my data straight onto my tables, as they were all ready set up to fill in the data. 6 Describe how you have searched (query) and reported any findings Have you clearly described what you were searching for? ...read more.

Conclusion

I realised this after showing it to my uncle Ronnie who owns a video shop. He said that it still is very helpful but can be improved a lot more, for example he said I needed to add something to my database that will enable me to check how many videos there are in the shop. For example, a person takes out "Romeo must die"; I need to find a way that will tell me how many "Romeo must die" films remain in my shop. All my tables were suitable as their names suited them and the fields were suitable for example I put "yes/no" fields in suitable places along with the others. After doing this basic database I have thought of many ways to extend my database further, but the main and most important one I have already explained above. another problem I had, was when I realised someone had been going through my files without my permission. at first I did not know what to do but then I realised I had password protection available so I used it. DATABASE REPORT Vipan Bagga 10c Mr Jogia ...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 Software 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 Software essays

  1. Planning a spreadsheet database for a gun shop.

    was made weekly or monthly My quantitative objectives were:- * Need to calculate the total amount of income each week, * How much profit/loss is made in the shop * How many phones are sold Solution I solved these problems and achieved my quantitative objectives by making Microsoft excel spreadsheet

  2. Designing a leaflet to advertise an electronics shop.

    This has to be an attractive leaflet, so I want you to add colour. Secondly there are far too many pictures of the products. I only want maximum of four on each page. Lastly I want you to put more detail about the company, such as email address, phone number, address and the company slogan: "because you're worth it".

  1. Database design for a games shop.

    But if you lose this book you lose your business so that is too much responsibility for a notebook as there is no back up. * My final solution is Microsoft database, I have done research and all good rental companies use this software.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    the first table just to show the user initially what to enter into the cells. Step 22 Once I had included all the formulas and data I wanted in my English worksheets - including reports and charts, I then copied all the formulas and data I had created, which are

  1. bookings database

    This is effective for the user because if fields are left empty, then the user will find it difficult to contact a guest, find the room they're staying in, the duration of their stay etc. Improvements I would make would be to clearly state what fields have been left empty as the current error message is not that clear.

  2. AQA GCSE ICT Specification B

    main menu will appear, as this is how the system is opened for administration. Refinements - Criteria 2 Criteria Details The database must be called 'Ducks System'. Evaluation The criterion was met. Evidence Limitations - Refinements - Criteria 3 Criteria Details Every button should work Evaluation Every button tested worked-

  1. Research, collect and describe graphics

    http://www.aria.co.uk/ http://www.comet.co.uk/ Target Audience People who want to navigate around help sites within the Paypal website easily People who want to navigate to other options within the Google website more easily. People who want to navigate through all of Aria's product areas in one quick place.

  2. ICT BTEC UNIT 2 - REPORT

    match for Xsite pro at a fantastic price of �197 and you get virtually the same thing. Xsite Pro also has fewer requirements than Adobe Dreamweaver which is a great advantage because like I said previously if you have a big system than your program is guaranteed to run a hell of a lot faster.

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