Hi - My job may very well depend on this.

[VampHeartless]

I'm new to database designing, and my first project is to build a website and database for the proposal development department at my job.

After reading up, this is the design I've gone with:
Proposal Database

I know this is really complicated for my first project. There is a lot of many to many relationships that I'm not sure that I need. I've tried to normalize it as much as I could, but thought I would post it here to get professional opinions.

Also, is it possible to create a form that would update the junction tables between the make to make relationships? For example, if I wanted to add Criteria from the EvaluationCriteria table to the first Proposal in the Proposal table, would I have to go in and manually update the Proposal_Evaluation table each time?

Any help would be greatly appreciated.

[rmiao]

You can create relationship with cascade delete/update option if the rdbms you use supports that, or enforce it in trigger.