Consider the following relational scheme: X1 A1 A2 X2 АЗ A4 A5 The attributes that are part of the primary key are underlined and shaded. Assume that Following functional dependencies exist: (а) X1,...


Consider the following relational scheme:<br>X1<br>A1<br>A2<br>X2<br>АЗ<br>A4<br>A5<br>The attributes that are part of the primary key are underlined and shaded. Assume that<br>Following functional dependencies exist:<br>(а) X1, X2<br>A1, A2, АЗ, А4, А5<br>(b) X1,<br>» A1, A3, A4<br>(c) X2 + A2, and<br>(d) A4<br>+ A1.<br>Does this scheme abide by 1st, 2nd, and 3rd Normal Forms? If not, please show the<br>table(s) after each phase.<br>

Extracted text: Consider the following relational scheme: X1 A1 A2 X2 АЗ A4 A5 The attributes that are part of the primary key are underlined and shaded. Assume that Following functional dependencies exist: (а) X1, X2 A1, A2, АЗ, А4, А5 (b) X1, » A1, A3, A4 (c) X2 + A2, and (d) A4 + A1. Does this scheme abide by 1st, 2nd, and 3rd Normal Forms? If not, please show the table(s) after each phase.

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here