Category |
Unacceptable (0-1) |
Needs Improvement (2-3) |
Good (4) |
Excellent (5) |
Total Possible Points |
---|
Create the database tables |
All tables are not created correctly |
2 or more tables are not created correctly |
Correct created tables, queries are not optimal |
Correct queries and correct resulted tables |
5 |
Define the primary keys of the tables |
All primary keys are not created correctly |
2 or more primary keys are not created correctly |
NA |
All primary keys are created correctly |
5 |
Create the relationships among the tables using foreign keys |
All relationships are not created correctly |
2 or more relationships are not created correctly |
NA |
All relationships are created correctly |
5 |
Populate the tables with data |
Tables are not populated by the given data |
All tables are populated by part of the given data |
Some tables are populated by part of the given data |
All tables are correctly populated with the given data |
5 |
Query 1 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 2 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 3 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 4 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 5 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 6 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 7 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 8 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 9 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 10 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 11 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 12 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 13 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Query 14 |
Query does not exist |
Query is close to correct, results are not correct |
Correct results, query is not optimal |
Correct query and correct results. Notes written to explain query. |
5 |
Create the required indexes |
No indexes chosen |
Indexes are poorly chosen, queries are not correct |
Indexes are poorly chosen, queries are correct |
Indexes are correctly chosen, queries are correctly written |
5 |
Create required view |
No view created |
The syntax of the view creation is not correct |
The view is correctly created but not correctly used |
The view is correctly created and used |
5 |
Total |
|
|
|
|
100 |