Coursework.Info - Inspiration in an Instant

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

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...

Get instant access

• Instant, unlimited access to our documents in full
• Swap your work for free access, or pay £4.99
• To see the full version of this document and 149,410 others