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 SurgeryPatientPatient Address Surgeon Surgery u Surgery Drug Admin Observed Name Date 1/1/15 John Yellow 123 Brown St., 12/6/15 John Yellow 123 Brown St., 2/2614 John Yellow 123 Brown St., ID Side Effects Name 345 Gallstone Jing Kerr 263 | Kidney stones | None Chrstina263 Kidney stones Tetrion 145 Cem Charlotte, NC 28223 Kumar Charlotte, NC 28223 Charlotte, NC 28223 Sty None 11 523 Aches, 1234 243 514/16 Macy Pones 435 Crook Ln, Li Roberts222 Eye cataradt Tetracycline Fever Concord, NC 28209 removal 1234 467 0515 Macy Pones 435 Crook Ln, 543 Thrombosis Concord, NC 28209 NC 22222 Cake 4876 145 5123 523 6845 243 5123 523 6845 243 5/11/14Jake Mann 4 Sharon Avenue, Cem 2/26/14 Robert 2/26/14Liz Johns 42 Rt. 16, Charlotte, Li Roberts 256 Eye comea 5/2114 Robert 15/12/13 Liz Johns42 Rt. 16, Charlotte,Li Roberts 256 Eye comea None Charlotte, NC 28207Kumar 1223 Brown St. Charlotte, NC 28223 Christina3 345 Gallstone Brown Tetracycline Fever NC 28207 1223 Brown St. Charlotte, NC 28223 Headaches Christina 345 Gallstone Brown Hypotheticon None 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