1.2) officeNo officeAddress telNo ugrStafiNo пате ВО01 8 Jefferson Way, Portland, ME 97201 503-555-3618 S1500 Tom Daniels ВО02 City Center Plaza, Seattle, WA 98122 206-555-6756 S0010 Mary Martinez...


Explain clear thanks


1.2)<br>officeNo<br>officeAddress<br>telNo<br>ugrStafiNo<br>пате<br>ВО01<br>8 Jefferson Way, Portland, ME 97201<br>503-555-3618<br>S1500<br>Tom Daniels<br>ВО02<br>City Center Plaza, Seattle, WA 98122<br>206-555-6756<br>S0010<br>Mary Martinez<br>B003<br>14 – 8th Avenue, New York, NY 10012<br>212-371-3000<br>S0145<br>Art Peters<br>ВО04<br>16 – 14th Avenue, Seattle, WA 98128<br>206-555-3131<br>S2250<br>Sally Stern<br>Primary key: officeNo<br>a) Why the above table is not in 3NF?<br>b) Describe and illustrate the process of normalizing the data shown in this table to third<br>normal form (3NF).<br>c) Identify the primary and foreign keys in your 3NF relations.<br>

Extracted text: 1.2) officeNo officeAddress telNo ugrStafiNo пате ВО01 8 Jefferson Way, Portland, ME 97201 503-555-3618 S1500 Tom Daniels ВО02 City Center Plaza, Seattle, WA 98122 206-555-6756 S0010 Mary Martinez B003 14 – 8th Avenue, New York, NY 10012 212-371-3000 S0145 Art Peters ВО04 16 – 14th Avenue, Seattle, WA 98128 206-555-3131 S2250 Sally Stern Primary key: officeNo a) Why the above table is not in 3NF? b) Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF). c) Identify the primary and foreign keys in your 3NF relations.

Jun 10, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?