# Chapter 3 ANSWERS TO PROJECT QUESTIONS 3.1 Consider the table: STAFF_MEETING (EmployeeName, ProjectN

Feb 3rd, 2012
Studypool Tutor
Price: \$30 USD

Tutor description

Chapter 3 ANSWERS TO PROJECT QUESTIONS 3.1 Consider the table: STAFF_MEETING (EmployeeName, ProjectName, Date) The rows of this table record the fact that an employee from a particular project attended a meeting on the given date. Assume that a project meets at most once per day. Also, assume that only one employee represents a given project, but that employees can be assigned to multiple projects.

Word Count: 4563
Showing Page: 1/21
Chapter 3ANSWERS TO PROJECT QUESTIONS3.1Consider the table:STAFF_MEETING (EmployeeName, ProjectName, Date)The rows of this table record the fact that an employee from a particular project attended a meeting on thegiven date. Assume that a project meets at most once per day. Also, assume that only one employeerepresents a given project, but that employees can be assigned to multiple projects.a. State the functional dependencies.Since there can only be one project meeting for a particular project per day, we have:(ProjectName, Date) EmployeeNameSince there is one only one employee assigned to the meetings for each project, we have:ProjectName EmployeeNameb. Transform this table into one or more tables in BCNF. State the primary keys, candidate keys, foreignkeys, and referential integrity constraints.STAFF_MEETING FUNCTIONAL DEPENDENCIES:(ProjectName, Date) EmployeeNameProjectName EmployeeNameSTAFF_MEETING CANDIDATE KEYS:(ProjectName, Date)Is every determinant a candidate key?NO, therefore the relation is NOT in BCNFTherefore, move ProjectName Employee into another tableSTAFF_MEETING_2 (ProjectName, Date)STAFF_MEETING_EMPLOYEE (ProjectName, EmployeeName)STAFF_MEETING_2 FUNCTIONAL DEPENDENCIES:(ProjectName, Date) EmployeeNameSTAFF_MEETING_2 CANDIDATE KEYS:(ProjectName, Date)Is every determinant a candidate key?YES, therefore the relation is in BCNFPage 3-1STAFF_MEETING_EMPLOYEE FUNCTIONAL DEPENDENCIES:ProjectName Employee

## Review from student

Studypool Student
" Very Satisfied. "

1829 tutors are online

### Other Documents

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors