I need to identify Functional Dependancies as below. I currently have the following is this correct?

F = {    ENo → Ename, Edob

            DNo → DName, DManager

            PNo → PName, PCity, PCountry

            ENo PNo → hours, rate}

Consider the following relation schema for table R:

R(ENo;DNo; PNo; EName; DName; PName; Edob; Dmanager; PCity; PCountry; hours; rate)

Attributes starting with “E” refer to Employees, those starting with “D” refer to Departments, and those with “P” to Projects. Employees, Departments, and

Projects are identified by unique numbers. Each department has only one manager, but an employee can be managers for different departments. A department

manager is represented by his/her name. The number of hours and hourly rate of pay for an employee to carry out a project are determined by himself/herself

and the project. There may be multiple projects that are conducted in a department and multiple departments can be involved in a single project as well.

Any employee can be affiliated with a few different departments and work in multiple projects at the same time. A project may involve multiple employees.

Names for employees, managers, departments and projects are not generally unique. A project will only be conducted in a single city. Multiple cities from

the same country may appear in the table, however, cities are uniquely named within and across all countries.

Answer the following questions:

(a) Identify the Functional Dependencies in R. Be sure to only include functional dependencies that satisfy the following 4 rules: 1) Only include non-trivial FDs; 2) Minimize the determinant (LHS), that is, only include full FDs; 3) Maximize the RHS; and 4) Only include FDs that cannot be derived from other FDs using Armstrongs axioms.

ComputerScienceExpert

(11)

Status NEW Posted 25 May 2017 02:05 AM My Price 9.00

-----------

Attachments

file 1495678486-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer