• 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. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    or to show an error alert, which tells the user they have typed something incorrectly into the cells (this is referred to as the "error alert.") Once you have typed in your input message (this one is optional) and your alert message, you press "ok."

  2. bookings database

    Presence check- this is a check to make sure that the required fields are filled in. This is effective for the user because if the details are not filled in then the user will not be able to book a room correctly.

  1. AQA GCSE ICT Specification B

    For instance, a credit card number can only have 16 characters. If a user added an extra character by mistake, the system would recognise this as a 17th character and not allow it. Format Check Applies To Email Address Postcode Evidence of Implementation Justification A format check ensures that the

  2. Powerpoint review project

    As a result of these comments the changes that I will make are that I will add a wider and colourful range of colours for the slides. Final Design The picture above is my final design for my slideshow front page. This is what my main slide will look like.

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

    Here are some of the backup devices that can be used: 1. Floppy discs: since floppy discs are small and portable, data can be easily transferred from one computer to another, this is an advantage but as they do not have a very high storage capacity, they are seldom used for backup.

  2. Spreadsheet for a basketball company

    In addition, I can automate the total available seats using the values obtained from the COUNIF formula explained above. Graphs will need printing for the purpose of Mrs Suprabha, the manager. An inkjet printer will suffice this job eloquently. An alternative is the laser printer, which can produce high quality text and graphics in an instant.

  1. Analyse - Database

    A relational database application such as Access is better than a flat file database programme, such as Excel because it means spending less time on data entry and fewer errors. Access is not the only relational database application; you can also link tables in FlexiDATA too.

  2. Project 1b; Film Database

    be based on the question what the best action movie with Jet Li is being in stock. To find out this I will use the following query: This query will show the best movie with the highest rating on top, which are in stock, and so I only need to look at the top film to find the answer.

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