Answered step by step
Verified Expert Solution
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
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
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started