Answer these question: FedEx wants to develop a company-wide information system. Shipped items are the heart of
Fantastic news! We've Found the answer you've been seeking!
Question:
Answer these question:
Transcribed Image Text:
FedEx wants to develop a company-wide information system. Shipped items are the heart of the FedEx product tracking information system. Shipped items can be characterized by item number, weight, dimensions, insurance amount, destination city, and final delivery date. Shipped items are received into the FedEx system at a single retail center. There are multiple retail centers in big cities such as LA, NY, etc. Each of the retail centers has one of the four types: FedEx office, FedEx Ship Center, Office Depot, and FedEx Authorized Ship Center. Shipped items make their way to their destination via one or more standard UPS transportation events (ex. Flights, ships, truck deliveries). These transportation events are characterized by schedule, a type (e.g. flight, truck, ship), and a delivery route. 1. Please create an Entity-Relationship diagram that captures this information about the FedEx system. Please identify primary keys, foreign keys, and cardinality constraints. Please solve many-to-many relationship problems if you have any here. If you have any assumptions, please identify those assumptions (User-defined constraints). To do this homework, you should have AT LEAST three entities: Retail Center, Shipped Items, and Transportation Event. Please think carefully. As I described above, one shipped item belongs to only one retail center. However, the shipped item can have many transportation events. (Think about the real situation. In the case of international cargo, the cargo travels across the continent using ships or airplanes, and then the cargo travels by ground transportation.) FedEx wants to develop a company-wide information system. Shipped items are the heart of the FedEx product tracking information system. Shipped items can be characterized by item number, weight, dimensions, insurance amount, destination city, and final delivery date. Shipped items are received into the FedEx system at a single retail center. There are multiple retail centers in big cities such as LA, NY, etc. Each of the retail centers has one of the four types: FedEx office, FedEx Ship Center, Office Depot, and FedEx Authorized Ship Center. Shipped items make their way to their destination via one or more standard UPS transportation events (ex. Flights, ships, truck deliveries). These transportation events are characterized by schedule, a type (e.g. flight, truck, ship), and a delivery route. 1. Please create an Entity-Relationship diagram that captures this information about the FedEx system. Please identify primary keys, foreign keys, and cardinality constraints. Please solve many-to-many relationship problems if you have any here. If you have any assumptions, please identify those assumptions (User-defined constraints). To do this homework, you should have AT LEAST three entities: Retail Center, Shipped Items, and Transportation Event. Please think carefully. As I described above, one shipped item belongs to only one retail center. However, the shipped item can have many transportation events. (Think about the real situation. In the case of international cargo, the cargo travels across the continent using ships or airplanes, and then the cargo travels by ground transportation.)
Expert Answer:
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these general management questions
-
Suppose you are considering two investments, Investment A and Investment B. Investment A requires an initial investment of $10,000 and will generate cash flows of $2,000 per year for the next 8...
-
UPS prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on a company-wide information system. Shipped items are the...
-
Give the decoding key for the encoding keys in Problems 2536. Minus 4, divide by 2.
-
Yellowstone Company began operations on January 1 to produce a single product. It used an absorption costing system with a planned production volume of 100,000 units. During its first year of...
-
Who was Walter A. Shewhart?
-
Hemlock Semiconductor Operations, LLC, and SolarWorld Industries Sachsen GmbH, are both companies involved in the manufacture of components for solar power products. Prior to the lawsuit, the two...
-
DCF, accrual accounting rate of return, working capital, evaluation of performance, no income taxes. Century Lab plans to purchase a new centrifuge machine for its New Hampshire facility. The machine...
-
Discuss the importance of an object-oriented database. How does it differ from the relational model?
-
Julio and Milania are owners of Falcons Corporation, an S corporation. They each own 50 percent of Falcons Corporation. In year 1, Julio and Milani received distributions of $20,000 and $10,000,...
-
STS Sdn Bhd provides bookkeeping services and has consistently invoiced its clients a total of RM35,000 per month since 2018. Due to its prudent management, STS Sdn Bhd has accumulated a sizeable...
-
Consider the linear transformation T : P2(R) P2(R) given by T() = 2f', where f' is the usual derivative of f. (a) (4 points) Let S == {1, x, x2} be the standard basis of P2(R). Find [T(S,S)] the...
-
Create a system in JAVA that will check if the number is a Prime Number or not. You are also required to draw the flowchart diagram and write the pseudocode for this program. After the user enters a...
-
Reflect on a time when a supervisor or professor announced a change that you, the worker/student, did not want to adopt. What were the reasons for your resistance to change? Was the...
-
What were some of Nick's challenges when asked to implement his superior's vision for the newspaper? . Discuss your reaction to Nick's story. Identify one of Tim's leadership traits (i.e....
-
A) What should you consider when developing, implementing, monitoring, and reviewing strategies to support the inclusion of all children? How can you work with relevant other stakeholders to plan and...
-
Give an example of a function f which satisfies the intermediate-value property on a closed and bounded interval [a, b] but is not continuous on a, 6). () Give an example of a function f which is...
-
On the basis of the details of the following fixed asset account, indicate the items to be reported on the statement of cashflows: ACCOUNT Land ACCOUNT NO. Balance Date Item Debit Credit Debit Credit...
-
Consider the following relation instance of the SPORT relation schema. a. What is the minimal cover of functional dependencies that exists in SPORT? b. What is (are) the candidate key(s) of SPORT? c....
-
What is the purpose of Armstrong's axioms?
-
Consider the universal relation schema STOCK (Symbol, Company, Exchange, Investor, Date, Price, Broker, Dividend) and the following dependencies set: fd: Symbol {Company, Exchange, Dividend} mvd:...
-
A Pepsi promotion encouraged consumers to collect Pepsi points and redeem them for merchandise. If they did not have quite enough points for the prize they wanted, they could buy additional points...
-
John and Jennifer Margeson entered into a contract to sell a weight-loss franchise business called Inches-A-Weigh to Theresa Artis. The parties memorialized their agreement in an Asset Purchase...
-
What is the mirror-image rule?
Study smarter with the SolutionInn App