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.

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 Name Surgety Drug Admin Obeerv Patient Addreas Surgeon Surgery Date ID 145 345 Galstone Rash, 1115 John Yellow 123 Brown St., 1215 John Yellow 123 Brown St., John Yellow 123 Brown St., Charlotte, NC 28223 Kumar Charlotte, NC 28223 Charote, NC 28223 Sty ing Ke263Kidiney stones None Kidiney stones Tetrion 1234 243 5416 Macy Pones 435 Crook Ln, Li Roberts222 Eye cataract Tetracycline Fever Concord, NC 28209 435 Crook Ln, Concord, NC 28209 Macy 189 8612 Chalie Burr 1158 Caona A., Paty NC 22222 Cake 976 Open heart 2345 4876 11/14 Jake Man 4Sharon Avenue Charlotte, NC 28207 Kumar 1223 Brown St Charlote, NC 28223 5123 523 2/2514Robert 345 Gallstone Liz Johns 42Rt 16, Charlotte, Li Roberts NC 28207 5123 523 52114Robert 1223 Brown St Charlote NC 28223 345 Gallstone Rash 6845 243 15/1213 42Rt 16, Chalotte, Li Roberts 256 Eye comea Hypotheicon 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