First normal form

$\{$pid$,$ pname, pprice, pqty$,$ cid, cfname, clname, cadd, cstreet, ccity, cstate, czip, cphone, eid, efname,

elname, ephone, elevel, erate, sdate, shours$\}$

Second normal form

$\{$pid$,$ pname, pprice$\}$

$\{$cid$,$ cfname, clname, cadd, cstreet, ccity, cstate, czip, cphone$\}$

$\{$pid$,$ cid, sdate, pqty$\}$

$\{$cid$,$ sdate, eid, efname, elname, ephone, elevel, erate, shours$\}$

Third normal form

$\{$pid$,$ pname, pprice$\}$

$\{$cid$,$ cfname, clname, cadd, cstreet, ccity, cstate, czip, cphone$\}$

$\{$pid$,$ cid, sdate, pqty$\}$

$\{$cid$,$ sdate, eid, shours$\}$

$\{$eid$,$ efname, elname, ephone, elevel$\}$

$\{$elevel$,$ erate$\}$

Table names and Type

PART $\{$pid$,$ pname, pprice$\}$ ENTITY

CUSTOMER $\{$cid$,$ cfname, clname, cadd, cstreet, ccity, cstate, czip, cphone$\}$ ENTITY

Buys $\{$pid$,$ cid, sdate, pqty$\}$ Composite Relationship

Service $\{$cid$,$ sdate, eid, shours$\}$ Relationship

ELECTRICIAN $\{$eid$,$ efname, elname, ephone, elevel$\}$ ENTITY

SKILL $\{$elevel$,$ erate$\}$ ENTITY INSTRUCTIONS: $1.$ Use MS Visio and create an Entity Relationship $($ER$)$ and Relationship Schema $($RS$)$ in Chen Notation with cardinality OR create an ER diagram with Crow's Foot notation from the $3^{rd}$ normal form tables in the provided solution. This part is IMPORTANT Please provide Clear hand drawing diagram or provide a picture of using $***$Ms Visio Diagram$***$ with clear connections between each Entities.

$2.$ Creat a data dictionary in your word document. A data dictionary is meta data about the data elements. For each attribute, this data dictionary should include the attribute name, attribute data type, attribute length, attribute format, tables where the attributes can be found, constraints on the attribute $($such as primary key, foreign key, length restrictions$),$ description, and an example. Note: some format and constraints will be blank.