If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Looking for advice on database design

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-30-09, 08:30
jedimatt jedimatt is offline
Registered User
 
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
Looking for advice on database design-database-ear-diagram.jpg  

Last edited by jedimatt; 07-02-09 at 06:39.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On