Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Scenario: Activity: Analyze a Scenario ABC Company uses a paper based, phone in ordering system. Currently, customers phone ABC with orders that are then

 
image

Scenario: Activity: Analyze a Scenario ABC Company uses a paper based, phone in ordering system. Currently, customers phone ABC with orders that are then written on forms for further processing. ABC Company would like to create an online ordering system to allow customers to place orders via the internet. The system will need to track customer information, including name, address, phone number The system should populate/collect order information, such as order date, required date, shipped date, status, comments. The system should also allow ordered products to be entered. For each product, the order also needs to include quantity ordered and unit price. Tasks: Identify the Nouns . Identify The Relationships Create a Conceptual Diagram 10:14 A = X Introduction to Database S... > earn.senecacollege.ca + Upload Assignment: Project part 2 Please use the information located in the coursesneli, as a guide when creating your models: Textbook Chapters 4, 5, 7, 8, 10, 13 Tasks Please create a Create a logical data model and use as many or as few tables (classes) and as many or as few columns (properties/attributes) as you feel are necessary to create a functioning system that can benefit the case / process as it is described. The case does not necessarily provide you with every piece of information you need; use your personal discretion to make decisions as you feel are necessary to properly complete this task. ... 100%| For questions asking you to create a model, please produce a professional looking diagram using any diagram tool you wish. However, be sure to create a diagram that is appropriate for the specific type of data model requested. Marks You will be marked on your ability to: (2 : Include all of the necessary information from the case. Extrapolate what might be missing in the case and include components that are appropriate. Case_1.PNG Produce a professional, well written/organized, and or visually appealing response to each question. ||| O

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_2

Step: 3

blur-text-image_3

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

Management Accounting Information for Decision-Making and Strategy Execution

Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young

6th Edition

137024975, 978-0137024971

More Books

Students also viewed these Databases questions