Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In this assignment, you will take the following requirements and create an ER diagram. A new delivery company called Cargo Fast wants to compete against
In this assignment, you will take the following requirements and create an ER diagram. A new delivery company called Cargo Fast wants to compete against UPS and Fedex with their speedy delivery. Your group has been hired to design a database system for them. Cargo Fast prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, Cargo Fast relies on a company-wide information system. Shipped items are the heart of the Cargo Fast product tracking information system. All items shipped will be tracked by a unique identification number. For billing purposes, the database will record weight, dimensions, value, insurance amount of the package being shipped. Customers will contact Cargo Fast to either pick up the package or deliver the package to be shipped at one of their shipping locations. There are multiple shipping locations listed, including their address, phone number and hours of operations. When requesting shipping, Cargo Fast needs to know the destination of the shipment, along with the receiver of the package, their address, and their phone number in case they have a problem delivering the package. An estimated delivery date can be generated based on the shipping date and the destination address. Cargo Fast offers two shipping options, the Cargo Fast option and the Cargo Very Fast option (where red lights are a suggestion.) Once the package is received at the destination, the shipping request is complete. At Cargo Fast, our cargo just don't go, they go fast
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started