based on accuracy$)$

Create a set of $3$NF normalized relations $($or tables$)$ given the sample data$/$form below. Do not draw a dependency diagram; only the relational schema is needed.

$-$ Start with a single table $($could be in NNF$)$ and then proceed to $1$NF $($no multivalued attributes and has good PK$).$

$-$ In the $1$NF relations, determine all the dependencies.

i$.$ Proceed with $\backslash (2$ N F $\backslash )$ and $\backslash (3$ N F $\backslash )$ just like in the Project example in Chapter $6.$ Determine the dependencies at each step.

ii$.$ Or determine the dependencies in the $1$NF table using A$->$B notation and write out all the tables in $3$NF$.$

$-$ No need to draw and ERD, use the relational schema format:

i$.3$NF TABLE$\_$NAME $($Attribute$1,$ Attribute$2,.....)$ underline the PK$.$

$-$ State clearly any $($reasonable$)$ assumptions you may make. Problem $3$

Business Rules:

$-$ The bill is issued a few days $($not a set number of days$)$ after the discharge date.

$-$ Each charged item belongs to a specific cost center.

$-$ Each item belongs in a single cost center.

$-$ All subtotals and the balance due are computed.