Chat with AI
Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer
Edition 13ISBN: 978-0133058352Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer
Edition 13ISBN: 978-0133058352 Exercise 4
Suppose you receive the following two tables:
DEPARTMENT (DepartmentName, BudgetCode)
EMPLOYEE (EmployeeNumber, EmployeeLastName, EmployeeFirstName, Email, DepartmentName)
and you conclude that EMPLOYEE.DepartmentName is a foreign key to DEPARTMENT.DepartmentName. Show SQL for determining whether the following referential integrity constraint has been enforced:
EMPLOYEE.DepartmentName must exist in DEPARTMENT.DepartmentName
DEPARTMENT (DepartmentName, BudgetCode)
EMPLOYEE (EmployeeNumber, EmployeeLastName, EmployeeFirstName, Email, DepartmentName)
and you conclude that EMPLOYEE.DepartmentName is a foreign key to DEPARTMENT.DepartmentName. Show SQL for determining whether the following referential integrity constraint has been enforced:
EMPLOYEE.DepartmentName must exist in DEPARTMENT.DepartmentName
Explanation
Verified
Verified
The following SQL statement will retur...
Database Processing: Fundamentals, Design, and Implementation 13th Edition by David Kroenke, David Auer
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
