1) Consider the table: STAFF_MEETING (EmployeeName, ProjectName, Date) The rows

Question

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. A. State the functional dependencies. B. Transform this table into one or more tables in BCNF. State the primary keys, candidate keys, foreign keys, and referential integrity constraints. C. Is your design in part b an improvement over the original table? What advantages and disadvantages does it have?

Explanation / Answer

STAFF_MEETING (EmployeeName, ProjectName, Date)

A)

ProjectName is dependent on EmployeeName

B)

1NF - Identify Prmary Key

STAFF_MEETING (EmployeeName, ProjectName, Date)

2NF- Finsing Dependencies

STAFF_MEETING (EmployeeName, ProjectName, Date)

BCNF- Removing Multiples

STAFF_MEETING ( ProjectName, Date)

STAFF_MEETING_PROJECTS(EmployeeName, ProjectName)

EmployeeName is the Primarykey, ProjectName is foreign key to STAFF_MEETING_PROJECTS table. ProjectName is the primary key for STAFF_MEETING

C)

An Improvemnet in removing redundent data.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.