PostQuick Parcels Database Solution.

Authors Avatar

AS PRACTICAL EXERCISE FOR SUMMER 2001 EXAMINATION;

PostQuick Parcels Database Solution.

DEFINITION OF DATA REQUIREMENTS

It has to have the ability to store details of customers and parcels. Each customer has their own Identification and they have many consignments, which contain more than one parcel. Customers are charged per parcel by weight it has to check the price of each parcel consignment, to produce an itemised consignment note for each customer. The details actually stored need only include information for 1day.

Customer details include:

  • Name

  • Middle Name/s

  • Surname

  • Business

  • Telephone

  • Address

  • Postcode

  • Customer ID

Consignment details include:

  • Consignment number

        Customer ID

        Total weight

        Total cost

        Deliver to

        Address

        Postcode

Parcel Details include:

  • Parcel number

        Consignment number

        Length

        Breadth

        Height

        Total dimensions

        Weight

        Cost according to weight

Cost details include:

  • Weight

        Cost

ENTITY RELATIONSHIP DIAGRAM

                        HAS                                        WHICH CONTAIN

A customer will have more than one consignment, as they may need to send different batches of parcels to different places. These consignments therefore have one or more parcels within the individual consignments. Therefore this system has to cater for a 1 to many relationships.

DATA FLOW DIAGRAM;

           

                             

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                

Join now!

USER INTERFACE DESIGN:

Customer form – This Form requires the entry of each customer’s details this is where customer Identifications is assigned.

Consignment form - This form requires data from each parcel within the consignment E.G Total weight of parcels. As well as customer ID, deliver to address and a consignment number will automatically be assigned.

Parcel form – This form will require the details of each parcel to be entered E.G weight as well as the consignment number the parcel is apart of. It will automatically calculate the total dimensions ...

This is a preview of the whole essay