Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Exploring The Hospitality Industry

Authors: John R Walker

4th Edition

0134744934, 9780134744933

More Books

Students also viewed these General Management questions