• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

What is a database?

Extracts from this document...

Introduction

Databases The concept of what is a database is not exactly taxing in theory, but sometimes it is difficult to visualise what one is. The easiest example that you will be aware of is that little book full of all your friends telephone numbers and addresses. For each of the entries you will record the name, address and telephone number of each person in the book. What you have done is to create a "record" of that person's details, so when you fill in one entry you create 1 record. Of course a little book like this will hopefully not contain just one person's details (although I have to admit that my own social circle is not much larger than 1, my last telephone bill was a little under �3). You will probably enter at least 20 or so people, so you have 20 or records and this makes up a "file". So a file consists of lots of records, and each of the records are made up of name, telephone and address, these 3 things are known as "fields". Not exactly exciting stuff but the definitions are important. In your time you have probably received numerous forms to fill in and may have had a form that is made up of lots of little boxes that you have to fill in with capital letters and only in black ink. ...read more.

Middle

time you have finished looking through, it will have got dark and your mum will be telling you to come in for your tea (or something)!!! How I bet you wished that you had a computerised database, you could have just typed in a query like find all records where town=Folkestone (assuming that you live in Folkestone of course). Hey presto, you have a list really very quickly and with a quick jog down the road I'm sure that the snog will follow. This may not be the sort of example that an exam is going to test you about, but it is a little more interesting than what happens with databases in the real world. Normal examples of databases are maybe a debt collector searching through a database of thousands of clients who owe him cash and then sending round a large man to break their legs. I mean these large men cost lots of money so sorting through bits of cards by hand would not be cost effective. OK, so this isn't the best real world example so if you want one imagine a dentist searching through his records to find those customers who have appointments in the next few weeks and just sending out letters to them. Happy now? The whole point is that you can search a database to find those people on the database who match a certain criteria like they owe money, have appointments due or live in certain towns. ...read more.

Conclusion

OK, so at this stage we have thought about the length that a field needs to be, what type of field that it will be and if the field will need to be coded. Now here comes the absolutely essential bit. Every time that I teach a group of children I always try to emphasise this point about 6 or 7 times, however there are always a few who manage to completely ignore this request and just plough on into their projects regardless. When you build a database you will have to have a "key" field and this is going to have to be unique. Let me explain, in our school there are 3 children with the name Christopher Smith and each of them needs an user id to log onto our network. User ids in our school are given out by putting the surname first and then the initial of the first name, for example David Jones would be JONESD. But we have a problem when there are 3 Chris Smiths. So we have a SMITHC, a SMITHCH and a SMITHCHR. What this means is that every person on our network has a unique user id to log on with. The same has to be true of your database. The very first field in any database that you decide to set up must be such a key field, otherwise confusion will be caused if 2 people have the same name. ...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. Database Hajj&Umrah travel agency

    a software program called Microsoft Access, which is a very respectable and accurate program for entering data onto a database. The data can then be analysed or changed to suit the users' needs. It is a highly versatile software program, which is used by many businesses and companies.

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

    in a bar chart, as it displayed the different percentage bars for each subject against the student name. Once I had selected the chart type I wanted, I clicked "next." 3) A table showing a preview of your chart is displayed, so that you can check to see if it is correct before you produce it.

  1. bookings database

    An improvement is to add the 'Return to main menu' command button on this form as well. An improvement I would make would be to add 'Return to main menu' command button- this would be more effective for the user as it would be easier to return back to the main menu.

  2. AQA GCSE ICT Specification B

    Combo Box: Allows a limited selection of responses available to the user. It is quicker to find the chosen answer and prevents the user typing invalid data. Useful in details such as Colour and Payment type. More convenient than a list box as it takes up less room on the

  1. Powerpoint review project

    I will do this by going to Slideshow > Slide transition and choosing the options that I want for the slide timings. Action Buttons I will use these for my slideshow. These will navigate back and forward between the slides.

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

    pasted in the menu so that they suit the environment of the menu. 4. All the contact details will be taken from Mr. Hussaini and then entered in the menu as text using the keyboard; these details will help the customers to easily contact Mr.

  1. Spreadsheet for a basketball company

    Conditional formatting will symbolize the seat in the form of specific colours according to its type and the drop down list will speed up the process at which the user can assign a seat type. An alternative form of output would be to have a list of available seats and then marking the seats individually as they get booked.

  2. Analyse - Database

    Excel can be used as a database however it is more suited to performing calculation or 'data modelling' functions. In Access or FlexiDATA there are complex searches called queries, which produce quality reports and convenient data entry forms. You can also improve the database by making it 'relational'.

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