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
" <3 it, thanks for saving me time. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1826 tutors are online

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