Hi, first time im using this forum and wonderd if anyone could help me?
I am attempting to develop a project mangement webtool for uni but extremely confused with the database E-R design using normalisation. I have attached an access db file which I have used to generate the e-r diagram.

simply, this project will allow a project manager to manage projects a bit like ms project but more simpler, record expenses, send internal messages, and allocate staff to different tasks in each project.

Any questions, please ask im on all day so will reply promptly.

the diagram seems pretty straightforward (other than the weird naming convention)

what question did you have regarding this model?

sorry i have made some changes now as the accounts table wasnt necessary i think, and the employee cost attributes have been moved to skills table.

My question was, can someone check my E-R diagram and see if it is normalised properly to 3rd NF. Thanks

updated diagram is attached now thx

sorry, it doesn't work that way

you're asking us to do your job

we'd be happy to answer specific questions, but you have to do the work

think you have a missunderstanding - I never stated or asked for somone to do my normalisation. I asked whether someone can "CHECK" my diagram conforms to the normalisation theory. Anyway, if you dont want to help then fine.

Hey Lucy,

As r937() says, nobody has time to go over your project and help you as a consultant. But anyway, I try to clarify some points for you.

1. your naming convention is horrible. Revise it first.
2. deptDirector and deptSecretary get their values from employees table, right? otherwise, this table is not normalized.
3. line_manager should come from the employees table.
4. I have no idea what attachments are?
5. skills table is in 2NF, so, decompose it. Figure out how?
6. You don't need id for time sheet. This is not the case that every table needs an ID!
7. Where do expense_type and status come from? They should have their own tables.
8. manager in project table should come from the employee table but there is no relation in your ER.
9. securityLever in project table should have its own table.
10. clients table is in 2NF, so, decompose it.
11. I have no idea what the account table want to say? Sorry!

Does this work for you?
These are what I figured out in a glance. Sorry, if I couldn't spend more time.