Database Techniques and Applications Report

1044 Words3 Pages

Database Techniques and Applications Report

User Needs

==========

My database will be designed for a major florist company called ‘FuNkY

FlOwErS’, the company has requested for me to design a database, which

will enable all records of customers, the flower package they’ve

chosen, and the sales, to be recorded in one document. The database

will enable the staff operating the database to store and retrieve

information, which is relevant to the sales. In order for the

information in my database to remain secure, reliable and private.

Information to be processed

===========================

I have included three tables in my database and their names are as

follows:

· Tbl Employees

· Tbl Flowers

· Tbl Suppliers

Customers

---------

Field Name

Data type

Field size

Customer ID

Auto Number

Surname

Text

20 Characters

Forename

Text

20 Characters

Gender

M/F

1 Character

D.O.B

Date/Time

Medium date

House number

Number

5 Characters

Post Code

Text

10 Characters

Tel. 1

Number

20 Characters

Tel. 2

Number

20 Characters

Mobile number

Number

20 Characters

Email address

Text

20 Characters

Member

Yes/No

3 Characters

Date Joined

Date/Time

Medium Date

Above I have shown the contents of the first table I created in

Microsoft Access, this was the first step of creating my database as I

was labelling the column headings for each table. The reason why I

chose the particular headings was so that it is easily accessible to

my client as all my client needs to do to select information or edit

information is select the corresponding table e.g. if a new customer

had decided to become a member then my client would need to select the

More about Database Techniques and Applications Report

Open Document