Logged out
Access All our Essays in an Instant
Swap your work for FREE access, or pay £4.99 for instant access
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.
Member rating:
(11 votes)
| Words:
| Submitted: Fri Aug 15 2003
Page Preview
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
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 24 IMPLEMENTATION 25 Starting with a simple Database 25 The Tables 25 Linking the Tables 27 Entering Data 28 Customer Data Form 28 Parcel Data Form 28 Destination Data Form 29 Order Data Form 30 Avoiding Human Errors using input masks 32 Validation Rules 33 Queries 34 Simple Queries 34 Parameter Queries 34 Finding Existing destination 34 Finding ID 36 Updating customer data 36 Total Dimensions 37 Finding Weight From Price 37 Consignment note 38 As a Report 38 Below is the final design for my consignment note. The annotated notes describe the improvement I have made. 38 As a Query 38 As a Query 39 Integrated Consignment notes for the deliveryman and Customer 40 Reports 42 Price Lists 42 Buttons 42 Making the Database User Friendly 44 Making Menus 44 Managers statistics 46 Security 47 Making The Menu Come Up When the Database Is Opened 48 TESTING 49 Testing the Buttons 49 Testing The Queries 50 Finding existing...
To see the full version of this document, and 145,348 others
