Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2011
    Posts
    3

    Unhappy Urgent help needed ?? plz :(



    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.
    Attached Thumbnails Attached Thumbnails e-r-2.jpg  
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the diagram seems pretty straightforward (other than the weird naming convention)

    what question did you have regarding this model?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2011
    Posts
    3

    Exclamation thanks for the reply

    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
    Attached Thumbnails Attached Thumbnails e-r-2.jpg  
    Attached Files Attached Files

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by LucySmith View Post
    can someone check my E-R diagram and see if it is normalised properly to 3rd NF
    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

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jul 2011
    Posts
    3

    Thumbs down reply

    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.

  6. #6
    Join Date
    Jul 2011
    Posts
    14
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •