Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aElien
Starting Member
2 Posts |
 Posted - 2007-12-05 : 15:36:22
|
Hello,Im working on my minor project for my Undergrad course.I have no earlier experience on working with SQL, im the biggest noob if there ever was one.For a part of my project i have to design a page using php and sql to query from a big student database selected details(Rank, Sex, Branch) and calculate the industrial placement chances and to construct a multiway decision search tree on SQL(im using WAMP server).This page is supposed to help new students joining the college decide an ideal branch based on past performances and placement record. A new student will enter his rank and relevant details and the from the decision tree an ideal branch(es) with high placement history will be suggested.My project assignment reads:"Now from the above prepared data constuct a decision search tree implement it a either using association rules or persistent Objects and store it in secondary storage as shown Further studies can be done to improve existing decision trees ... data mining bayesian classifier blah blah blah ... "What i have done till now is create a table in this format: But this hardly a tree. Rather i had flattened each path of the tree and made it into a table like:[node] -> [node] -> [node] -> [leaf] I have tried to read some text on how to do this, but its not making sence and most importantly im not sure what im reading is actually going to help me achieve my project goals. Right now stranded reading random articles. I have to do this within 5 days. I have asked people around here some professionals and teachers, noone seems to have done this before. A little help in direction would be greatly appreciated.RegardsAnurag |
|
|
gavakie
Posting Yak Master
221 Posts |
Posted - 2007-12-05 : 16:05:24
|
| What exactly are you trying to do SQL wise then? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-05 : 16:18:04
|
| And what is WAMP server?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-12-05 : 17:30:43
|
| Windows version of Linux, Apache, MySQL and Php installed on a server...commonly called LAMP in the *nix world. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-05 : 17:33:24
|
| aElien, you should post your question on a MySQL forum then as this site is for Microsoft SQL Server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Haywood
Posting Yak Master
221 Posts |
Posted - 2007-12-05 : 17:34:08
|
quote:
Originally posted by tkizer
aElien, you should post your question on a MySQL forum then as this site is for Microsoft SQL Server.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
If it's on windows, it might be an MSSQL instead of MySQL. The OP needs to clear up what the enviroment _really_ is.... |
|
|
|
aElien
Starting Member
2 Posts |
Posted - 2007-12-06 : 00:17:16
|
| Hi,Thanks for replyingYes for now, we are working on Windows. But finally it will be implemented on linux.Im sorry, i'll ask this in the relevant forum. Thanks.But the concept should be the same if i implement it on MSSQL or MySQL, right ?any help would be appreciatedThanks |
|
|
|
|
|
|
|
|
Help with project! Multiway decision tree on SQL