Lab $3-$ Introduction to Normalization $($Chp $6)$

Every paint store offers a variety of paint colors using a formula of base paint mixed with a

pre$-$defined set of colorants $($there is not a set standard of colorants$).$ Shots of colorant are

added to the base and the mixture yields the desired paint color. Below are the colorants

used by Ralph Lauren along with formulas for some of their fancy color paints, using a

$1-1/48-1/96$ formula scheme. At the end of the lab, under Colorant & Paint Formula

Tables, is a screenshot of an Access file, PaintFormulas.accdb. NOTE: The Volume

column represents the number in the denominator $($i$.$e$.,1$ is for $1,48$ for $\frac{1}{48},$ and $96$ for

$1/96).$ If you did not complete the pre$-$lab ahead of time, then answer questions $1-5,$ which

are to be turned in with your Lab $3$ scripts. Otherwise, skip to question $6.$

What is your composite key? This is a little tricky because I only list gallon paint

formulas. Consider that paint also comes in quart size cans!

Does any attribute of your composite key by itself determine another attribute? If so$,$

what is the attribute and what does it determine?

What potential problems do you identify with this type of setup for a table $($what

update, insert and delete anomalies might exist$)?$

Do any of your non$-$composite key attributes determine other attributes? If so$,$

which ones?

Over time, color formulas change. What database records would need to be

changed if Dusty Mauve changed to the following formula instead? Give the

Colorant name, the volume, and the quantity.

Dusty Mauve:

B $0-20-0$

T $0-29-1$

V $1-10-1$