(Solved) : Note Need Someone Good Database Mysql Design Please Don T Rush Solve Read Carefully Questi Q28892954 . . . .

NOTE: I need someone who is good at database MySQLdesign. Please don’t rush to solve it and read carefully questions.I don’t want vague answers.Thank you!

Given the unnormalized table below, answer the followingquestions step-by-step in the given order. Note that capitalletters (A, B, …) represent attribute names and lower-case letterstheir values.

A

B

C

D

E

F

a

b

c

h

d

i

e

j

f

k

l

m

h

d

e

f

n

o

c

r

i

s

j

e

k

f

a) Bring the table into the first normal form (1NF).

b) Now, identify all functional dependencies on the table whichis in 1NF and determine all the candidate keys.

c) Bring the table into the second normal form (2NF).

d) Bring the table(s) into the third normal form (3NF).

e) Then, determine all primary and foreign