Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer each part of the question Identify all functional dependencies and develop a set of normalized tables for the following scenario. Draw the entity/attribute

please answer each part of the question

image text in transcribed

image text in transcribed

Identify all functional dependencies and develop a set of normalized tables for the following scenario. Draw the entity/attribute listing for each table. Explain in detail why your design is normalized. - Horses are cared for by trainers and live in horse barns. - Each trainer has a unique ID (Trainer ID) as well as a name (Trainer Name) and a shoe size (Trainer Size). - A given horse lives in one and only one horse barn. Each horse is assigned a horse ID (Horse ID) and has a weight (Horse Weight) and a value (Horse Value). - A trainer may operate several horse barns. A given horse barn is operated by but one trainer. Each horse barn is identified by a unique horse barn identifying number (Horse Barn ID). Each horse barn also has a capacity (Horse Barn Capacity) and a value (Horse Barn Value). A given trainer cares for all of the horses kept in any barn he or she owns. Thus you can tell the trainer for any given horse if you know the barn the horse lives in. Exercise 5.10 Identify all functional dependencies and develop a set of normalized tables for the following scenario. Draw the entity/attribute listing for each table. Explain in detail why your design is normalized. - Painters are identified by unique IDs (Painter ID). They have names (Painter Name) and daily rates which they charge for their commissions (Painter Rate). - Painters belong to clubs. A given painter may belong to more than one club. More than one painter can belong to any particular club. Each club is identified by a unique name (Club Name). Once in a while a club changes its name. Each club has a mailing address (Club Address) and a phone number (Club Phone). - The painting mediums that the painter can paint in are described in the master medium catalog. Each type of medium (watercolor, oil, gouache etc.) has its own unique medium identifier (Medium ID), a descriptive name (Medium Name), and a rating in terms of how skilled it is (Medium Skill). - Most painters are capable of painting in many different types of medium. It is also possible for several different painters to work in the same medium. Each painter has a painter competency rating (Medium Competency) for each type of medium that he or she is capable of working in

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

Step: 3

blur-text-image

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

Database And Expert Systems Applications 31st International Conference Dexa 2020 Bratislava Slovakia September 14 17 2020 Proceedings Part 1 Lncs 12391

Authors: Sven Hartmann ,Josef Kung ,Gabriele Kotsis ,A Min Tjoa ,Ismail Khalil

1st Edition

303059002X, 978-3030590024

More Books

Students also viewed these Databases questions

Question

What is focal length? Explain with a diagram and give an example.

Answered: 1 week ago

Question

What is physics and how does it apply in daily life?

Answered: 1 week ago