Create physical data model for the attached case.

 

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.

M M Gmail #tv 43F Rain off and on TV S 2 Content Maps SLIB Quoting vs. Paraphr... SLIB Welcome - APA Cit... Scenario: X Bb 34013252 (775x406) X learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com/5c082fb7a0cdb/34013252?X-Blackboard-Expiration=1670122800000&X-Blackboard-Signature=%2B0kERp1Q... YouTube OOP-Workshops/ma X 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. Email - Rishabh Puni X (6) Waalian - Harnoo X 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: . OI Identify the Nouns Identify The Relationships Create a Conceptual Diagram |||||| + D r Update 6:21 PM 12/3/2022 X