search

rubenvanassche / Programming-Project-Databases

A World championship statistics website
coachcenter.be
GNU General Public License v3.0
1 stars 1 forks source link

Revise all SQL queries #69

Closed JakobStruye closed 10 years ago

JakobStruye commented 10 years ago

As this is a databases project, we should carefully revise our queries right before finalizing the project. They have to be logical (no unnecessarily long nested queries) and efficient. We have to provide a list of all our queries, so it's safe to assume this will have an influence on the final grade.

STOWouters commented 10 years ago

:+1: and perhaps add some constraints (without messing up the database)? At the moment we don't have any single constraint query.

JakobStruye commented 10 years ago

Ah yes, we used to have those, but had to comment them out due to (at the time) incomplete data. We should definitely add as many as possible, indeed.

JakobStruye commented 10 years ago

Second to last issue closed!