Question: Consider the following (normalized) relational model (primary keys underlined; foreign keys in italics): a. A department always has exactly one manager. b. Every employee must

Consider the following (normalized) relational model (primary keys underlined; foreign keys in italics):

EMPLOYEE (SSN, ENAME, EADDRESS, SEX, DATE_OF_BIRTH, SUPERVISOR, DNR) SUPERVISOR: foreign key, refers to SSN

a. A department always has exactly one manager.

b. Every employee must always be supervised by exactly one other employee.

c. Every project is always assigned to exactly one department.

d. According to the model, an employee can work in another department than he/she manages.

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?

Step by Step Solution

★★★★★

3.42 Rating (158 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Looking at the given relational model EMPLOYEE SSN ENAME EADDRESS SEX DATEOFBIRTH SUPERVISOR DNR SUP... View full answer

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 Principles Of Database Management Questions!

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Given the following (normalized) relational model (primary keys underlined; foreign keys in italics): EMPLOYEE(SSN, ENAME, EADDRESS, SEX, DATE_OF_BIRTH, SUPERVISOR, DNR) SUPERVISOR: foreign key,...

Given the following ( normalized ) relational model ( primary keys underlined; foreign keys in italics ) : EMPLOYEE ( SSN , ENAME, EADDRESS, SEX, DATE _ OF _ BIRTH, SUPERVISOR, DNR ) SUPERVISOR:...

Consider 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:...

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...

| The inventory system is a manual one. An inventory card for each item is kept in a master inventory book at the central warehouse. This inventory card carries the item name, inventory number and...

Please draw a 3NF ERD for the following business case. You may make reasonable assumptions about cardinalities with clear textual clarifications. You need to label primary keys and foreign keys in...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

For the company (Ecolab international), evaluate its health based on its financial statements (which you may download from Edgar or the companys website). Compute the companys current ratio, its debt...

Make a Facebook cause (www.facebook.com/causes). Invite several friends to join. Using paper and pencil or diagramming software, make a BPMN diagram of the three or four key activities in this...

You are the owner of ND Winter Skydiving Inc. The company has decided to issue 2 0 - year bonds to finance the acquisition of 2 new aircraft and dozens of polar suits. These bonds have a par value of...

1.9 Given the state variable description of the system in terms of xi(t) below, change the state variables and write new state equations for the variables ~1 (t) = 3x1(t)+ 2x2(t), and ~ 2 (t) = 7x1...

Suppose that a message 1001 1100 1010 0011 is transmitted using Internet Checksum (4-bit word). What is the value of the checksum?

A 1024-bit message is sent that contains 992 data bits and 32 CRC bits. CRC is computed using the IEEE 802 standardized, 32-degree CRC polynomial. For each of the following, explain whether the...

In the discussion of ARQ protocol in Section 3.3.3, a scenario was outlined that resulted in the receiver accepting two copies of the same frame due to a loss of acknowledgement frame. Is it possible...

You are considering investing in a start up project at a cost of $75,000. You expect the project to return $38,000, $25,000 and $55,000 to you in the next three years. Given the cost of capital is...

ATV Co. began operations on March 1 and uses a perpetual inventory system. It entered into purchases and sales for March as shown in the Tableau Dashboard. March Thursday Wednesday Sunday Monday...

Alpha Co. Ltd has incurred total costs of $150,000 for producing 500 units of output in April 2019 and at 3,000 units of output be $400,000 in September 2019. Calculate variable and fixed costs,...