Database Report

Database Report

Introduction

A database contains a collection of information organised in such a

way that a computer program can quickly select pieces of data. You can

think of a database as an electronic filing system.

A field is a single piece of information; a record is one complete set

of fields; and a file is a collection of records. For example, a

telephone book is analogous to a file. It contains a list of records,

each of which

To access information from a database, you need a database management

system. This is a collection of programs that enables you to enter,

organize, and select data in a database.

I am creating a database to hold the information of a Video/DVD shop

e.g. customer id, customer name, customers surname, address etc.

People use database because it's a new and advanced way to keep

information unlike having information on paper. Using database is

quicker to access information where as having information stored on

paper it would take time to access it. It is a suitable place where

information can't be lost, can be easily retrieved, and easy to edit

information.

The database I have created is about a video/DVD renting shop (Video

&DVD EXPRESS), that is renting videos and DVDs to people and I have to

create a database to show how many people have created a account, how

many videos and DVDs they have, and customer details.

There are two user needs, one of the user needs will be that the user

will have to edit information when a new customer joins or a customer

leaves. And the second user need can be that the user will have upload

more information about films and their details e.g. prices, genre,

classification etc.

When this database is finished it will enable me to find customer,

video & DVD, rental information very quickly. Also to see what people

are entitled to what kind of films, and what people have returned and

not returned videos & DVD etc.