The following table lists the allowance per hour provided to employees of Mega Corp based on their experience and project cost.

$\backslash$table$[[\backslash$table$[[$Project$],[$No$]],\backslash$table$[[\backslash$table$[[$ProjectNam$],[$e$]]]],$Branch,Area,$\backslash$table$[[$StaffI$],[$D$]],\backslash$table$[[$StaffNa$],[$me$]],\backslash$table$[[$AllowancePer$],[$Hour$]]],[$P$15,$Speed,KU$,$Kuala,K$123,$Rayyan,$200],[$Highway$,$Lumpur,K$245,$Sani,$250],[$P$24,\backslash$table$[[$Mega$],[$Tower$]],$SHA,Shah Alam,K$325,\backslash$table$[[$Rajkum$],[$ar$]],200],[$K$234,$Khalid,$180],[$P$36,\backslash$table$[[$Kembara$],[$Park$]],$KUL,$\backslash$table$[[$Kuala$],[$Lumpur$]],$K$123,$Rayyan,$150]]$

a$.$ Determine the primary key of utmost importance in this record.

Answer $2$a:

b$.$ Illustrate, list, and label all the functional dependency diagrams contained in this table.

Answer $2$b:

c$.$ Based on the functional dependencies $($FDs$)$ determined in $($b$),$ simplify the process of normalizing the table into $1$ NF$-3$NF$.$

Answer $2c$ : $\backslash$table$[[,$#lim$=,,$P$!$e$",$s$.$to$,,,$Astepet.mm$],[$:$!,\backslash$table$[[01756\backslash$times $5],[80]],\text{'},$WHES,INytes,rov$\mathrm{.}00,\backslash$table$[[$it$.$Mar$-],[$mat$]],],[$Bes$,$AFAT,Aliso,$=$N$0,,],[$Atiminf$,,$'seia',W$\mathrm{.}235,$White,$160,0,\backslash$table$[[1-$fites$-],[$rogI$1]],\backslash$table$[[1$EMM$],[20$MI$]]],[31=,$Bi$)^(2),$Glug,$10,\backslash$table$[[$Soapp:$],[$Nava$]],\backslash$table$[[$freps$],[-4=2]]],[,$pas:,Esed,$8000,,\backslash$table$[[1-0,0],[2023$:$]]]]$

Anrye!t:SECTION C: PROBLEM SOLVING

The following table presents a sample of student grade data records from FTSM UKM.

$($Choose the two primary keys that most effectively determine the grade.$)$

a$.$ Illustrate, list and label all the functionally dependent $($FD$)$ diagrams contained in this table.

Answer la:

b$.$ Based on the FDs in $($a$),$ simplify the process of normalizing the table into $1$NF$-3$NF$.$

Answer lb:

c$.$ Illustrate the final normalized table as an Entity$-$Relationship Diagram $($ERD$).$

Answer lc:

The following table lists the allowance per hour provided to employees of Mega Corp

based on their experience and project cost.

a$.$ Determine the primary key of utmost importance in this record.

Answer $2$a:

b$.$ Illustrate, list, and label all the functional dependency diagrams contained in this table.

Answer $2$b:

c$.$ Based on the functional dependencies $($FDs$)$ determined in $($b$),$ simplify the process of

normalizing the table into $1$ NF$-3$NF$.$

c$.$ Illustrate the final normalized table as an Entity$-$Relationship Diagram $($ERD$).$

Answer lc: