[Solved]Given Following Relation Person Lastname Firstname Eyecolor Height Weight Sibling Pet Heig Q37037037

1. Given the following relation:

PERSON (LastName, FirstName, EyeColor,Height, Weight, Sibling, Pet)

Where Height is in inches and Weightis in pounds.

Sibling consists of three fields:Relationship (i.e. brother, sister), FirstName, LastName

Pet consists of two fields: Type andName (i.e. Dog, Fido)

Assume the following functionaldependencies exist:

(LastName, FirstName) –>–>Sibling

(LastName, FirstName) –> –>Pet

(LastName, FirstName) -> (EyeColor,Height, Weight)

1. Assume the following:

Harry Smith has 2 siblings and 2pets,

Susan Jones has 1 sibling and 2pets,

John Peters has no siblings and 1pets,

Anne Baker has 2 siblings and nopets,

Jamie White has no siblings and nopets.

Create a sample table representing theabove functional dependencies (create appropriate data values).Note Siblings are also a member of PERSON thus must be included inyour table. Assume siblings have the same last name to makeidentification easier in the grading process. Make up fictionaldata about siblings, however some siblings must have pets. WordInsert Table – Insert Table option specify rows and columns.

LastName

FirstName

EyeColor

Height

Weight

Sibling

Pet

2. What normal form is PERSON in and why?

3. Describe the deletion, modification and insertion anomalies forthis relation.

4. Place the PERSON relation into 4NF. Identifythe primary, foreign keys and alternate keys if any.

5. Using the information from question1a) above, populate the new tables you created basedon question 1d).

Expert Answer

---

Answer to Given the following relation: PERSON (LastName, FirstName, EyeColor, Height, Weight, Sibling, Pet) Where Height is in i… . . .