Computer Help and Spyware Removal Computer Help and Spyware Removal Computer Help and Spyware Removal Computer Help Forums Windows Startup Programs Database Spyware and Malware Removal Guides Computer Tutorials Uninstall Database File Database Computer Glossary Computer Resources
 

Welcome Guest ( Log In | Click here to Register a free account now! )



Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.
Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

 
Reply to this topicStart new topic
> Really Tough Database Design Question, Recursion and Many To Many Relationships
Underwhelmed
post Feb 18 2005, 01:46 AM
Post #1


Member
**

Group: Members
Posts: 58
Joined: 6-October 04
From: Chicago, IL
Member No.: 3,390
Okay, here's the problem ranting2.gif, I'm trying to build a course manager and one of the requirements is the ability for prerequisites. The problem I am having is that I cannot for the life of me figure out how to get the relationships correct when there can be a NAND & XOR relationship between multiple courses.

For example, I have 5 courses, MATH101, MATH201, MATH312, HIST412, CSCI320.
  • MATH101 has no prereq's
  • MATH201 has MATH101 as prereq
  • MATH312 has no prereq's
  • HIST412 has no prereq's
  • CSCI320 has (MATH201 AND MATH312) OR (HIST412) as prereq's
So how can I get the CSCI320 Course prereq's? killcomp.gif

How could this be stored in a database? There could be multiple courses within each AND along with multiple instances of the XOR. I'm pretty stumped as to how to store this.

Here's something that I found on it, but he didn't truely answer the question.

http://www.experts-exchange.com/Databases/Q_11195336.html

If anyone has any ideas, I would appreciate it.

Thanks


--------------------
Never go up against a Sicilian when death is on the line.

My Webpage - Needs help...
Go to the top of the page
 
+Quote Post
« Next Oldest · Programming · Next Newest »
 

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

Lo-Fi Version Time is now: 7th September 2008 - 06:48 PM


Advertise   |   About Us   |   Terms of Use   |   Privacy Policy   |   Contact Us   |   Site Map   |   Chat   |   Tutorials   |   Uninstall List
Discussion Forums   |   The Computer Glossary   |   Resources   |   RSS Feeds   |   Startups   |   The File Database   |   Malware Removal Guides

© 2003-2008 All Rights Reserved Bleeping Computer LLC.

Powered By IP.Board © 2008  IPS, Inc.