Question
business case study 4- SHIPPING COMPANY Alshaarq is a shipping company ,seeks to streamline its product tracking system by implementing an up-to-date information system that
business case study 4- SHIPPING COMPANY Alshaarq is a shipping company ,seeks to streamline its product tracking system by implementing an up-to-date information system that can track the processing and current location of each shipped item. shipped items are the heart of the alshaarq product tracking information system. shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. shipped items are received at a single retail center, and one retail center can receive many shipped items from alshaarq. retail centers are characterized by their type, uniqueid, and address. an item is composed of many elements with id, name, dimensions, description. each element can be used in different items. shipped items make their way to their destination via one or more standard alshaarq transportation events (i.e., flights, truck deliveries). these transportation events are characterized by a unique schedule number, a type (e.g, flight, truck), and a delivery route. in each retail center there should be at least one salesperson who works for that center only, by an id, title, salary and phone number.
Draw ERD for above case study?
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