Question: Jerilee's team is working on a sales systems development project using the Waterfall approach and is currently at the systems analysis stage. The team meets

Jerilee's team is working on a sales systems development project using the Waterfall approach and is currently at the systems analysis stage. The team meets with the system's end users in the accounting department to discuss how the data captured by the system should be stored. The accounting team provides multiple scenarios of ways the system will be used and explains the key data points the system needs to collect for their department.
Jerilee decides to categorize the data into the following tables:
CustomerOrder
OrderDetails
Pizza
Customer
Help Jerilee place each of the following field names in one of these four tables and identify the primary and foreign keys for each table. Select 'None' if no key is applicable.
CustomerOrder table:
None
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
