ICT200Assessment 4 Marking Rubric: SQL Server Database Project Criteria Fail (0-49%) Pass (50-64%) Credit (65-74%) Distinction (75-84%) High Distinction(85-100%) ER Diagram 5 marks ER diagram not correct or not submitted Identified all entities and built relationships using crow’s foot notationData is in 3NF Identified entities and relationships, representation using crow’s foot notation correctData is in BCNF ERD accompanied with explanation of relationshipsData is in BCNF Demonstrated all the normalization from 1 NF to BCNF along with diagram and table data DDL, DML and PSM scripts 10 marks Scripts are incorrect or not submitted DDL and DML Scripts are correctTables are created, data is inserted, updated, deleted DDL and DML Scripts are correctTables are created, data is inserted, updated, deletedTables have default values and constraints are enabled on tables DDL and DML Scripts are correctTables are created, data is inserted, updated, deleted Tables have default values and constraints are enabled on tables Functions and Triggers are written to perform tasks mentioned in case study DDL and DML Scripts are correctTables are created, data is inserted, updated, deleted Tables have default values and constraints are enabled on tablesFunctions, Triggers and Stored Procedures are written to perform tasks mentioned in case study Report and Presentation 10 marks Report is not adhering to guidelines provided, tasks are not done satisfactorilyTeam member(s) have not shown convincing evidence of having performed the tasks outlined the case study Report is submitted, meeting word count and presentation is delivered.There is sufficient evidence of participation of team member(s)Database, tables and other objects are created on SQL Server Report is submitted, meeting word count, well referenced and presentation is delivered. There is sufficient evidence of participation of team member(s) Database, tables and other objects are created on SQL ServerStudents must be able to provide an explanation of the scripts they’ve written. The report is submitted, meeting word count, well-referenced and presentation is delivered.There is sufficient evidence of participation of team member(s)Students must be able to provide an explanation of the scripts they’ve written. Students are able to demonstrate the tasks outlined in the case study. The report is well-written and presented professionally, containing:o Title pages Table of Contents o Introduction Appropriate use of headings within report o Overall structure, presentation, and formatting.All tasks outlined in the case study are carried out and the group has shown evidence of having done the task on their own.