2. Create a set of normalized relations given the sample data below. Start with a single table (could be in NNF) and then proceed to 1NF, 2NF and 3NF. If the first table is in NNF, explain why it is NNF and the steps to take it to 1NF. Do not draw a dependency diagram for NNF only the relational schema is needed. At each subsequent NF show the relational schema and the dependency diagram for each table. Write out the dependencies. State clearly any (reasonable) assumptions you may make. (35 points) Date Name John YelloW John Yellow John Yellow Name ID Side ing Kem Kidney stones Charlome NC 28223 Charlote, NC 28223 Sty Kidney stones Macy Pones 435 Crook Ln Li Roberts Eye cataract etracycline Fever Crook Ln Concord, NC 28209 Av Jake Mann Sharon Avenue Cholecystectomy Demicillin None None Charlote, NC 28223 Brown Liz Johns ye comea Charlome, NC 28223 Liz Johns FD ye comes Business Rules: . A patient can only have one surgery per day . A patient can have the same surgery multiple times . At most one drug is administered for each surgery . Each drug can have multiple side effects