$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 answer the question $($may copy from Access$).(5$ points per statement; $25$ points; additional correct queries beyond $5$ correct $-2$ points each extra$)$