design a database & web appQuestion:
i am going to write a simple mvc application - I basically have this sheet and I need to write a website .
A job consists of a sheet being given to the ‘workers'
Each job has a source and a client and work description and ward .
Each sheet can have many ‘sites’ and many ‘teams’ assigned to clean the graffiti .
each site can have many chemicals too.
each team assigned to the job can have many 'risk element' and many 'control measures'
How do I go about designing the database and then turning this into an mvc application .
How do i design the database to avoid duplication ....and start of the design in mvc