Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask C/C++ Expert

Programming


Home >> C/C++

Consider the following relation definition and sample data:

EmployeeName PeojectID     TaskID   Phone    TotalHours
     Don             100A            B-1       12345      12
     Don             100A            P-1       12345      12
     Don             200B            B-1        1345       12
     Don             200B            P-1       12345      12
     Pam            100A            C-1        67890      26
     Pam            200A            C-1        67890      26
     Pam            200D            C-1        67890      26

PROJECT-HOURS (EmployeeName, ProjectID, TaskID, Phone, TotalHours)

Where EmployeeName is the name of an employee

ProjectID is the name of a project

TaskID is the name standard work task

Phone is the employee's telephone number

TotalHours is the hours worked by the employee on this project

Assuming that all of the functional dependencies and constraints are apparent in this data, which of the following statements is true?

A. EmployeeName > ProjectID

B. EmployeeName >> ProjecID

C. EmployeeName > TaskID

D. EmployeeName >> TaskID

E. EmployeeName >: Phone

F. EmployeeName >: TotalHours

G. (EmployeeName, ProjectID) > TotalHours

H. (EmployeeName, Phone) > TaskID

I. ProjectID > TaskID

J. TaskID > ProjectID

Answer these questions:

K. What are all of the determinants?

L. Does this relation contain a partial dependency? If so, what is it?

M. Does this relation contain a multi-value dependency? If so, what are the unrelated attributes?

N. Redesign this relation to eliminate the modification anomalies. How many relations did you use?

How many themes does each of your new relations contain?

C/C++, Programming

  • Category:- C/C++
  • Reference No.:- M91610399
  • Price:- $20

Priced at Now at $20, Verified Solution

Have any Question?


Related Questions in C/C++

Assign ment - genetic algorithmin this assignment you will

ASSIGN MENT - GENETIC ALGORITHM In this assignment, you will use your C programming skills to build a simple Genetic Algorithm. DESCRIPTION OF THE PROGRAM - CORE REQUIREMENTS - REQ1: Command-line arguments The user of yo ...

There are several ways to calculate the pulse width of a

There are several ways to calculate the pulse width of a digital input signal. One method is to directly read the input pin and another method (more efficient) is to use a timer and pin change interrupt. Function startTi ...

Why do researcher drop the ewaste and where does it end

Why do researcher drop the ewaste and where does it end up?

Question 1find the minimum and maximum of a list of numbers

Question: 1. Find the Minimum and Maximum of a List of Numbers: 10 points File: find_min_max.cpp Write a program that reads some number of integers from the user and finds the minimum and maximum numbers in this list. Th ...

1 implement the binary search tree bst in c using the node

1. Implement the Binary Search Tree (BST) in C++, using the Node class template provided below. Please read the provided helper methods in class BST, especially for deleteValue(), make sure you get a fully understanding ...

Project - space race part a console Project - Space Race Part A: Console Implementation

Project - Space Race Part A: Console Implementation INTRODUCTION This assignment aims to give you a real problem-solving experience, similar to what you might encounter in the workplace. You have been hired to complete a ...

Software development fundamentals assignment 1 -details amp

Software Development Fundamentals Assignment 1 - Details & Problems - In this assignment, you are required to answer the short questions, identify error in the code, give output of the code and develop three C# Console P ...

Assignment word matchingwhats a six-letter word that has an

Assignment: Word Matching What's a six-letter word that has an e as its first, third, and fifth letter? Can you find an anagram of pine grave. Or how about a word that starts and ends with ant (other than ant itself, of ...

What are the legal requirements with which websites must

What are the legal requirements with which websites must comply in order to meet the needs of persons with disabilities? Why is maximizing accessibility important to everyone?

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved