HW1_Solution_Fall_2009_CSE 412

HW1_Solution_Fall_2009_CSE 412 - Solution & Grading...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Total point is 100 for HW1 20 for correctness of query results, 5 for the query run, 20*5 for the query specification (correct logic) Query Results Q1 (25 pt) Q2 (25 pt) Q3 (25 pt) Q4 (25 pt) Results of queries submitted are correct? S 1 pt for each queryS The query runs correct for the secret test DB? S 4 pt for each queryS query specification and correct logic (20pt for each query) Total score Comments QUERY SPECIFICATIONS (The Query Results for test database of HW1 refer to document “Appendix: Query Results for HW1”) YES NO EXPECTED/REQUIRED FEATURES The name appears as a comment line at the beginning of the query file? Hardcopy of queries and results submitted for assessment? Queries handed in are readable (not truncated)? All queries and variables have descriptive names? Queries are at least documented with the query statement and output schema? Tables representing identified query results are clearly indicated? Query results submitted for assessment were run against the published test data?
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
1 20 For each group in database, find the number of CDs rated in the top 3.Order the results in descending order of the number of top 3 CDs comments 3 a)Find the number of CDs rated in the top 3 for each group which(group) have produced the top 3 rating CDs 3 b)Find the groups that have no top 3 rating CDs 3 Union a) and b) to get the count of top 3 rating CDs for each
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

HW1_Solution_Fall_2009_CSE 412 - Solution & Grading...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online