Instructions for Problems 1-3 (10 points each, grading is based on accuracy) Create a set of...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these general management questions
-
Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
A(n) ________ is a short-lived fashion. Relatively few people adopt this product, but it can spread quickly. Question content area bottom Part 1 A. fad B. creolization C. aspirational reference D....
-
Who discovered electromagnetic induction, and who put it to practical use?
-
Determine the slope and displacement at point B. Assume the support at A is a pin and C is a roller. Take E = 200 GPa, I = 150(10 6 ) mm 4 . Use the method of virtual work. A -2 m 16 kN/m B 4 m...
-
State Daltons law of partial pressures.
-
Manx Company had $150,000 of net income in 2012 when the selling price per unit was $150, the variable costs per unit were $90, and the fixed costs were $570,000. Management expects per unit data and...
-
Why would it be a good idea to do international business or start an business in Canada? with supporting details related to and backing the point.
-
Hank has a 30% interest in KKC LLC, a calendar year entity. At the beginning of the year, Hank had an outside basis in KKC of $60,000 which included his $10,000 share of KKC liabilities. On July 1st,...
-
Which of the following is responsible for the licensing and regulation of insurance agents? the Office of the Superintendent of Financial Institutions (OSFI) the OmbudService for Life and Health...
-
The impact of social media marketing on brand loyalty Question - a) Provide 3 Independent Variable & 1 Dependent variable b) Provide each variable 5 question Social media is defined by Safko and...
-
1. (a) Define integrated marketing communications. How is coordination of media achieved through integrated marketing communications? (b) Discuss the role that integrated marketing communications...
-
Sandra receives a divorce settlement of $116,000. Her marginal tax rate is 25 percent, and the capital gains tax rate is 15 percent. How much will her account be worth in 20 years under each of the...
-
current year - end financial statements of Cabot Corporation follow. ( All sales were on credit; selected balance sheet amounts at December 3 1 of the prior year were inventory, $ 4 9 , 9 0 0 ; total...
-
What is the probability that a majority of the committee will vote to keep the president in place, if no one changes their minds?
-
Never Trust a Classmate Who Drank PBR in College The B. Hardin Company (Hardin) owned large tracts of citrus acreage in Lake County, Florida. For several years, it planted about 500 acres annually,...
-
Carlton Stokes owns and operates a car-detailing business named SuperShine & Detailing. For $150, Carltons business will hand wash and wax customers cars, vacuum the interior, and thoroughly clean...
-
Briefly describe four database administration trends that are emerging today.
-
What do you need to do if a tutor signs up and wants to tutor in both reading and math? Draw the new ERD, create new relations, and write any SQL statements that would be needed to handle this...
-
List four advantages of SQL-invoked routines.
-
The Delta Company started business on January 1, 2017. The company adopted a standard absorption costing system for the production of ergonomic backpacks. Delta chose direct labor as the application...
-
The Zeta Company manufactures trendy, good-looking, moderately priced umbrellas. As Zetas senior financial analyst, you are asked to recommend a method of inventory costing. The CFO will use your...
-
Crystal Clear Corporation manufactures and sells 50-inch television sets and uses standard costing. Actual data relating to January, February, and March 2017 are as follows: The selling price per...
Study smarter with the SolutionInn App