1) Define the Primary Key for the following tables: EMPLOYEE 1 Semantics 1. Empl
ID: 3731668 • Letter: 1
Question
1) Define the Primary Key for the following tables:
EMPLOYEE 1
Semantics
1. Employee_No is unique for each employee, i.e., no two employees can have the same Employee_No.
2. An employee can have several dependents. The field Dependent_Name refers to the name of the dependents of an employee.
3. Two different employees may have dependents with the same name, but a specific employee cannot have more than one dependent with the same name.
4.The field Dependent_Relationship refers to the relationship of a given dependent to a given employee.
EMPLOYEE 2
Semantics
1. Employee_No is unique for each employee, i.e., no two employees can have the same Employee_No.
2. An employee could have held several positions (including the same position) at different times, but not more than one position on a given date.
3.The field Position_Start_Date refers to the starting date for a given position for a given employee.
Employee_No. Employee_Name Dependent_Name Dependent_Relationship 111 James Jones Jill Jones spouse 111 James Jones Bob Jones son 222 Bobby Smith Ann Smith spouse 222 Bobby Smith Jane Smith daughter 222 Bobby Smith Joe Smith sonExplanation / Answer
Employee1:
For this Table we can have the primary key Employee_No and Dependent_Name as an Employee can have the more than one dependent and can't have the same dependent so these 2 columns will make the unique records
Employee2:
For this Table we can have the primary key Employee_No and Position_Start_Date as an Employee can have more than 1 position and can have the same position at different times so as mentioned in semantics on same date Employee can't have the more than position so these two can make the unique records
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.