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 with AI-Powered 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

Horngrens Accounting

Authors: Tracie L. Miller Nobles, Brenda L. Mattison, Ella Mae Matsumura, Carol A. Meissner, Jo Ann L. Johnston, Peter R. Norwood

10th Canadian edition Volume 1

978-0134213101, 134213106, 133855376, 978-0133855371

Students also viewed these Accounting questions