Scenario OutlineBuilding Table Relationships

A few database tables and the relationships between them.

You are part of the team that has been hired to design a database for ProAudio, a music selling business. Now that the team has completed the requirements document it is time to start building the relations.

Reviewing the Normalization

Back

Pulse

teammates have created.

The following relation was given to you for review.

$\backslash$table$[[$c$\_$id f$\_$name,$\backslash$table$[[$I$\_$name$],[$Doe$]],\backslash$table$[[$address$],[123$ Elm St$]],$city state,zip ord$\_$nolitem$\_$id$,\backslash$table$[[\backslash$table$[[$title$],[$More$],[$Blues$]]]],\backslash$table$[[\backslash$table$[[$price$,$or$]]],[8\mathrm{.}99]]],[01,$Jane,Ely,$NY,1111,1-1,12-31$

You are tasked with reviewing the initial build of the relations your teammates have created.The following relation was given to you for review.Image describing the table relation informtion

Discussion Questions

$1.$ What normal form is the relation in$?$

$2.$In the present form what types of anomalies could occur? Give $3$ specific examples for the table stating the data in its present form.

$3.$How can these be fixed$/$avoided$?$ Give specific feedback referring to the table and the data given