Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Furquan Ahmad
5,148 PointsPHP SQL GRAPHS
Hi for my A Level Computing Coursework i have to use a database and create new data. I am creating a web based program that should be supported for mobile using HTML PHP and SQL. Is this a good idea ? The program has to predict what grades a student would end up with by looking at past student's progress, which i will put in a database. Also the program will create a graph of the projected performance. It will also predict attendance, how many homeworks missed. How shall i conduct this and how will i do the graphs ? It needs to use classes as well. I've just started on the PHP course on treehouse. Have until christmas to do this. Spending about 2 hours every day doing the project.
1 Answer
thomascawthorn
22,986 PointsIt sounds like you need a sweet as database structure combined with an algorithm for comparison.
You'll probably want something like a students table with student details like age, gender, attendance percentage etc..
maybe a results table containing grade, subject, level, etc, and include the student_id to attach each row to a student because it's a one to many relationship.
You might need a predictions table if you're saving the results.
But definitely get involved more with the database stuff first because it's far more important to have a good data structure.