Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer completely and correctly. Thank you! Parrot Palace example Using the data in the attached workbook, No rmalization.xlsx, the workbook. (Refer to slides 28-38

image text in transcribed
image text in transcribed
image text in transcribed
Please answer completely and correctly. Thank you!
Parrot Palace example Using the data in the attached workbook, No rmalization.xlsx, the workbook. (Refer to slides 28-38 in the Chapter 9 slide set under Course Content.) generate 1NF, 2NF,and 3NF views of the unnormalized data on the 3 labeled sheets in For each table, indicate the primary key (could be a combination key) with color or shading of the column(s) that make up the primary key, Note: be awae that a table in 2NF may also be in 3NF, so no further transformation is required Parrot Palace Parrot Palace works with TV and movie producers who need birds that can perform special tricks, such as playing dead, reciting poetry, ladder elimbs, and various other tricks. Parrot Palace has about 50 birds and a ist of 20 tricks from which to choose. Each bird can perform one or more tricks, and many tricks can be performed by more than one bird. When a bird learns a new trick, the trainer assigns a skil level. Some customers insist on using birds that score a 10, which is the highest skill level. As an IT consultant, you have been asked to suggest 3NF table designs. You are fairly certain that an M:N relationship exists between birds and tricks Narrative Unnormalized 1NF 2NF 3NF Skill Level Trainer Bill Paul Sally Paul eff Bird NumberBird Name Species Trick Number Trick Name 10 Spin around 2 Dance 3 Fetch 2 Dance 4 Basketball 3 Fetch 1 Polly Parrot 2 Daffy Duck Duck Duck 10 3 Daisy im eff Paul 4 Basketball 2 Dance 5 Ladder 5 Ladder 4 Basketball 2 Dance 4 Donald 5 Tweety Canary 10 Jim Jeff Paul 01 Harold

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions