|
| |
|
|
abbeyvet
Posts: 5094
From: Kilkenny Ireland
Status: offline
 |
Database Logic - 3/3/2003 12:02:17
It' s a bit scary even coming in here, never mind actually posting!!  
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?
_____________________________
Katherine
:: InKK Design :: InKK Domains
|
|
|
|
Doug G
Posts: 1193
Joined: 12/29/2001
From: SoCal
Status: offline
|
RE: Database Logic - 3/3/2003 19:37:31
Without sitting down and sketching out a db, it sounds like you' ll want an intermediate table holding course, job, course status and job status, something like
COURSE TABLE
-------------------
courseID
courseName
...
JOB TABLE
-------------
jobID
jobName
..
COURSE-JOB TABLE
------------------------
courseID
jobID
courseStat
jobStat
_____________________________
======
Doug G
======
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 