Below we have a case study: "Imagine Dublin port has just launched a user friendly and simple web based tool called the

[answerhappygod]

Below we have a case study:
"Imagine Dublin port has just launched a user friendly and
simple web based tool called the “Dublin’s Digital Bay”. The web
tool is located at www.itbdublindigitalbay.ie . The Web site allows
users to access real-time bay data through a Web client in a Web
browser. Users of the Web site also have the ability to dynamically
select how and what data they would like to view. Using a clever
mix of Web2.0 technologies users can view historical data for their
chosen preferences. For example, users may wish to graph Dublin
bay’s surface water temperature versus time for the past seven days
using the interactive jQuery based graphing tool. Or even graph
together the tidal data at two different locations for the same
time period to compare the difference. Friendly client interface
user symbols are used to make the Website more user friendly. The
Digital Bay Web tool is the front end to a robust and reliable
relational database that allows historical bay data to be recalled
through SQL commands via server-based scripts. These scripts can
feed the data back to the Web client front end based on specific
user preferences. By the default the Web client will display the
last data from the database. The database stores data as it is
arrives from various sources, or reporting systems. The database
captures weather data from 3 monitoring stations located at 1)
north-shore light 2) Dun Laoghaire Pier 3) Baily Lighthouse. The
monitoring stations house various under water and surface sensors.
Each source is a data logger with attached sensors, also referred
to as an in-situ remote data monitoring system. Each system has a
number of sensors used to capture reading and observations about
the various physical phenomena. Each station must have at the very
least 1 sensor, but can have many. That 1 sensor must be water
temperature sensor, but the station may have any of the following
sensors: anemometer, hygrometer, Pyranometer, rain gauge,
barometer, Dissolved oxygen, tidal gauge. A station generates a
report every 30minutes and the database stores these
persistently."
Q. 1 Please develop the:
Conceptual Model.
Solution of Many-to-Many
relationships.
Normalisation of all tables to 3rd
Normal Forms.
Functional dependency diagrams
showing each table in 3rd normal form