Database Assignment
|
SQL Code/ tables/printout |
||||
|
Correct code |
Description |
|||
|
Correct answers · All attribute · Criteria · Correct syntax
|
· Most answers are correct · All attribute · Criteria · Correct syntax
|
· Most answers are correct · Some things overlooked · All attribute · Criteria · Correct syntax
|
· Most answers correct · Some things overlooked · Concepts understood · Some answers incorrect or missing
|
· Some problems · Incorrect answers · May have misunderstood the question
|
|
Excellent
|
Well done
|
Very good |
OK |
Need to review |
|
HD |
D |
C |
P |
F |
Some things to look out for
· Correct attributes given
· Correct use of Operators
· Linkages
· Capitals used for SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, AND, OR
· Tables
· Linkage
· Correct concept in undertaking the questions
· And more
· Correct output (indicated in your document)
Note Question 4
· The mark is based on whether the question is answered correctly.
· Complexity of the query e.g. a query that goes beyond the content will gain a high grade where as a single table query with no condition will gain less than a pass.
· Correct Syntax
· See also some things to look out for.