Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

21.Implementation of this REA diagram into a relational database would require how many tables? 9, 812,or13 23.Cosgrove Art & Antiques sells unique art and antiques

21.Implementation of this REA diagram into a relational database would require how many tables? 9, 812,or13 23.Cosgrove Art & Antiques sells unique art and antiques exclusively at antique shows. Cosgrove purchases inventory from individuals and other dealers at garage sales, flea markets, antique malls, and estate sales. Each time Cosgrove makes a purchase, she records the person's name, address, date, specific items purchased and price paid, and total amount spent. Later at home, Cosgrove cleans, researches and prices the inventory items. She assigns an inventory number to each item and records the "asking" price. Cosgrove buys price tags and display supplies from a company that sells at flea market and antique shows. All inventory and supplies purchases are paid immediately with cash, or with checks from a bank account in the business' name, to which sales are also deposited. Several times a year Cosgrove rents a booth at an antique show. A deposit is always required, with the balance due at the start of the show. Cosgrove records the deposit and final payment, along with the show organizer's name and address, in the same worksheet on which purchases of inventory and supplies are recorded. Which of the following would not be an attribute in the Inventory table? 1) Total amount of purchase 2) Price paid 3) Asking price 4) Inventory number

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

Recommended Textbook for

Financial Statement Analysis And Security Valuation

Authors: Stephen H Penman

4th Edition

0073379662, 9780073379661

More Books

Students also viewed these Accounting questions

Question

What is M&M Proposition 1? M&M Proposition 2?

Answered: 1 week ago