1. List the primary keys in the relations below: DEPARTMENT (DepartmentName, BudgetCode, ManagerName) EMPLOYEE (Employee

[answerhappygod]

1 List The Primary Keys In The Relations Below Department Departmentname Budgetcode Managername Employee Employee 1 (143.91 KiB) Viewed 31 times

1. List the primary keys in the relations below: DEPARTMENT (DepartmentName, BudgetCode, ManagerName) EMPLOYEE (EmployeeNumber, EmployeeLastName, EmployeeFirstName, DepartmentName) 2. List the surrogate keys in the relations below: RENTAL_PROPERTY Zip/Postal Code, Country, Rental_Rate) 3. List the foreign keys in the relations below: DEPARTMENT (DepartmentName, BudgetCode, ManagerName) (EmployeeNumber, EmployeeLastName, EMPLOYEE EmployeeFirstName, DepartmentName) 4. Fill in the blank (hint: referential integrity constraint) SKU_DATA (SKU, SKU_Description, Department, Buyer) ORDER_ITEM (OrderNumber, SKU, Quantity, Price, ExtendedPrice) WHERE Functional dependencies: Tables: (PropertyID, Street, City, State/Province, 6. Normalize the following data: A101 A101 A105 A105 A105 Lucy Lucy Tables: Employee Employee Employee Number Name DOB 1/1/1990 1/1/1990 Engineering Mechanical 10210 30021 30021 30021 Functional dependencies: must exist in Employee College Employee Employee Dependent Department BudgetCode Number Engineering Mechanical 10210 D101 D102 D111 D112 D113 Stephen 7/16/1977 Business Finance Stephen 7/16/1977 Business Stephen 7/16/1977 Business Finance Finance