I have been given the task to design a database for a company called Postquick Parcels. Postquick Parcels is a company, which provides a parcel delivery service, which allows customers to send consignment parcels around the UK.

This essay hasn't yet been marked by one of our teachers

You can view 11 essays on Computer Science that have been Marked by Teachers

The first 200 words of this essay...

INTRODUCTION 4

The Systems Life Cycle 4

Methods of Gathering data 5

Problems of Present System 5

Objectives of the new system 6

DESIGN 7

The Feasibility of a Computer Based System 7

Hardware 7

Choices of Software 8

Excel 8

Access 9

High Level Language Such as Pascal 10

Evaluation of possible software solutions 10

Data requirements 11

The Data Flow 12

Data Flow Diagram 12

Entity-Relationship diagrams 12

Entity-Relationship diagrams 13

Entity-Relationship diagrams 14

System Design 15

Top Down Design 15

Modular Design 15

Outputs 18

Consignment Note: 18

Query outputs: 18

Forms 19

Menu 19

Reports 20

Methods of Data Entry 20

Record structure 21

Customer Records 21

Destination Records 21

Parcel Records 22

Order Records 22

File Organisation 22

Security and Integrity of Data 23

Integrity 23

Input Masks 23

Validation Rules 23

List Boxes 23

Safety 24

Back up recommendations 24

Security 24

Passwords 24

Encryption 24

Other Security Recommendations