ABC Inc. is a company that transports packages (similar to UPS) and prides itself on having up-to-date information about the processing and current location of each shipped item. To do this, the company relies on a company-wide information system. Shipped items are the heart of the company's product tracking system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the company's system at a single retail center. Retail centers are characterized by their type, unique ID, and address. Shipped items make their way to their destination via one or more standard transportation events (i.e., flights, truck deliveries). These transportation ever are characterized by a unique schedule number, a type (e.g., flight, truck), and a delivery route. For this assignment. I want you to provide the names of all the tables that would be needed to save data about the scenario discussed above. For each table, please write down the corresponding column/field names. Try to identify as many tables as possible. You do not have to create the tables on MySQL. Just type in the tables and their fields/ columns on Word.
ABC Inc. is a company that transports packages (similar to UPS) and prides itself on having up-to-date information about the processing and current location of each shipped item. To do this, the company relies on a company-wide information system. Shipped items are the heart of the company's product tracking system. Shipped items can be characterized by item number (unique), weight, dimensions, insurance amount, destination, and final delivery date. Shipped items are received into the company's system at a single retail center. Retail centers are characterized by their type, unique ID, and address. Shipped items make their way to their destination via one or more standard transportation events (i.e., flights, truck deliveries). These transportation ever are characterized by a unique schedule number, a type (e.g., flight, truck), and a delivery route. For this assignment. I want you to provide the names of all the tables that would be needed to save data about the scenario discussed above. For each table, please write down the corresponding column/field names. Try to identify as many tables as possible. You do not have to create the tables on MySQL. Just type in the tables and their fields/ columns on Word.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:ABC Inc. is a company that transports packages (similar to UPS) and prides itself on having up-to-date
information about the processing and current location of each shipped item. To do this, the company
relies on a company-wide information system. Shipped items are the heart of the company's product
tracking system. Shipped items can be characterized
by item number (unique), weight, dimensions, insurance amount, destination, and final delivery
date. Shipped items are received into the company's system at a single retail center. Retail centers are
characterized by their type, unique ID, and address. Shipped items make their way to their
destination via one or more standard transportation events (i.e., flights, truck deliveries).
These transportation ever are characterized by a unique schedule number, a type (e.g., flight,
truck), and a delivery route.
For this assignment.
I want you to provide the names of all the tables that would be needed to save data about the
scenario discussed above. For each table, please write down the corresponding column/field names.
Try to identify as many tables as possible. You do not have to create the tables on MySQL. Just type in
the tables and their fields/ columns on Word.
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education