|
abbeyvet -> Database Logic (3/3/2003 12:02:17)
|
It' s a bit scary even coming in here, never mind actually posting!! [&:][:o]
This will be using ASP, but PHP and MySQL, but it is the logic of how to create the database that is defying me now, and that should be the same no matter how it is later used.
This is the scenario/
A corporate intranet staff training portal. Users (staff) need to be able to find out what course are
a. Mandatory
b. Recommended
c. Optional
d. Irrelevant
for their job function.
There are 16 job functions (will grow) and 115 courses (will also grow)
Need to be able to do two thing, the first being most important.
1. User enters job function and gets a list of courses for that job arranged by whether they are mandatory, recommended or optional. There will be other courses that are irrelevant and these should not be listed.
2. User enters course number and gets a list of job functions for which the course is mandatory, recommended or optional.
Later we may wish to add a user login which would enable users to tick off the courses completed as they complete them, so I want to keep this in mind at this point.
I am staring at this, and maybe it is because I also have a cold and as a result a fuzzy brain today, but I just cannot seem to make a start on seeing how to relate it all.
Any suggestions?
|
|
|
|
