Question: Given the following ( normalized ) relational model ( primary keys underlined; foreign keys in italics ) : EMPLOYEE ( SSN , ENAME, EADDRESS, SEX,
Given the following normalized relational model primary keys underlined; foreign keys in italics:
EMPLOYEESSN ENAME, EADDRESS, SEX, DATEOFBIRTH, SUPERVISOR, DNR SUPERVISOR: foreign key, refers to SSN in EMPLOYEE, NULL value not allowed DNR: foreign key, refers to DNR in DEPARTMENT, NULL value not allowed
DEPARTMENTDNR DNAME, DLOCATION, MGNR
MGNR: foreign key, refers to SSN in EMPLOYEE, NULL value not allowed
PROJECTPNR PNAME, PDURATION, DNR
DNR: foreign key, refers to DNR in DEPARTMENT, NULL value not allowed
WORKSONSSN PNR HOURS
SSN: foreign key, refers to SSN in EMPLOYEE, NULL value not allowed
PNR: foreign key, refers to PNR in PROJECT, NULL value not allowed
Which statement is NOT CORRECT?
Every project is always assigned to exactly one department.
Every employee must be always supervised by exactly one other employee.
An employee must work in the same department than heshe manages.
A department has always exactly one manager.
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
