Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions