• 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: 1639

The database I have created is for a movie shop. It will contain information about the members of the shop the information about the VHS's and DVD's.

Extracts from this document...

Introduction

A database is a quick, reliable way of storing data on a computer or a network. The old fashion way of storing data was in hundreds of paper files, this was very unreliable, time-consuming, and generally time more stress and hard work. With the aid of modern databases, you have the security of having back-up data ready in the event that the data is lost, you can find the data you need, usually with a click of the mouse and the most stress you will be under will be the stress of updating the data on a regular basis. A database usually consists of forms or tables with numbers and text. An example of database software, and usually the most common means, is Microsoft(r) Access. The database I have created is for a movie shop. It will contain information about the members of the shop the information about the VHS's and DVD's. It will help the user to identify all the members of the movie company and the movies owned by the store. When the database is completed, it will enable the user to search for a particular member or movie. It will also enable the user to put all the entries in any desired order. ...read more.

Middle

To change them, you have to click on the data type that you want to change: When you do this, a drop-down menu will appear with all the various data types. To choose one, simply click on it. A primary key in a table in a database is used to identify each record in the table. It has to be unique e.g. a member ID. You can allocate a primary key by first clicking on the field where you want to allocate the primary key and then clicking on the primary key button in the toolbar: After you click on the Primary Key button, you will see a picture of a key next to the field where it has been allocated: This means that the primary key was successfully created. Now, you have successfully created a table for your database. Next, click on the close button on the table screen: When you click on close, there will be a screen asking you to name your table. This is what the table will be called. Instead of filling in information into tables, you can make it easier by creating forms. To create a form, you have to click on the Create Form by Using Wizard button: This will help you to create a form using existing data from a table. ...read more.

Conclusion

Once you have dragged one field to another, you will see a screen similar to the one below: This screen is showing the fields that are going to be linked together. For the relationship to work properly, you have to tick all the boxes under the relationship. Once you have done this, click on Create. This will create the relationship. Once you have created your relationships, it should end up looking something like this: As you can see, I have also created two relationships, one for Member ID, and one for Video ID. The 1 and ? signs at each end of the relationship mean that the type of relationship we have made is called a 'one-to-many' relationship. Now my database is complete and I can start using it to help run a video shop. I think my database turned out exactly as I had planned. I think I used the right field names, data types, etc. I can now extend the database by adding a new table for, let's say, video games. I kept my data and system for errors using an AntiVirus Software package called Symantec Norton SystemWorks 2003: This is a very reliable software package and I also used it as a means to keep my work safe and secure. I also avoided data loss by saving my work on a removable disk regularly. ...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.

    * She wants the spreadsheets to be colourful. * The spreadsheet should include the name and logo of the store. * How many Guns are sold. * How much money is made. ANALYSE Analyse: Due to the fact that the staffs are not advanced with using computer, the spreadsheets will have to be straightforward.

  2. Database design for a games shop.

    comes in they just get any scrap paper in front of them and write down what was loaned and when and for how long then they put this paper in a folder. Sometimes they cannot find pieces of paper lying around so they make a mental note of it.

  1. Designing a leaflet to advertise an electronics shop.

    Such as in-depth product information of their products. E.g.: CD player value is �20 since last month. This will help me decide whether to leave it as it is, or put it in the sale section of the leaflet. Data manipulation: The newsletter will be two pages.

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

    shown in the previous steps, onto new worksheets, including reports and charts. This work was then used to create data for maths and science. I changed the results for each subject, and because I had included formulas which recalculated each function every time new data is entered, it automatically changed the rest of the worksheets.

  1. bookings database

    3. Easy to enter the names to be searched- when you click on the 'Find Guest details', a parameter box appears which clearly says 'Enter surname or part of it'. It is efficient for the user as it will save time instead of typing the full name they can enter part of it.

  2. A presentation for use at information kiosks by the patients at the health centre.

    the health centre would have to produce thousands, which could be quite costly. Also, leaflets can sometimes just be too informative, and people don't like reading them. I don't think it would be suitable for the reader's because many would be unable to read small print, and it would be too informative for them to read.

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

    5. The map will be taken from 'Google maps' and then edited in paint application and this edited image will then be copied and pasted on to the menu. 6. In order to make a logo I am first going to use 'google images and find a suitable picture

  2. Database analysis of 'a video lending library'.

    of cassettes in the shop only by the click of a button. The information can be easily stored in different databases so that information can be understood more accurately. There is also not much problem in using the database; there are many advantages in using the database as well.

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