Answered You can hire a professional tutor to get the answer.
Consider the table: Staff_Meeting (EmployeeName, ProjectName, Date) The rows of this table record the fact that an employee from a particular project...
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 a given date. Assume that a project meets at most once per day. Also assume that only one employee represnts a given project, but that employees can be assigned to multiple projects.A. state the functional dependancies in Staff_Meeting.B. trandform the tables into one or more tables in BCNF. State the primary keys, candidate keys, and referential integrity constraints.C. Is your design in part B an improvement over the original table? what are the advantages and disadvantages.
