Type or paste question here

Question Given the below table where underline indicates PK mainPlayer(username, combatLevel, hitpointsLevel, magicLevel, rangeLevel, attackLevel, prayerLevel, defensiveBonus, questPoints) And given the following FDs: combatLevel defensivebonus combatLevel hitpoints Level username -> combatLevel, hitpointsLevel, magicLevel, rangeLevel, attackLevel, prayer Level, defensiveBonus, questPoints After BCNF normalization, how many tables are there (without any optimization step)? 2 3 BCNE 1 Question 2 A B D IC 1 3 00 1 4 6 2 E 3 4. 2 1 2 F 2 4 4 5 2 4 2 3 4 5 4 4 2 5 4 2 1 2 Does FA D hold? True False Question 3 A B D E 3 8 1 3 3 3 F 2 2 4 6 1 3 3 4. 4 3 5 1 3 6 NN 12 9 3 2 1 5 2 2 Consider Relation R(A, B, C, D, E, F) and FDs: AB - D BE C-D F C If we add a new row (2,2,2,2,2,2) into the table above, which FD(s) is violated? OA) FC B) C-D C B - E D) AB - D Question 4 A relational database of a hospital has a table of patients. This table includes a column 'pid' as primary key, a column for the 'did' of his/her doctor, and a column for the telephone number of their doctor. The database also has a table of doctors which includes a column 'did' as primary key. For both tables, there may be other columns. The relationship between doctor and patient is many to many. We know with confidence that this database is NOT in which normal form? Can't say without knowing FDs Second Normal Form First Normal Form Question 5 A relation can be in the second normal form without being in the first normal form. True False Question 6 Find the closure for ZU in the given relation. R(U, V, W, X, Y, Z) FDs W - X WZ - YX Y - Z UV . W VZ UY > W U, V, W, Y, Z U, V OZU OZ, U, V Question 7 Which of the given decompositions of R(P, Q, R, S, T) are lossless? Considering the following FDs = {P-5;5-T; QR- T} R1 (Q, R, T) and R2 (P, S, Q, T) OR1 (P, S, T) and R2 (Q, R, T) OR1 (Q, T, R) and R2 (Q, S, R, P) R1 (S, P, T) and R2 (P, Q R)