Create a physical data model for the attached case. Reference Please use the information located in the courseshell, as a guide when creating your models: Textbook Chapters 4, 5, 7, 8, 10, 13 What to submit: 1. SQL code of all database tables creation, PK, FK and constrains. 2. A schematic diagram of the database showing all types of relationships. 3. One page report of the challanges you face and your suggestions of how we can generalize the case. Marks You will be marked on your ability to: Include all of the necessary information from the case. Extrapolate what might be missing in the case and include components that are appropriate. 6:22 earn.senecacollege.ca + = X Introduction to Database S... > Project (25%) Marks You will be marked on your ability to: 477% What to submit: 1. SQL code of all database tables creation, PK, FK and constrains. 2. A schematic diagram of the database showing all types of relationships. 3. One page report of the challanges you face and your suggestions of how we can generalize the case. ||| 1 Include all of the necessary information from the case. O : Extrapolate what might be missing in the case and include components that are appropriate. Produce a professional, well written/organized, and or visually appealing response to each question. r 6:22 Scenario: nt.blackboardcdn.com + 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. ||| Bb O Tasks: 4677% 2 Identify the Nouns Identify The Relationships Create a Conceptual Diagram r : +