Hi List - been a while.
In a nutshell my knowledge of database design and operation is very
basic so I come to you for some advice on how best to set up a simple
database and how to carry out certain operations on it.
What I want to achieve is a database of qualifications that a user can
search through. Each qualification is made up of a title, qualification
level (1 to 4, can be multiple values), a list of mandatory units and a
list of optional units. These units come from a user-managed list. Each
unit is made up of a title and a type (mandatory or optional).
Here's what I'm thinking so far:
Units table has a unique record ID, title text, type text
Qualifications table has a unique record ID, title text, level text
(comma-delimited values), mandatory units text (comma-delimited values
of units ID), optional units text (comma-delimited values of units ID).
First off, is this the best way of doing it? As each qualification lists
units drawn from data in the units table, is using a comma-delimited
list of unit IDs the best way of building that list, or are there
alternatives?
The main operation I need a hand with is deleting units from the units
table. Obviously, if I delete a unit I want it removed from all
qualifications that use it automatically. With that in mind, again, is a
comma-delimited list of unit IDs in qualifications records the best way,
and is there any easy way of updating all qualifications records at once
if I delete a unit record.
I'm using PHP and MySQL for this.
For now, help specifically with this would be appreciated as the client
has moved the deadline forward so I don't have much in-depth reading
time, however any resources that would help educate me in the wonderful
world of MySQL database design and SQL would be would be welcome.
I await your wisdom!
MOU
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.