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

    that flash phones were facing and how I helped them and the manager out. The problem brother john was facing was: * Finding the calculations of how many phones they have, * Calculating how many they sell over a period of time * The amount of profit or loss that

  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.

    This is the ideal solution for MR. Walcott's problem. Database is the fastest and most efficient option available to me. He can easily search his system by simply entering the name of the customer or the name of the game and see how long it's been loaned or who has got it.

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

    The reason I decided to add a filter into my spreadsheet, was so that the teacher was easily able to see which students needed help in particular subjects, as it allows the teacher to filter particular subjects and know which students need help in that area.

  1. bookings database

    Other command button should be on the bottom/side- the main menu's command buttons are in the same place. This is because they are in a chronological order and are placed in order of use. This is so it is easier and more effective for the user when a guest books a room.

  2. Research, collect and describe graphics

    People who want to navigate through Comet's 'Kitchen and Homes' product areas in one place. Suitability to Purpose Suitable because the nav. Bar is located in the home-page, hence guiding novices from the start. Suitable since everything is located on the homepage.

  1. ICT BTEC UNIT 2 - REPORT

    website which the user can expand and change things he or she wants to this helps the user learn from what he or she has done and what each tool helped him or her achieve. This program is supported by many advanced technologies such as HTML, Java Script, ASP.NET and many others.

  2. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    User comments and action taken: After looking at the user comments I had to add some information and change the logo of the menu, which was done successfully. Now the menu contains the map, some information about free delivery and availability of vacancies, it also contains some information useful to new customers.

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