Answered step by step
Verified Expert Solution
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
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 inStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started