Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

REA AND RELATIONAL DATABASE. Use the following information for Brice's Magic Baseball Cap Inc. to answer questions 42 to 46. (37 points total) Brice's Magic

image text in transcribed
image text in transcribed
REA AND RELATIONAL DATABASE. Use the following information for Brice's Magic Baseball Cap Inc. to answer questions 42 to 46. (37 points total) Brice's Magic Baseball Cap Inc. orders white baseball caps, paints the caps cardinal and gold and adds a picture of ISU President Dr. Leath to the front. If students study and wear cyclone magic baseball caps, they are guaranteed to get good grades on all finals. Tables used in its revenue database are shown below. Table Attributes Inventory ProductWeight, ReorderPoint, ProductNo, Description, UnitCost, UnitPrice, QuantityOnHand Cash BankID, Balance, AccountNo SalesOrder OrderAmount, EmployeeNo, Terms, SalesOrderNo, OrderDate, CustomerNo ShipGoods EmployeeNo, CustomerNo, ShipmentReportNo, ShipmentDate, QuantityShipped Cash Collection CustomerNo, EmployeeNo, AccountNo, ReceiptNo, ReceiptDate, ReceiptAmount, ShipmentReportNo Employee EmployeeName, DateHired, BirthDate, EmployeeNo, Salary, ManagerNo Customer CustomerName, Street, City, State, Zip, CustomerNo, CustomerPhone Inventory_SalesOrder ActualSalesPrice, OrderQuantity, ProductNo, SalesOrderNo Inventory_ShipGoods ProductNo, ShipmentReportNo SalesOrder_ShipGoods SalesOrderNo, ShipmentReportNo 42) Identify the primary key(s), if any, for each table. (2 points) SalesOrder SalesOrder-ShipGoods Identify the foreign key(s), if any, for each table. (2 points) ShipGoods

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_2

Step: 3

blur-text-image_3

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

College Accounting Chapters 1-15

Authors: James A Heintz, Robert W Parry

19th Edition

0324376162, 978-0324376166

More Books

Students also viewed these Accounting questions

Question

5. It is the needs of the individual that are important.

Answered: 1 week ago

Question

3. It is the commitment you show that is the deciding factor.

Answered: 1 week ago