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

1 Expert Approved Answer
Step: 1 Unlock

To determine which statement is NOT CORRECT according to the given relational model we need to analy... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!