Additional Information:

$-$Each patient has at least one appointment. Each appointment is for a specific patient.

$-$Each appointment is handled by a specific provider. Each provider may handle one or more appointments $($or may have no appointments$).$

$-$Each appointment has one or more block codes. Each block code is for a specific number of minutes and can be applied to one or more

appointments.

$-$Each appointment has one or more treatment codes. Each treatment code has a specific block code and a specific rate and can be applied to one or more appointments.

$-$Each appointment has one billing type. Each billing type may be assigned to one or more appointments $($or to no appointments$).$

$-$Each appointment has a specific appt status code applied. Each appt status code may be assigned to one or more appointments $($or to no

appointments$).$

$-$Each appointment has a specific pmt status code applied. Each pmt status code may be assigned to one or more appointments $($or to no

appointments$).$

Based on the information provided above, complete the following:

$1.$ FIRST NORMAL FORM $(1$NF$)$:

a$.$ Create a dependency diagram for the table above.

$2.$ SECOND NORMAL FORM $(2$NF$)$:

a$.$ Show the table structure format for each table in $2$NF$.$

b$.$ Create the dependency diagrams for the resulting tables.

$3.$ THIRD NORMAL FORM $(3$NF$)$:

a$.$ Convert to $3$NF and show the table structure format for each table.

b$.$ Create the dependency diagrams for the resulting tables.

$4.$ ENTITY$-$RELATIONSHIP MODEL:

a$.$ Create the Relational Schema for all the $3$NF tables.

b$.$ Using Chen notation, create an ERD showing all the $3$NF tables. You must show the entities, relationships, connectivity, participation, and

cardinality $($do not show the attributes on the ERD$).$