Your task is to design a database that will satisfy the data collection of the Water Quality Data that will be collected next summer $2.$ Using some form of template $($use in order to complete a good data design$)3.$ It must include: a$.$ Table Names b$.$ Field Names with data types c$.$ Acceptable values $($mins$,$ max, ranges, defaults, etc$)$ d$.$ You will need to identify Relationship Classes $($Tables and Fields that relate$)4.$ Include a graphic representation of your Entity Relationship Diagram $($ERD$)$ so that others may easily follow what you have designed $5.$ You will zip any and all materials $($templates and ERD Logical Design$)$ and ONE team member can submit via the dropbox $6.$ Be prepared to present your DB Design in the next class, To Be Presented: a$.$ Purpose$/$Goal of database b$.$ Presentation or display of the $$Entity Relationship Diagram$($step $1$ above$)$ c$.$ Presentation or display of required tables and table layouts $($Step $2/3$ above$)$ d$.$ Presentation or display of metadata table $($Step $2/3$ above$)$ e$.$ Be prepared to defend your table design and answer questions to the instructor and class $.$

You have been hired to create a new database that will be used to manage the Parks Water Quality Sampling Program. There is a variety of data types for location and attribute information. First thing you should do is think about the data; fields, names, data types, what kind of data might be going into them, are there any efficiencies and normalization. There probably is a lot of consistent, repetitive data, especially consider making drop downs or look ups for these. What about relationship classes $($eg$.$ Site is related to Site Detail related to Sample$)?$ Here are some of the RULES for the Water Quality Database: $$ Sampling Sites $($locations$)$ are identified as locations with $2$ sample depths $(0$ m$-$ surface, $5$ m deep$)$ Each Sampling Site is identified as a Multi $($tests for ALL parameters$)$ or a Beach Site where only tests for Fecal Coliforms are completed $$ Sampling Sites are each sampled on the $1$st and the $15$th of the month for the months of May through September $$ Site Details are the records of each sampling activity for each visit and includes temperature, pH$,$ O$2$ and turbidity $($using a secchi disk$)$ for each depth $$ Parameter Samples are collected at each visit from each site for each depth and include Ammonia, Nitrogen, Phosphorus, Fecal, Nitrates.

Sample Site $$UTM Location $$Type $($Fecal$,$ Multi$)$ Sample Visit $[2$ depths$]$Date $$Depth $$Temp $$Dissolved O$2$ Lab Sample Parameters $[2$ depths$]$ Figure $2.$ Data flowchart illustrating data collected at sampling locations $$pH $$Ammonia $$Nitrogen $$Phosphorus $$Fecal $$Nitrates