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

Library system

Extracts from this document...

Introduction

Planning my database Introduction: I first needed to know who I was doing it for. It was the librarian at my school Mrs Flude she wanted to keep the information where it was safe and easy to access which would make it faster for her and the students. The two main problems of the current system are: 1st problem: They have to use an index to find books, and this is slow and very inefficient. 2nd problem: They use a card index to keep all the information needed about the students and to keep track of which students have books, this method is not reliable because you can mess up or mix up the cards or lose them and it also takes a long time which leads to inefficiency. The solution to fixing these problems is creating a database; a database is a collection of information stored in a computer in a systematic way, such that a computer program can consult it to answer questions. Before I started using the computer to make my database, I made a rough copy of what I wanted my database to look like and how it would function. It was a table which I had to fill in with information about my database. I wanted my database to be reliable and fast, to make it fast I had to make it simple and easy to use. ...read more.

Middle

This information will help the librarian find who has an overdue book and were to find him/her. Field name Data type Data Format Data size Why is this data important Student number Auto number Number Up to 1500 It makes issuing books easier Students name Text Text Up to 50 To know who has borrowed a book Sex Text Text Up to 1 Helps with surveys regarding with which books appeal to the sexes Address Number & text Number & text Up to 100 To trace overdue returns Form Number and text Number & text Up to 20 Again to trace late returns I then did a table for issues as shown below: Field name Data type Data Format Data size Why is this data important issues id Number Number Up to 1500 To know which issue you are dealing with student id Number Number Up to 1500 To know which student borrowed a book book id Number Number Up to 10000 To know which book was taken out date borrowed Date Date Up to 12 To when the book was taken out date due back Date Date Up to 12 To know when the book should be returned Above is the third section of my database, which is the 'issues section', this section is necessary because it shows which books have been taken out and who has taken them out and the details of the book and the person who has borrowed the book. ...read more.

Conclusion

In my database I made the 'Book ID', 'Issues ID' and the 'Student number' unique or primary keys. To do this I had open a table in design view and then selected the field I wanted to make a primary key and I then clicked on the primary key symbol on the toolbar. ABOVE: is the highlighted Book id to its left is the primary key symbol. This is the student number. Above is the issues ID. As I mentioned above that my database was inefficient because when you made any changes you had to repeatedly key in those changes in other tables, to get around this I had to make my database 'Relational', a relational database is a method of structuring data as collections of tables that are logically associated to each other by shared attributes, a relational database has the flexibility to generate new tables from existing records that meet specified criteria. With my database I decided the following criteria to have a relationship: In the student table, the student number field has a 1 next to it. This means that the entry in that field can only appear once. The same is true of book ID in the books table. However, both of these fields can appear many times in the issues table (hence the infinity sign being next to them). This shows that one student can take out a variety of books and that one book can be taken out many times. ?? ?? ?? ?? NAME: Tonderai Chinodyaruswa REG. NO: 1028 BABINGTON CENTRE NO: 25112 02/05/2007 ...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. Documentation of a database for a sports centre.

    it will help the actual computer and human user understand the commands. We use fields to make up a whole piece of information on the member. For example, one field may be for their name another may be their postcode.

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

    He wants me to give him solutions for his problems and also he wants me to choose the best solution for his problem. Hence I did my research and came up with the following ideas. These solutions can also be used by any other video lending library; hence these are my target audience for this project.

  1. Evaluating a relational database solution

    I had to work out what the short date was, whether it was '<' or '>' sign, and where the boundaries where for different years. 'And', 'or' and 'not' searches were easy to do as I only had to type 'and', 'or' or 'not' in from or between the information I was searching for.

  2. Database design for a games shop.

    It cuts out the mistakes which will aid blockgamester if they are in a rush or forget to enter something. Data validation Data will be validated before it can be stored in the laptop. Common mistakes like a telephone number which have 11 digits, if by mistake there are not 11 digits an error message will appear.

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

    To do this, I did the following steps: 1) Added the 3 test results together by clicking in the cell I wanted the percentage to be, and clicking "AutoSum," which is represented by the oddly shaped E, in the top toolbar.

  2. Project 1b; Film Database

    When I see the movie in the list I might remember it. * I need to find particular movies for my Media Studies class. I want movies with a rating between 6 and 10 that have either the genre action and were produced in the year 2006, or movies with

  1. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    * The spreadsheet should be quicker, by calculating everything. Quick calculations shall be made, as soon as the description of item is keyed in. * Will have formulas that will allow new information to be typed and will affect the profit/loss of the company accordingly.

  2. Database Section

    Using a colour printer would be a slow, expensive and unnecessary way and as i will need to print out weekly/monthly reports and invoices in reasonably large quantities and as the customer will not see these printouts, colour is not necessary. The printer needs to be fast, cheap and economical.

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