Instructions for Problems 1-3 (10 points each, grading is based on accuracy) Create a set of...

Transcribed Image Text:

Instructions for Problems 1-3 (10 points each, grading is based on accuracy) Create a set of 3NF normalized relations (or tables) given the sample data/form below. Do not draw a dependency diagram; only the relational schema is needed. Start with a single table (could be in NNF) and then proceed to INF (no multi-valued attributes and has good PK). In the INF relations, determine all the dependencies. i. Proceed with 2NF and 3NF just like in the Project example in Chapter 6. Determine the dependencies at each step. ii. Or determine the dependencies in the INF table using A->B notation and write out all the tables in 3NF. No need to draw and ERD, use the relational schema format: i. 3NF TABLE_NAME (Attributel, Attribute2,.....) underline the PK. State clearly any (reasonable) assumptions you may make. Problem 1 Patient Sarg Surgery Patal Date Name 145 John Yellow John Vellow I 311 523 1234 243 126/15 22614 123 St. CNC 222 123 Brown St. Charlotte, NC 28223 John Vellow123 Brown St. Cha NC2223 105/15 Serge Name Sergey I Com Kamar 345 Galerel 263 Kidney d Macy Po 435 CookLn, Concord, Roberts NC 2209 Mary Pos Charter Jke Man 4Sharon Av 5/3/14 Charl, NC 2827 226/14 Robert Brown 1223 Brown St. Charlon, NC 2223 22/14 LR16, Charle, NC 2307 Jing fam China Sty 23 4876 145 5123 523 6845 243 5123 525 5/21/14 Robert B1223 Cha 6845 243 15/12/13 Liz 05 Cook La Cocond David George NC 28209 118 CAP Ca Righ, NC 22222 Com Ka Roberts Chris Sty NC 2223 R16 Chloe, NC. Roberts 263 Kidney removal 222 543 Eye catarait removal Breg Mmis Oburved Side El Penici Rash, Nus 256 Eyecom roplaucrecxe 345 Calle 256 Tevis Thrombosismoval Penicilin At most one drug is administered for each surgery Each drug can have multiple side effects Your answers (text, images) Abes Ins Tecycline Fever 112 Cholecysty Denicillin Note 345 Galle Constipation Business Rules: A patient can only have one surgery per day A patient can have the same surgery multiple times Tecycle Fever Heade Penici Ra Instructions for Problems 1-3 (10 points each, grading is based on accuracy) Create a set of 3NF normalized relations (or tables) given the sample data/form below. Do not draw a dependency diagram; only the relational schema is needed. Start with a single table (could be in NNF) and then proceed to INF (no multi-valued attributes and has good PK). In the INF relations, determine all the dependencies. i. Proceed with 2NF and 3NF just like in the Project example in Chapter 6. Determine the dependencies at each step. ii. Or determine the dependencies in the INF table using A->B notation and write out all the tables in 3NF. No need to draw and ERD, use the relational schema format: i. 3NF TABLE_NAME (Attributel, Attribute2,.....) underline the PK. State clearly any (reasonable) assumptions you may make. Problem 1 Patient Sarg Surgery Patal Date Name 145 John Yellow John Vellow I 311 523 1234 243 126/15 22614 123 St. CNC 222 123 Brown St. Charlotte, NC 28223 John Vellow123 Brown St. Cha NC2223 105/15 Serge Name Sergey I Com Kamar 345 Galerel 263 Kidney d Macy Po 435 CookLn, Concord, Roberts NC 2209 Mary Pos Charter Jke Man 4Sharon Av 5/3/14 Charl, NC 2827 226/14 Robert Brown 1223 Brown St. Charlon, NC 2223 22/14 LR16, Charle, NC 2307 Jing fam China Sty 23 4876 145 5123 523 6845 243 5123 525 5/21/14 Robert B1223 Cha 6845 243 15/12/13 Liz 05 Cook La Cocond David George NC 28209 118 CAP Ca Righ, NC 22222 Com Ka Roberts Chris Sty NC 2223 R16 Chloe, NC. Roberts 263 Kidney removal 222 543 Eye catarait removal Breg Mmis Oburved Side El Penici Rash, Nus 256 Eyecom roplaucrecxe 345 Calle 256 Tevis Thrombosismoval Penicilin At most one drug is administered for each surgery Each drug can have multiple side effects Your answers (text, images) Abes Ins Tecycline Fever 112 Cholecysty Denicillin Note 345 Galle Constipation Business Rules: A patient can only have one surgery per day A patient can have the same surgery multiple times Tecycle Fever Heade Penici Ra

Answer rating: 100% (QA)

The image presents instructions for problems 13 focused on database normalization to the Third Normal Form 3NF along with a set of business rules and a representation of a database table for Problem 1 ... View the full answer