Consider the following instance of the EMPLOYEE relation: name seniority 12 bonus rating 100K deptID deptName deptAddress CIS Eid sal 1 Ali 8K 2 Amman Amer 4 3K 4 60K CIS Amman 2 Amer 4 3K 60K CIS...

Consider the following instance of the EMPLOYEE relation:<br>name seniority<br>12<br>bonus rating<br>100K<br>deptID deptName deptAddress<br>CIS<br>Eid<br>sal<br>1<br>Ali<br>8K<br>2<br>Amman<br>Amer<br>4<br>3K<br>4<br>60K<br>CIS<br>Amman<br>2<br>Amer<br>4<br>3K<br>60K<br>CIS<br>Amman<br>3<br>Walid<br>4<br>3K<br>60K<br>4<br>MIS<br>Irbed<br>4<br>Emad<br>12<br>8K<br>100K<br>CIS<br>Amman<br>Rami<br>4<br>3K<br>4<br>60K<br>4<br>MIS<br>Irbed<br>By observing this instance, we see several repeating groups of values. Decompose an EMPLOYEE relation<br>into a collection of BCNF relations.<br>

Extracted text: Consider the following instance of the EMPLOYEE relation: name seniority 12 bonus rating 100K deptID deptName deptAddress CIS Eid sal 1 Ali 8K 2 Amman Amer 4 3K 4 60K CIS Amman 2 Amer 4 3K 60K CIS Amman 3 Walid 4 3K 60K 4 MIS Irbed 4 Emad 12 8K 100K CIS Amman Rami 4 3K 4 60K 4 MIS Irbed By observing this instance, we see several repeating groups of values. Decompose an EMPLOYEE relation into a collection of BCNF relations.

Jun 09, 2022

SOLUTION.PDF

Consider the following instance of the EMPLOYEE relation: name seniority 12 bonus rating 100K deptID deptName deptAddress CIS Eid sal 1 Ali 8K 2 Amman Amer 4 3K 4 60K CIS Amman 2 Amer 4 3K 60K CIS...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment