$1.$ Normalization $$ using the fields included in worksheet, start the normalization process to

determine the unique entities and their attributes. New attributes$/$fields may$/$can be created as

needed to take care of any dependencies. Remember the goal is to come up with unique

entities in which all attributes in the relations$/$tables are fully dependent on the primary key.

Normalize this data to $3$NF $(20$ points$)$

$2.$ ER$/$Relational Schema Diagram $$ create an ER diagram for your normalized entities$/$tables$.$ Be

sure to indicate primary keys with an underline and foreign keys with an FK abbreviation after

the attribute name. Label the cardinality of the relationships between the entities$/$tables$.$

Avoid any composite and multi$-$value attributes. This can be completed via Dia, Visio, or by

hand $($scan to a PDF$)(15$ points; extra incentive points for using Dia or Visio $$ see next page$)$

$3.$ Design each entity$/$table by providing a good table name, all attributes$/$fields with good field

names, and detailed properties about each attribute$/$field $($data types and properties that

should be associated with each field$).(40$ points$)$

$4.$ Develop the SQL statements or queries for at least $5$ of the questions below:

$1.$ How many organic only applications were applied?

$2.$ Who are the customers that prefer organic only chemicals?

$3.$ How much does each customer owe for each application date?

$4.$ Who are Jay Stephen$$s customers?

$5.$ Who are the customers that live in Dylan Dreyfus$$s service area?

$6.$ Which chemical are we using the most amount?

$7.$ How many customers do each technician currently service?

$8.$ How many gallons of applications were applied by technician?

Indicate which query number selected and provide a syntax$-$correct SQL statement to an