IT526 Unit 1

10/28/23, 11:35 AM Unit 1 Assignment Dropbox - IT526 SQL Query Design - Purdue University Global (6 ' PURDUE 4 GLOBAL IT526 Unit 1 Assighment Rubric Course: IT526 SQL Query Design Criteria 1 Criteria 1: SQL Server Installation Criteria 2 Criteria 2: Insert Questions Criteria 3 Criteria 3: Update Questions Criteria 4 Criteria 4: Delete Questions Criteria 5 Criteria 5: Create database questions Total Overall Score Level Il 102.01 points minimum Level Il Max Points 20 points e SQL Server successfully installed and sample databases successfully attached to SQL Server Level 11l Max Points 20 points e All SQL insert questions coded and correct result sets displayed Level Il Max Points 20 points e All SQL update questions coded and correct result sets displayed Level Il Max Points 20 points e All SQL delete questions coded and correct result sets displayed Level 11l Max Points 40 points Meets all criteria: ¢ Create new database e Create six new tables e Insert provided data e Create SQL queries Level Il Max Points 17 points e SQL Server successfully installed. e Sample databases not successfully attached. Level Il Max Points 17 points e Four SQL insert questions coded, and correct result sets displayed Level Il Max Points 17 points e Four SQL update questions coded, and correct result sets displayed Level || Max Points 17 points e Four SQL delete questions coded, and correct result sets displayed Level || Max Points 34 points Meets three criteria: e Create new database e Create six new tables e Insert provided data e Create SQL queries Level Il 84.01 points minimum Level | Max Points 14 points e SQL Server not successfully installed and sample databases not successfully attached Level | Max Points 14 points e Three SQL insert questions coded, and correct result sets displayed Level | Max Points 14 points e Three SQL update questions coded, and correct result sets displayed Level | Max Points 14 points e Three SQL delete questions coded, and correct result sets displayed Level | Max Points 28 points Meets two criteria: ¢ Create new database e Create six new tables e Insert provided data e Create SQL queries Level | 1 point minimum Not Present O points Does not meet any criteria. Not Present O points Does not meet any criteria. Not Present O points Does not meet any criteria. Not Present O points Does not meet any criteria. Not Present O points Does not meet any criteria. Criterion Score / 20 Criterion Score / 20 Criterion Score / 20 Criterion Score / 20 Criterion Score / 40 / 120 Not Present O points minimum https://purdueglobal.brightspace.com/d2l/Ims/dropbox/user/folder_submit_files.d21?db=1327440&grpid=0&isprv=0&bp=0&ou=248126 1/1