...Kaplan University IT234 Unit 4 Jennifer Polisano 1. In the General Hardware Corp. relational database as shown in Figure 4.1 (pp. 71–72) above: a. How many foreign keys are there in each of the six relations? Answer 1a: There are between three and six foreign keys in each of the six relations. b. List the foreign keys in each of the six relations. Answer 1b: Starting from top left and continuing down, they are Salesperson Number, Salesperson Name, Commission Percentage, Year of Hire, Office Number; Customer Number, Customer Note, Salesperson Number, HQ City; Customer Number, Employee Number, Employee Name, Title; Product Number, Product Name, Unit Price; Salesperson Number, Product Number, Quantity; Office...
Words: 1629 - Pages: 7