ACC 315 6-2 Problem Set Question 4 of 7

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

315

Subject

Accounting

Date

Feb 20, 2024

Type

docx

Pages

2

Uploaded by GeneralValor9671

Report
ACC 315 6-2 Problem Set Question 4 of 7 Your Answer Correct Answer v Your answer is correct. 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: Customer_Order Order_Details 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. Customer_Order table: [ Customer_ID V] [ Foreign key V] I Order_No Vl I Primary key Vl | Order_Date v | | None v | I Total_Price VI I None VI Order_Details table: | Order_No VI I Both keys VI I Pizza_Code Vl l Both keys Vl | Ordered_Qty N | | None N |
Pizza table: Pizza Code v‘ Primarykey v/ [ Pizza Name v‘ None [ Unit_Price v‘ None Customer table: (oo Y [Py e l Customer Address v‘ None v‘ Customer_Phone v‘ None v‘ eTextbook and Media Attempts: 2 of 2 used
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help