Question
Given the following (normalized) relational model (primary keys are underlined, foreign keys are in italics). EMPLOYEE(SSN, ENAME, EADDRESS, SEX, DATE_OF_BIRTH, SUPERVISOR, DNR ) SUPERVISOR: foreign
Given the following (normalized) relational model (primary keys are underlined, foreign keys are in italics).
EMPLOYEE(SSN, ENAME, EADDRESS, SEX, DATE_OF_BIRTH, SUPERVISOR, DNR)
- SUPERVISOR: foreign key, refers to SSN in EMPLOYEE, NULL value allowed
- DNR: foreign key, refers to DNR in DEPARTMENT, NULL value not allowed
DEPARTMENT(DNR, DNAME, DLOCATION, MGNR)
- MGNR: foreign key, refers to SSN in EMPLOYEE, NULL value not allowed
PROJECT(PNR, PNAME, PDURATION, DNR)
- DNR: foreign key, refers to DNR in DEPARTMENT, NULL value not allowed)
WORKS_ON(SSN, 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?
According to the model, an employee should always work on projects assigned to his/her department. | ||
According to the model, an employee can work in multiple departments. | ||
According to the model, an employee can manage multiple departments. | ||
According to the model, a supervisor cannot supervise more than one employee. |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started