Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

DB(H) Database Systems

Formative Assessment 2

Task 1

Assume the following relation R where it holds true that:

•   Each manager works in a particular branch.

•   Each project has several managers and runs on several branches.

•   A project has a unique manager for each branch.

R

Q1: Which is the NF of the relation?

Q2: Which FD violates the BCNF?

Q3: Which is the splitting attribute such that R is transformed into a set of BCNF relations?

Q4: If you change the branch ‘London’ to ‘York’ how many tuples you need to update in the original version of the relation R and in the relation in BCNF?

Task 2

Consider the relation: R(A, B, C, D) and the asserted FDs:

FD1: C >D

FD2: C >A

FD3: B>C

Decompose the relation R into a set of BCNF relations using the BCNF Theorem.