Case Study
Assessment item 1—Assignment 1 Assignment Specification In this assignment, you need to perform the following tasks for the given case study: · Draw an Entity Relationship (ER) diagram · Perform logical design(optional) · Create3NF Relations(optional) Please note that the above mentioned optional components,logical design and 3NF relations, will not be marked, however those tasks are expected to enrich your skills in the creation of database in future. Case Study CQParcels (CQPS) is well known for its parcel handling business in Australia. It collects the parcels from its customers and then transports and delivers them to the respective specified delivery addresses in Australia. When anew customer(sender of the parcels)requests for parcel deliveries, CQPS collects many details that are related to them. Among the many infor...