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) Patient Surgeon Surgery Patient Patient AddressSurgeon Surgery Surgery Drug Admin Oserved Date 11/15 John Yellow 123 Brown St 12/6/15 John Yellow 123 Brown St 226/14John Ylow 123 Brown St Side Effects Cem ing Kerr263 Christina 263 Rash, None Aches, 345 Gallstone Charlotte, NC 28223Kumar Kidney stonesNone NC 2 1111 523 Kidney stones Tetrion Charlotte, NC 28223 Sty 5/4/16 Macy Pones 435 Crook Ln, 105/15 Macy Pones 435 Crook Ln, 8/6/12 Charlie Burr 1158 Carolina Av.. Patty 5/11/14Jake Mann 4Sharon Avenue, Cem 2/26/14Robert 2126/14 is 42 Rt. 16, Charlotte, Li Roberts 256 Eye comea 5/21/14Robert 15/1213 Liz Johns 42 Rt. 16, Charlotte, Li Roberts 256 Eye comea Li Roberts222Eye cataract Tetracycine Fever 1234 243 1234 467 2345 189 4876 145 5123 523 6845 243 5123 523 6845 243 Conoord, NC Concord, NC 28209 Raleigh, NC 22222 Cake Charlotte, NC 28207 Kumar 543 Thrombosis 976 Open heart Cephalosporin Nausea 1223 Brown St. Christina3 345 Gallstone None Tetracycine Fever Rash Hypothetcon None NC 28207 1223 Brown St, Charlotte, NC 28223 Chrisina3 345 Gallstone 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