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?
Computer Science Homework Solutions
#140594
Relations - Determinants - Dependencies
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?
What is this?
By OTA - Overall OTA Rating
Rajender Kumar, MCom - 4.8/5
Purchase Cost Now
$2.19 CAD (was ~$23.94)
Included in Download
- Plain text response
- Attached file(s):
- DBMS solution.doc
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Information Technology Project Management - Create a WBS for the following projects: • Introducing self-checkout registers at your school’s bookstore • Updating fifty laptops from Project 2002 to Project 2003 • Creating a new information s ...
- Project WBS - Complete the Project Team Organization of their project plans. Subsections include: team structure. Microsoft Project must be used to: show detailed tasks, show dependencies, assignment of tasks, crea ...
- Implement the spreadsheet in the MS access and list all assumptions and functional dependencies - (See attached file for full problem description) --- Implement the database in MS access with Relationships, tables, keys, indexes and a view(query) that duplicated the spreadsheet and list all fu ...
- Read Write Data - Find the write-write, read-write, and write-read dependencies in the following assembly language program: I1: LOAD R1, A // R1 -MEMORY (A) I2: ADD R2, R1 //R2 -R2 + R1 I3: ADD R3, R4 //R3 -R3 + R4 ...
- Relational schema diagram (ID all dependencies to include transitive) - Using the STUDENT table structure attached, write the relational schema and draw its diagram. Identify all dependencies (including all transitive dependencies)
