Information Technology Management (Business Intelligence)

2/19/2018 Sp18 ITM310 Master

https://blackboard.boisestate.edu/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_141743_1&course_id=_82950_1 1/2

ASGN-7 Relational Data Model for Transaction Processing (OLTP) Rubric Sp18

Rubric for grading ASGN-7 Relational Data Model for Transaction Processing (OLTP) Rubric Sp18

  Levels of Achievement

Criteria 5 points 4 points 3 points 2 points 1 point No Credit

Part A Question 1 - Entities and Attributes

5 Points

At least 5 entities properly identi�ed, each with 2 or more attributes (as appropriate). No major omissions or mis-classi�ed attributes. (+1 for 6)

4 Points

At least 4 entities properly identi�ed with 2 or more attributes as appropriate. Alternately, 5+ entities identi�ed, but one major omission or multiple mis- classi�ed attributes present.

3 Points

At least 3 entities properly identi�ed with 2 or more attributes as appropriate.

2 Points

At least 2 entities properly identi�ed with 2 or more attributes as appropriate.

1 Points

At least 1 entity properly identi�ed with 2 or more attributes as appropriate.

0 Points

No entities properly identi�ed with 2 or more attributes.

Part A Question 2 - Primary Keys

5 Points

At least 5 entities have an appropriately named Primary Key identi�ed with "PK" to the left of the attribute. (+1 for 6)

4 Points

At least 4 entities have an appropriately named Primary Key identi�ed with "PK" to the left of the attribute.

3 Points

At least 3 entities have an appropriately named Primary Key identi�ed with "PK" to the left of the attribute.

2 Points

At least 2 entities have an appropriately named Primary Key identi�ed with "PK" to the left of the attribute.

1 Points

At least 1 entity has an appropriately named Primary Key identi�ed with "PK" to the left of the attribute.

0 Points

No entities have an appropriately named Primary Key identi�ed with "PK" to the left of the attribute.

Part B Question 3 - Relationships and Cardinality

5 Points

At least 4 relationships have been identi�ed and all have the correct cardinality (+1 for 5)

4 Points

At least 4 relationships have been identi�ed but 1 does not have the correct cardinality

3 Points

3 relationships identi�ed with correct cardinality, OR 4+ relationships identi�ed, but 2 do not have the correct cardinality

2 Points

2 relationships identi�ed with correct cardinality, OR 4+ relationships identi�ed, but 3 or more do not have the correct cardinality OR 3 relationships identi�ed and 1 does not have the correct cardinality

1 Points

1 relationship identi�ed with correct cardinality, OR 3 relationships identi�ed and 2 or more do not have the correct cardinality

0 Points

Fewer than 3 relationships identi�ed, none with correct cardinality

Name

Description

Rubric Detail

2/19/2018 Sp18 ITM310 Master

https://blackboard.boisestate.edu/webapps/rubric/do/course/manageRubrics?dispatch=view&context=course&rubricId=_141743_1&course_id=_82950_1 2/2

  Levels of Achievement

Criteria 5 points 4 points 3 points 2 points 1 point No Credit

Part B Question 4 - Foreign Keys

5 Points

At least 4 Foreign Keys (FK) are identi�ed in entities with an "FK" to the left of their attribute, and these are the correct entities to form the relationships indicated in question 3. (+1 for 5)

4 Points

At least 4 Foreign Keys (FK) are identi�ed, but one of these is not in the correct entity to form the relationship indicated in question 3.

3 Points

3 Foreign Keys (FK) identi�ed in the correct entities OR 4+ FKs identi�ed, but 2 not in the correct entity

2 Points

2 Foreign Keys (FK) identi�ed in the correct entities OR 4+ FKs identi�ed, but 3 or more not in the correct entity OR 3 FKs identi�ed, and 1 not in the correct entity

1 Points

1 Foreign Key (FK) identi�ed in the correct entity, OR 3 FKs identi�ed and 2 or more not in the correct entity

0 Points

No Foreign Keys (FK) identi�ed OR fewer than 3 FKs identi�ed, none in the correct entity

Part B Question 5 - Additional Attributes

5 Points

All 5 additional amenities assigned a plausible attribute name and a correct entity (one in which the attribute is functionally dependent on the primary key for that entity) (+1 if entities updated with attributes for additional amenities)

4 Points

Four of the additional amenities assigned a plausible attribute name and a correct entity, but one of the amenities is missing an attribute name and/or not assigned to a correct entity

3 Points

Three of the additional amenities assigned a plausible attribute name and a correct entity, but two of the amenities are missing an attribute name and/or not assigned to a correct entity. OR All additional amenities assigned a plausible attribute name, but none assigned to a correct entity.

2 Points

Two of the additional amenities assigned a plausible attribute name and a correct entity, but three of the amenities are missing an attribute name and/or not assigned to a correct entity. OR Four additional amenities assigned a plausible attribute name, but none assigned a correct entity.

1 Points

One of the additional amenities assigned a plausible attribute name and a correct entity. OR three or fewer additional amenities assigned a plausible attribute name, but none assigned a correct entity.

0 Points

No additional amenities have been assigned a plausible attribute name or entity.

View Associated Items

Print Close Window