Akhenaton

1. Get the input data
2. Transform the data
3. Present the results

This is the rule u asked me to follow in creating my Db for averages. But the point is I've created the tables but it seems I created the wrong tables. How do I know which are the right tables?

DaWei

If you create tables that contain the data you need, how can they be the wrong tables? Admittedly, they might not be maximally effective. If they have the right data, you can get the job done. I just don't understand your question at all.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

Akhenaton

for my db, I created the following tables; students, teachers, admissions, classes, results, subjects. But a simple query such as SELECT * FROM STUDENTS does not work. I'm new to Programming even a child could resolve such a query.Que pasa?

Infinite Recursion

what errors are you getting?

__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."

DaWei

Lebenty-seven things can go wrong from a non-connection to bad query syntax. Whatever tools you're using, during the development phase have ALL errors and warnings appear, check ALL calls for the return value (or other status indication), and print out errors as part of the failure process. All the information you need to debug is generally available to you in these things and in the variables you are using. Debugging will always be a substantial part of your development; don't handicap your process by presuming in advance that everything will work.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers