School Library's Database- Original Writing

School Library's Database- Original Writing

I will produce a database for the school library. The school needs a

database because they are currently using an out of date card index.

The card index is useful but there are some problems with this method

of recording of who has taken what book from the library. The problem

with the card index is that the person who took a certain book out the

library might lose his/her card and forgets he has taken that book out

then that boy/girl can’t take a book out again.

In order for Mrs Flude the librarian to have a database that is useful

it must be able to do the following things:

* The database must have a record of all the books in the school

library.

* A record of the books that are fiction and none fiction

* The database must have a record of all the students and the staff

in the school

* A record of personal details about the student such as their

addresses,

Contact, number, form group etc.

· Other information that might useful such as the students reading age

and subject interests

· The main purpose of the database is link the book to the person who

is borrowing it

· The database could also tell Mrs Flude when books are due back and

whether anybody has a fine to pay.

Stage 2-planning my database

In order to plan my database I am going to decide how many tables and

fields I need for my database. I will consider what type of data

should go each field and what size each field is entered in. when I

have this need to relate the table to each you can see how I am going

to plan my

This is a table of what my book database will look like

Field name

Data type