Chat with us, powered by LiveChat

Describe the underlying reasons for normalization.

Words: 472
Pages: 2
Subject: Uncategorized

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