Purchase Solution

Relations - Determinants - Dependencies

Not what you're looking for?

Ask Custom Question

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?

Attachments
Purchase this Solution
Solution Summary

Relations are emphasized.

Purchase this Solution
Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

Basic Networking Questions

This quiz consists of some basic networking questions.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

View More Free Quizzes
Related BrainMass Solutions

  • 3NF database design based on functional dependencies

    266243 3NF Database Design Based on Functional Dependencies Consider the following functional dependencies: Applicant_ID -> Applicant_Name Applicant_ID -> Applicant_Address Position_ID -> Positoin_Title Position_ID -> Date_Position_Opens Position_ID

  • how SQL and the Oracle database work together

    I would like some help to Further my understanding of how SQL and the Oracle database work together with basic database design methods using Functional dependencies, Entity relationships and deriving relations to 3NF etc.

  • Database Concept

    A normalized database prevents such insertion anomalies by ensuring that database relations mirror functional dependencies. - Similarly, such dependencies in non-normalized databases can hinder deletion.

  • Normalization within Database

    To free the collection of relations from undesirable insertion, update and deletion dependencies; 2.

  • Transforming normal forms in database systems

    When there are multi-value dependencies 3NF needs to be normalized to the 4NF. Relations in BCNF (Boyce Codd Normal Form) are free of anomalies due to functional dependencies and as such no modification anomalies occur.

  • Second Normal Form versus Third Normal Form

    In the 2NF partial dependency is removed but in the 3NF transitive dependencies.

  • Fiedler's leadership theory

    309099 Fiedler's leadership theory - three situational determinants that allow a leader Discuss the three situational determinants in Fiedler's leadership theory that allow a leader to determine the favorableness or unfavorableness of a situation for

  • The Relational Model and Data Normalization

    Because the key is only one attribute, by default, every non-key attribute is dependent on all of the keys; there can be no partial dependencies. Relations in second normal form can also have anomalies.

  • Work Breakdown Structure: Marketing Related Deliverables

    Moving to the next direction, now I will move towards the explanation of dependencies between activities.// Dependencies between activities While advertising offers a reason to buy, sales promotion offers an incentive to buy.

View More Related Solutions