This is a Database Management Systems problem.

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:

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

a$.$ Decompose the composite attributes into simple attributes.

b$.$ Convert the table above to $1$ NF $($eliminate repeating groups of data and select an appropriate PK $).$

c$.$ Show the table structure format $($table name with PK and all dependent attributes in parentheses$).$

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

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.

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.

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$).$

IMPORTANT:

Hand$-$written assignments will not be accepted. You should use Visio, draw.io$,$ or similar software to create the diagrams.