Question: Underline every primary key, bold every foreign key, and italicize every candidate ( alternative ) key for the following database Sales ( SalesNo , SalesDate,
Underline every primary key, bold every foreign key, and italicize every candidate alternative key for the following database
Sales SalesNo SalesDate, EmpNo, CustomerNo
SalesProduct SalesNo ProductNo, SalUnitPrice Quantity
Product ProductNo ProductDesc
Customer CustomerNo CustomerName, Address, CustomerTel, FedTaxNo, StateTaxNo
Employee EmpNo EmpName, SSNo, DriverLisNo, Address
Assumption: every customer is a business entity organization having only one FedTaxNo and
one StateTaxNo.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
