IT503 Assessment 3 Rubric
All competency criteria must be met to earn a B grade and pass this Course Outcome.
A predefined number of mastery criteria must be met to earn an A grade, indicating mastery of the Course Outcome. See the CLA and Grade Criteria Chart below.
*If work submitted for this Competency Assessment does not meet the minimum submission requirements, it will be returned without being scored.
MET
NOT YET MET
Section 1 – Entity Tables
Competency
Create an entity table using one of the specific options
Present the data in a Word table
Include at least eight attributes
Identify a logical primary key
Classify each attribute by an appropriate SQL data type
Include lengths for each attribute
Include whether each attribute is required
Use consistent case
Mastery
Identify logical characteristics of an entity
Visually organize a variety of related data
Use critical thinking to apply suitable data length limits
Use critical thinking to choose suitable data types for attributes
‘Section 2 – ERDs
Competency
Describe the “relational” database concept
Identify all five primary keys in the given diagram
Identify all five foreign keys in the given diagram and in which entities each is placed
Explain the crow’s foot between Refrigerator and Manufacturer
Explain the crow’s foot between Manufacturer and Ordering
Explain the crow’s foot between Manufacturer and Service
Explain the crow’s foot between Service and Billing
Explain the crow’s foot between Ordering and Billing
Identify the case as Pascal
Mastery
Explain reasons for database relationships
Interpret database organization through competent reading of an ERD
Use critical thinking to locate relationships between entities through foreign keys and cardinalities
Section 3 – Normalization
Competency
Describe the underlying reasons for normalization
Explain NF1 (first normal form)
Explain NF2 (second normal form)
Explain NF3 (third normal form)
Explain BCNF (Boyce Codd normal form)
Provide examples to illustrate the concept, from the student’s own understanding
Mastery
Explain the importance of database normalization
Present normalization concepts in an organized manner, using professional language
Use critical thinking to present appropriate examples of normalization concepts
Section 4 – SQL and Database Attacks
Competency
Describe In-band SQL injection attacks
Describe Inferential SQL injection attacks
Describe Out-of-band SQL injection attacks
Provide reasons for hackers to use SQLi attacks
Mastery
Explain how and why SQL injection attacks create problems
Present SQLi concepts in an organized manner, using professional language
Total Competency Criteria:
Total Mastery Criteria:
CLA and Grade Criteria Chart
CRITERIA
CLA Score
Grade
Points
Meets all competency criteria and 50%-100% of mastery criteria
5
A
250
Meets all competency criteria and 0%-49% of mastery criteria
4
B
212.5
Meets 75%-99% of competency criteria
3
Not Yet Competent*
0
Meets 50%-75% of competency criteria
2
Not Yet Competent*
0
Meets 1%-49% of competency criteria
1
Not Yet Competent*
0
Meets 0 competency criteria
0
Not Yet Competent*
0
No submission
NA
Not Yet Competent*
0
*Not Yet Competent grades convert to an F at term end
