Scenario: Activity: Analyze a Scenario ABC Company uses a paper based, phone in ordering system. Currently,...

 

Transcribed Image Text:

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 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