Please see attached for CMS Project
tatoo1
cms_project_phase_i_grading_rubric.docxBMIS 325
CMS Project – Phase I Grading Rubric
Note: Screenshots are required for each SQL, DML, and DCL statement for a grade to be given. One screenshot is not the idea; however, multiple screenshots along the way is the goal.
|
Criteria |
Points Possible |
Points Earned |
|
Part A – ER Diagram |
0 to 50 points · Includes correct entities · Includes correct relationships · Accompanying notes · Design needs 3NF |
|
|
Part B – ER Diagram |
0 to 50 points · Includes correct entities · Includes correct relationships |
|
|
SQL CREATE TABLE statements |
0 to 50 points · Statement created for each entity in ERD · Primary keys defined · Foreign keys defined · Referential integrity enforced · Table definitions with “sp_help” |
|
|
Total |
|
Instructor’s Comments:
