## [answered] Assignment 7: Due November 21. (1) Map (that is, transform/

Assignment 7: Due November 21.

(1) Map (that is, transform/convert) Figure 3-6 (b) (page 121) into relations. This figure shows ?Partial

specialization Rule? for VEHICLE as supertype and CAR and TRUCK as subtype. This figure is on page 119

(fig. 3-4b) in the 10th edition. You can use the study NOTES below. More specifically, use the notes ?d.

Relationship (supertype/ subtype?)

(2) Describe a relation in FIRST NORMAL FORM (1NF).

(3) Show a table that is NOT in 1NF.

(4) Show the above table by converting it to 1NF.

(5) Describe what a ?functional dependency? is. Describe what a ?partial functional dependency? is.

Show an example of a functional dependency by: Drawing a table with clearly marked primary key and a

functional dependency.

List the functional dependency with proper form (that is, A B)

In two/three sentences, explain what you showed means. That is describe, why the functional

(6) Describe what a ?transitive dependency? is.

Show an example of a transitive dependency by: Drawing a table with clearly marked primary key and a

transitive dependency.

List the transitive dependency with proper form (that is, A B)

In two/three sentences, explain what you showed is a transitive dependency.

(7) In your words, describe why any dependency is bad for a relation (i. e., table) or database.

(8) Describe what a determinant is.

(9) On page 179 of the text, examine the relation EMPLOYEE2 in Figure 4-23 (b). (NOTE: This diagram is

on page 181 of 10th edition). Bring this relation to 3NF. You must list the dependencies and the steps

you are performing for each stage.

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001005060.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 18, 2020

EXPERT

Tutor