3/11/2021 DATA6002-2021-1 Data Management Systemshttps://learn.scu.edu.au/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_9963_1&course_id=_144976_1 1/6Rubric_Assignment_3 Levels of AchievementCriteriaExcellentGoodOKPoorFailDatabase –Creation2 PointsDatabasecreated,namedcorrectly, alltablescreated withattributes asperrequirements1.5 Points1-2 minorerrors oromissions butotherwise,databasecreated,namedcorrectly, alltables createdwith attributesas perrequirements1 Points1-2 major or5-6 minorerrors indatabasenaming,tables orattributes.0.5 PointsDatabasecreated butmany tablesand/orattributesmissing.0 PointsNodatabasecreated.Relationships2 PointsAllrelationshipscreated withreferentialintegrity setas per thedesign.1.5 Points1-2 minorerrors oromissions butotherwise, allrelationshipscreated withreferentialintegrity set asper the design.1 Points1-2 major or5-6 minorerrors inrelationshipsand/orreferentialintegrity.0.5 PointsAttemptmade atrelationshipsbut majorerrors madethemunusable.0 PointsNo keys setwithintables.NamingConventions1.5 PointsWell thoughtout andconsistentnamingconventionsused inoverall designwith a logical,selfdocumentingnature withno spaces orspecialcharacters.PK and FKnamedappropriately.1.125 PointsMinorinconsistenciesbut generallywell thoughtout andconsistentnamingconventionsused in overalldesign with alogical, selfdocumentingnature.0.75 PointsSomeevidence ofnamingconventionsbut noconsistency inoverall designor no selfdocumentingnature.0.375 PointsLittleevidence ofnamingconventionsused, poornaming suchas inclusionof spaces orspecialcharacters.0 PointsNoevidence ofany namingconventionsin use, poornamingsuch asinclusion ofspaces orspecialcharacters. NameDescriptionRubric DetailHelp3/11/2021 DATA6002-2021-1 Data Management Systemshttps://learn.scu.edu.au/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_9963_1&course_id=_144976_1 2/6 Levels of AchievementCriteriaExcellentGoodOKPoorFailData TypeSelection andUse in Keys2.5 PointsWell-chosen,appropriatedata typesused for allattributes,Õeld lengthsappropriateto content.1.875 Points1-2 minorerrors oromissions butotherwise,appropriatedata typesused for allattributes, Õeldlengthsappropriate tocontent.1.25 Points1-2 major or5-6 minorerrors in datatypes used orÕeld lengthsselected.0.625 PointsScriptcreated butincludesincorrectcodePoorselection ofmost datatypes and/ornoconsiderationgiven to Õeldlengths.0 PointsNoevidence ofany datatypes beingselected oruse of thesame datatypethroughout.Provision ofSample Data2.5 PointsRealistic, validdata providedto allow atleast 10 rowsin all queryresults.1.875 PointsValid dataprovided,some minorerrors or moredata needed.1.25 PointsSome sampledata providedbut errorsmean queryresults will beinadequate.0.625 PointsSome sampledata presentbut not validdata fortesting.0 PointsLess than 3lines ofsampledataprovided ineach table.Privileges2 PointsProvideaccess toyourdatabase forthe usereyuwono oranotherstudent useraccount ofyour choice.Details ofhow to dothis will beprovided inWeek 12.0 Points1 PointsAn attemptwas made butit wasunsuccessful.Indication,such as ascreendump,of how youattemptedthis can beadded to yourreport.0 Points0 PointsNoprivilegesgranted. Help3/11/2021 DATA6002-2021-1 Data Management Systemshttps://learn.scu.edu.au/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_9963_1&course_id=_144976_1 3/6 Levels of AchievementCriteriaExcellentGoodOKPoorFailUse of Views1.5 PointsAt least 4views createdwhichsupportreportingneeds. Gooduse ofaliasingwhereappropriate,addition ofcalculatedcolumnswherecommonlyused.1.125 PointsAt least 3 viewscreated whichsupportreportingneeds. Gooduse of aliasingwhereappropriate,addition ofcalculatedcolumnswherecommonlyused. 1-2minor errors.0.75 PointsAt least 2views created.1-2 major or5-6 minorerrors inaliasing,calculatedcolumns orpoor use ofviews.0.375 PointsAn attemptwas made onat least oneview buterrors orotherproblemsmade theview(s)unusable.0 PointsNo viewscreated.Export Script1.5 PointsScript Õlecreated andnamedcorrectly. Canbe used tocreatenew/restorethe database.1.125 PointsScript Õlecreated andnamedcorrectly. Canbe used tocreatenew/restorethe database.Tables only.0.75 PointsA script Õleswas createdbut 1-2 errorsin naming, orminorproblems inusing thescript.0.375 PointsAn attemptwas madebut errors orotherproblemsmade thescriptunusable torestore thedatabase.0 PointsNo scriptsupplied, orcodeprovided isnot SQL.Report –Proof ofTesting1.5 PointsWellpresentedusing reportlayout andappropriatetitle page.SQL Queriesfor eachQuestions H1to H8inserted intoreport,followed by ascreen dumpof yourresults.1.125 Points1-2 minorerrors oromissions butotherwise, wellpresentedusing reportlayout andappropriatetitle page. SQLQueries foreachQuestions E toH inserted intoreport,followed by ascreen dumpof your results.0.75 Points1-2 major or5-6 minorerrors oromissions.Reasonablypresentedwith titlepage. SQLQueries foreachQuestions Eto H insertedinto report,followed by ascreen dumpof yourresults.0.375 PointsA documentwas providedand somequeries andscreendumpsdisplayed butmostmissing.0 PointsNo proof oftestingprovided. Help3/11/2021 DATA6002-2021-1 Data Management Systemshttps://learn.scu.edu.au/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_9963_1&course_id=_144976_1 4/6 Levels of AchievementCriteriaExcellentGoodOKPoorFailSQL Query 10.5 PointsQuery wellstructuredand resultmatches therequirementsexactly. Nounnecessarytables orcolumnsadded.0.375 Points1-2 minorerrors oromissions butotherwise,query resultmatches therequirementsand nounnecessarytables orcolumnsadded.0.25 Points1-2 major or5-6 minorerrors inquery result,not matchingrequirements,unnecessarytables orcolumns orpoor SQLcommandstructure.0.125 PointsAn attemptwas madebut errors orotherproblemsmade thequeryunusable.0 PointsNo querysupplied, orcodeprovided isnot SQL.SQL Query 20.5 PointsQuery wellstructuredand resultmatches therequirementsexactly. Nounnecessarytables orcolumnsadded.0.375 Points1-2 minorerrors oromissions butotherwise,query resultmatches therequirementsand nounnecessarytables orcolumnsadded.0.25 Points1-2 major or5-6 minorerrors inquery result,not matchingrequirements,unnecessarytables orcolumns orpoor SQLcommandstructure.0.125 PointsAn attemptwas madebut errors orotherproblemsmade thequeryunusable.0 PointsNo querysupplied, orcodeprovided isnot SQL.SQL Query 30.5 PointsQuery wellstructuredand resultmatches therequirementsexactly. Nounnecessarytables orcolumnsadded.Membercountcorrectlycalculatedanddisplayed.0.375 Points1-2 minorerrors oromissions butotherwise,query resultmatches therequirementsand nounnecessarytables orcolumnsadded.Member countnot displayedor incorrect.0.25 Points1-2 major or5-6 minorerrors inquery result,not matchingrequirements,unnecessarytables orcolumns orpoor SQLcommandstructure.Membercount notdisplayed orincorrect.0.125 PointsAn attemptwas madebut errors orotherproblemsmade thequeryunusable.Membercount notdisplayed orincorrect.0 PointsNo querysupplied, orcodeprovided isnot SQL. Help3/11/2021 DATA6002-2021-1 Data Management Systemshttps://learn.scu.edu.au/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_9963_1&course_id=_144976_1 5/6 Levels of AchievementCriteriaExcellentGoodOKPoorFailSQL Query 40.5 PointsQuery wellstructuredand resultmatches therequirementsexactly. Nounnecessarytables orcolumnsadded. Mustbe sortedcorrectly0.375 Points1-2 minorerrors oromissions butotherwise,query resultmatches therequirementsand nounnecessarytables orcolumnsadded.0.25 Points1-2 major or5-6 minorerrors inquery result,not matchingrequirements,unnecessarytables orcolumns orpoor SQLcommandstructure.0.125 PointsAn attemptwas madebut errors orotherproblemsmade thequeryunusable.0 PointsNo querysupplied, orcodeprovided isnot SQL.SQL Query 51 PointsQuery wellstructuredand resultmatches therequirementsexactly. Nounnecessarytables orcolumnsadded.Correctcalculation0.75 Points1-2 minorerrors oromissions butotherwise,query resultmatches therequirementsand nounnecessarytables orcolumnsadded.0.5 Points1-2 major or5-6 minorerrors inquery result,not matchingrequirements,unnecessarytables orcolumns orpoor SQLcommandstructure.0.25 PointsAn attemptwas madebut errors orotherproblemsmade thequeryunusable.0 PointsNo querysupplied, orcodeprovided isnot SQL.SQL Query 61.5 PointsQuery wellstructuredand resultmatches therequirementsexactly. Nounnecessarytables orcolumnsadded.1.125 Points1-2 minorerrors oromissions butotherwise,query resultmatches therequirementsand nounnecessarytables orcolumnsadded.0.75 Points1-2 major or5-6 minorerrors inquery result,not matchingrequirements,unnecessarytables orcolumns orpoor SQLcommandstructure.0.325 PointsAn attemptwas madebut errors orotherproblemsmade thequeryunusable.0 PointsNo querysupplied, orcodeprovided isnot SQL. Help3/11/2021 DATA6002-2021-1 Data Management Systemshttps://learn.scu.edu.au/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_9963_1&course_id=_144976_1 6/6 Levels of AchievementCriteriaExcellentGoodOKPoorFailSQL Query 71.5 PointsQuery wellstructuredand resultmatches therequirementsexactly. Nounnecessarytables orcolumnsadded.Membernumbers areall countedcorrectly.1.125 Points1-2 minorerrors oromissions butotherwise,query resultmatches therequirementsand nounnecessarytables orcolumnsadded. Anattempt tocount themembernumbers butincorrect.0.75 Points1-2 major or5-6 minorerrors inquery result,not matchingrequirements,unnecessarytables orcolumns orpoor SQLcommandstructure. Anattempt tocount themembernumbers butincorrect.0.375 PointsAn attemptwas madebut errors orotherproblemsmade thequeryunusable.0 PointsNo querysupplied, orcodeprovided isnot SQL.SQL Query 82 PointsQuery wellstructuredand resultmatches therequirementsexactly. Nounnecessarytables orcolumnsadded.1.5 Points1-2 minorerrors oromissions butotherwise,query resultmatches therequirementsand nounnecessarytables orcolumnsadded.1 Points1-2 major or5-6 minorerrors inquery result,not matchingrequirements,unnecessarytables orcolumns orpoor SQLcommandstructure.0.5 PointsAn attemptwas madebut errors orotherproblemsmade thequeryunusable.0 PointsNo querysupplied, orcodeprovided isnot SQL. View AssociatedItemsPrint Close WindowHelp
