Reference no: EM13939525
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?
|
Utilize a clinical decision making framework
: Utilize a clinical decision making framework that incorporates ethical & comprehensive assessment and person-centred nursing care while maintaining choice and dignity for older people.
|
|
Equivalent annual cost problem
: L web is bidding to provide web services for a company. The company pays its current provider $10,000 per year for hosting its web page, handling transactions, etc. If L web's cost of capital is 9.9%, can it bid less than $10,000 per year to provide..
|
|
Aspect of your organizations culture
: Analyze at least one aspect of your organization's culture and the various ways it's communicated and share your recommendations on how it could be communicated more effectively.
|
|
Peer evaluation system for team group work
: The main goal is to create a peer evaluation system for team group work. This peer evaluation system should allow you to evaluate our group members. A preferred peer evaluation solution is to be recommended.
|
|
How many themes does each of your new relations contain
: Does this relation contain a multi-value dependency? If so, what are the unrelated attributes?
|
|
Do human rights require democracy
: What exactly is the problem of ethnocentricity?Do Human Rights Require Democracy?
|
|
Long-term financing needed-what was total long-term debt
: At year-end 2013, Wallace Landscaping’s total assets were $1.4 million and its accounts payable were $415,000. Sales, which in 2013 were $2.6 million, are expected to increase by 30% in 2014. What was Wallace's total long-term debt in 2013? How much ..
|
|
Non-state political systems and nation-state systems
: Briefly describe the main differences between non-state political systems and nation-state systems. Ideally, can one be conceived as better than the other? Why
|
|
Write the cost formula for tanning services
: Using the high-low method, compute the variable rate for tanning. Compute the fixed cost per month. Using your answers to Requirement 2, write the cost formula for tanning services.
|