Quoting Ross Clutterbuck <[EMAIL PROTECTED]>: > Hi List - been a while.
Indeed, I was wondering where "MoU" had got too... :oP > > 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). OK, here's my stab at it: "modules" module id - unique & primary key - probably auto_increment module title module description "courses" course id - unique & primary key - probably auto_increment course title course level course description "course_modules" course id module id is_compulsory (boolean) That means that the relationships between courses and modules can be very quickly searched on and also that a module that is compulsory for one course is not compulsory for all courses. It also does away with the requirement for a CSV list and means that you can run much more powerful (and therefore more effective) queries over your data. HTH, M. P.S. If it does help, you owe me 3 virtual beers... :o) -- Matthew Macdonald-Wallace [EMAIL PROTECTED] http://www.truthisfreedom.org.uk/ ____ � 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.
