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. - Sheep are cared for by shepherds and live in pens. Each shepherd has a unique ID (Shepherd ID) as well as a name (Shepherd Name) and a shirt size (Shepherd Size). - A shepherd may look after several pens. A given pen is controlled by one shepherd only. Each pen is identified by a unique Pen ID. Each pen also has a value (Pen Value) and a capacity. - A given sheep lives in one and only one pen. Each sheep is assigned a Sheep ID and has a weight (Sheep Weight) and a value (Sheep Value). Exercise 5.8 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. - Magicians are identified by IDs (Magician ID). They have names (Magician Name) and daily rates which they charge for their magic tricks (Magician Rate). Magicians belong to Magic Clubs. A magician may belong to more than one club. And more than one magician may belong to a club. - Each club is identified by a unique club name (Club Name). However, once in a while a club changes its name. Each club has a mailing address (Club Address) and a phone number (Club Phone). - The tricks that magicians can show are described in the master trick catalog. Each trick has its own unique trick ID (Trick ID), a descriptive name (Trick Name), and a rating in terms of how amazing it is (Trick Amazing). - Most magicians are capable of performing many different tricks. It is possible for several magicians to perform the same trick. Each magician has a magic trick competency rating (Trick Competency) for each trick which he or she is capable of performing