Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2009
    Posts
    8

    Looking for advice on database design

    Hello,

    I am looking for some advice on a databse design.
    I am in the process of developing an application for our in house training team.

    What we are trying to achieve is to have an admin select a workarea which has a pre-defined set of Training elements in it.
    These elements can be removed if required from the pre-defined list before adding to the employees record.

    What is the best way to model this?
    I have had a go but i am not convinced that this is correct.
    I am open to any advice.

    I have attached the EAR diagram.

    many thanks

    Matt

    UPDATE

    I have been working on this solution and now have a more , hopefully improved ear.(Uploaded)
    If anyone can comment on this i would be very greatful.

    Many thanks

    Matt
    Attached Thumbnails Attached Thumbnails DATABASE EAR DIAGRAM.jpg  
    Last edited by jedimatt; 07-02-09 at 06:39.

Posting Permissions

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