Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following for questions 33 through 37- Fall River Gardens The Fall River Gardens Co. sells flowers and potted plants to its customers. Below

image text in transcribed
image text in transcribed
Use the following for questions 33 through 37- Fall River Gardens The Fall River Gardens Co. sells flowers and potted plants to its customers. Below are samples of the tables used in the acquisition cycle of the company's business process. Materials Inventory Table Item # Description Beginning Quantity 4" clay pot 6" clay pot P3 10" paper pot 20 P1 P2 12 10 Supplier Table Supplier# S1 S2 Name Jones Supplies Silva Pots Telephone 508-555-1530 508-555-8810 Amount Purchase Invoice Table Voucher# Date Supplier Employee (Receiver) 1702 12/13/06 SI 012-85-8810 1703 12/13/06 S2 012-85-8810 1704 12/14/06 SI 312-79-5210 1705 12/14/06 S2 312-79-5210 $12.00 $72.00 $44.00 $6.00 Purchase_Invoice_Detail Table Voucher# Item# Quantity 1702 P1 4 1703 P2 12 1703 PI 8 1704 P3 2 1704 P2 10 1705 P3 3 Price Per Unit $3.00 $4.00 $3.00 $2.00 $4.00 $2.00 Payment Table Check Date 1412 12/23/06 1413 12/23/06 1414 12/24/06 Voucherit Amount 1702 $12.00 1703 $72.00 1704 $44.00 33. Which table has a compound primary key? a. Supplier Table b. Purchase_Invoice Table, c. Purchase_Invoice_Detail Table d. Payment Table e. None of them 34. Which table DOES NOT have a foreign key a. Supplier Table b. Purchase Invoice Table c. Purchase_Invoice_Detail Table d. Payment Table 35. Which table is a junction/linking table? a. Supplier Table, b. Purchase_Invoice Table c. Purchase_Invoice_Detail Table d. Payment Table e. None of them 36. What is the maximum cardinality between the Supplier Table and Purchase_Invoice Table? a. one to one b. one to many c. many to one d. many to many 37. What is the maximum cardinality between the Purchase_Invoice_Detail Table and the Purchase_Invoice Table? a. one to one b. one to many c. many to one d. many to many 38. Assume that you have specified that referential integrity should be enforced between an Inventory master table and a Rental transaction table. This implies a. A record cannot be deleted from the Inventory table if a corresponding record is available in the Rental table. b. A record cannot be added to the Inventory table unless a corresponding Rental record is available in the Rental table

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions