3/11/2021 DATA6002-2021-1 Data Management Systems
https://learn.scu.edu.au/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_9963_1&course_id=_144976_1 1/6
Rubric_Assignment_3
| Levels of Achievement | |||||
| Criteria | Excellent | Good | OK | Poor | Fail |
| Database – Creation |
2 Points Database created, named correctly, all tables created with attributes as per requirements |
1.5 Points 1-2 minor errors or omissions but otherwise, database created, named correctly, all tables created with attributes as per requirements |
1 Points 1-2 major or 5-6 minor errors in database naming, tables or attributes. |
0.5 Points Database created but many tables and/or attributes missing. |
0 Points No database created. |
| Relationships | 2 Points All relationships created with referential integrity set as per the design. |
1.5 Points 1-2 minor errors or omissions but otherwise, all relationships created with referential integrity set as per the design. |
1 Points 1-2 major or 5-6 minor errors in relationships and/or referential integrity. |
0.5 Points Attempt made at relationships but major errors made them unusable. |
0 Points No keys set within tables. |
| Naming Conventions |
1.5 Points Well thought out and consistent naming conventions used in overall design with a logical, self documenting nature with no spaces or special characters. PK and FK named appropriately. |
1.125 Points Minor inconsistencies but generally well thought out and consistent naming conventions used in overall design with a logical, self documenting nature. |
0.75 Points Some evidence of naming conventions but no consistency in overall design or no self documenting nature. |
0.375 Points Little evidence of naming conventions used, poor naming such as inclusion of spaces or special characters. |
0 Points No evidence of any naming conventions in use, poor naming such as inclusion of spaces or special characters. |
Name
Description
Rubric Detail
Help
3/11/2021 DATA6002-2021-1 Data Management Systems
https://learn.scu.edu.au/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_9963_1&course_id=_144976_1 2/6
| Levels of Achievement | |||||
| Criteria | Excellent | Good | OK | Poor | Fail |
| Data Type Selection and Use in Keys |
2.5 Points Well-chosen, appropriate data types used for all attributes, Õeld lengths appropriate to content. |
1.875 Points 1-2 minor errors or omissions but otherwise, appropriate data types used for all attributes, Õeld lengths appropriate to content. |
1.25 Points 1-2 major or 5-6 minor errors in data types used or Õeld lengths selected. |
0.625 Points Script created but includes incorrect codePoor selection of most data types and/or no consideration given to Õeld lengths. |
0 Points No evidence of any data types being selected or use of the same data type throughout. |
| Provision of Sample Data |
2.5 Points Realistic, valid data provided to allow at least 10 rows in all query results. |
1.875 Points Valid data provided, some minor errors or more data needed. |
1.25 Points Some sample data provided but errors mean query results will be inadequate. |
0.625 Points Some sample data present but not valid data for testing. |
0 Points Less than 3 lines of sample data provided in each table. |
| Privileges | 2 Points Provide access to your database for the user eyuwono or another student user account of your choice. Details of how to do this will be provided in Week 12. |
0 Points | 1 Points An attempt was made but it was unsuccessful. Indication, such as a screendump, of how you attempted this can be added to your report. |
0 Points | 0 Points No privileges granted. |
Help
3/11/2021 DATA6002-2021-1 Data Management Systems
https://learn.scu.edu.au/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_9963_1&course_id=_144976_1 3/6
| Levels of Achievement | |||||
| Criteria | Excellent | Good | OK | Poor | Fail |
| Use of Views | 1.5 Points At least 4 views created which support reporting needs. Good use of aliasing where appropriate, addition of calculated columns where commonly used. |
1.125 Points At least 3 views created which support reporting needs. Good use of aliasing where appropriate, addition of calculated columns where commonly used. 1-2 minor errors. |
0.75 Points At least 2 views created. 1-2 major or 5-6 minor errors in aliasing, calculated columns or poor use of views. |
0.375 Points An attempt was made on at least one view but errors or other problems made the view(s) unusable. |
0 Points No views created. |
| Export Script | 1.5 Points Script Õle created and named correctly. Can be used to create new/restore the database. |
1.125 Points Script Õle created and named correctly. Can be used to create new/restore the database. Tables only. |
0.75 Points A script Õles was created but 1-2 errors in naming, or minor problems in using the script. |
0.375 Points An attempt was made but errors or other problems made the script unusable to restore the database. |
0 Points No script supplied, or code provided is not SQL. |
| Report – Proof of Testing |
1.5 Points Well presented using report layout and appropriate title page. SQL Queries for each Questions H1 to H8 inserted into report, followed by a screen dump of your results. |
1.125 Points 1-2 minor errors or omissions but otherwise, well presented using report layout and appropriate title page. SQL Queries for each Questions E to H inserted into report, followed by a screen dump of your results. |
0.75 Points 1-2 major or 5-6 minor errors or omissions. Reasonably presented with title page. SQL Queries for each Questions E to H inserted into report, followed by a screen dump of your results. |
0.375 Points A document was provided and some queries and screen dumps displayed but most missing. |
0 Points No proof of testing provided. |
Help
3/11/2021 DATA6002-2021-1 Data Management Systems
https://learn.scu.edu.au/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_9963_1&course_id=_144976_1 4/6
| Levels of Achievement | |||||
| Criteria | Excellent | Good | OK | Poor | Fail |
| SQL Query 1 | 0.5 Points Query well structured and result matches the requirements exactly. No unnecessary tables or columns added. |
0.375 Points 1-2 minor errors or omissions but otherwise, query result matches the requirements and no unnecessary tables or columns added. |
0.25 Points 1-2 major or 5-6 minor errors in query result, not matching requirements, unnecessary tables or columns or poor SQL command structure. |
0.125 Points An attempt was made but errors or other problems made the query unusable. |
0 Points No query supplied, or code provided is not SQL. |
| SQL Query 2 | 0.5 Points Query well structured and result matches the requirements exactly. No unnecessary tables or columns added. |
0.375 Points 1-2 minor errors or omissions but otherwise, query result matches the requirements and no unnecessary tables or columns added. |
0.25 Points 1-2 major or 5-6 minor errors in query result, not matching requirements, unnecessary tables or columns or poor SQL command structure. |
0.125 Points An attempt was made but errors or other problems made the query unusable. |
0 Points No query supplied, or code provided is not SQL. |
| SQL Query 3 | 0.5 Points Query well structured and result matches the requirements exactly. No unnecessary tables or columns added. Member count correctly calculated and displayed. |
0.375 Points 1-2 minor errors or omissions but otherwise, query result matches the requirements and no unnecessary tables or columns added. Member count not displayed or incorrect. |
0.25 Points 1-2 major or 5-6 minor errors in query result, not matching requirements, unnecessary tables or columns or poor SQL command structure. Member count not displayed or incorrect. |
0.125 Points An attempt was made but errors or other problems made the query unusable. Member count not displayed or incorrect. |
0 Points No query supplied, or code provided is not SQL. |
Help
3/11/2021 DATA6002-2021-1 Data Management Systems
https://learn.scu.edu.au/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_9963_1&course_id=_144976_1 5/6
| Levels of Achievement | |||||
| Criteria | Excellent | Good | OK | Poor | Fail |
| SQL Query 4 | 0.5 Points Query well structured and result matches the requirements exactly. No unnecessary tables or columns added. Must be sorted correctly |
0.375 Points 1-2 minor errors or omissions but otherwise, query result matches the requirements and no unnecessary tables or columns added. |
0.25 Points 1-2 major or 5-6 minor errors in query result, not matching requirements, unnecessary tables or columns or poor SQL command structure. |
0.125 Points An attempt was made but errors or other problems made the query unusable. |
0 Points No query supplied, or code provided is not SQL. |
| SQL Query 5 | 1 Points Query well structured and result matches the requirements exactly. No unnecessary tables or columns added. Correct calculation |
0.75 Points 1-2 minor errors or omissions but otherwise, query result matches the requirements and no unnecessary tables or columns added. |
0.5 Points 1-2 major or 5-6 minor errors in query result, not matching requirements, unnecessary tables or columns or poor SQL command structure. |
0.25 Points An attempt was made but errors or other problems made the query unusable. |
0 Points No query supplied, or code provided is not SQL. |
| SQL Query 6 | 1.5 Points Query well structured and result matches the requirements exactly. No unnecessary tables or columns added. |
1.125 Points 1-2 minor errors or omissions but otherwise, query result matches the requirements and no unnecessary tables or columns added. |
0.75 Points 1-2 major or 5-6 minor errors in query result, not matching requirements, unnecessary tables or columns or poor SQL command structure. |
0.325 Points An attempt was made but errors or other problems made the query unusable. |
0 Points No query supplied, or code provided is not SQL. |
Help
3/11/2021 DATA6002-2021-1 Data Management Systems
https://learn.scu.edu.au/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_9963_1&course_id=_144976_1 6/6
| Levels of Achievement | |||||
| Criteria | Excellent | Good | OK | Poor | Fail |
| SQL Query 7 | 1.5 Points Query well structured and result matches the requirements exactly. No unnecessary tables or columns added. Member numbers are all counted correctly. |
1.125 Points 1-2 minor errors or omissions but otherwise, query result matches the requirements and no unnecessary tables or columns added. An attempt to count the member numbers but incorrect. |
0.75 Points 1-2 major or 5-6 minor errors in query result, not matching requirements, unnecessary tables or columns or poor SQL command structure. An attempt to count the member numbers but incorrect. |
0.375 Points An attempt was made but errors or other problems made the query unusable. |
0 Points No query supplied, or code provided is not SQL. |
| SQL Query 8 | 2 Points Query well structured and result matches the requirements exactly. No unnecessary tables or columns added. |
1.5 Points 1-2 minor errors or omissions but otherwise, query result matches the requirements and no unnecessary tables or columns added. |
1 Points 1-2 major or 5-6 minor errors in query result, not matching requirements, unnecessary tables or columns or poor SQL command structure. |
0.5 Points An attempt was made but errors or other problems made the query unusable. |
0 Points No query supplied, or code provided is not SQL. |
View Associated
Items
Print Close Window
Help
