Skip to main content
iRubric: Database-Modeling and Design Project rubric

iRubric: Database-Modeling and Design Project rubric

find rubric

edit   print   share   Copy to my rubrics   Bookmark   test run   assess...   delete   Do more...
Database-Modeling and Design Project 
Database-Modeling and Design Project
Using Business rules, and Crow's Foot notation design and implement a database. This includes creating the ERD design using MS Visio or MySQl Workbench. Implement the design creating an MS ACCESS database tables and reports.
Rubric Code: C22A397
By rolopaula
Ready to use
Public Rubric
Subject: Business  
Type: Exam  
Grade Levels: Undergraduate, Graduate

Powered by iRubric Database Design and Implementation Project
  Outstanding

40 pts

Adequate

20 pts

Not Adequate

10 pts

Overall ER Model

Outstanding

Logically designed the database design exhibiting a firm understanding of ERD notation
Completely and accurately explained design usage and purpose
Adequate

Exhibited a partial understanding of database design using ERD
Some minor innaccuracy when explaining design usage and purpose
Not Adequate

Exhibited minimal understanding of database design using ERD
Inaccurate design explanation in regard to design usage and purpose
Table Creation

Outstanding

Created all of the tables defined in project requirements
Named tables appropriately in regard to their data elements
Adequate

Created most of the tables defined in project requirements
Table name was a little unclear in regard to its data elements
Not Adequate

Partially created some of the tables defined in project requirements
Table name did not correlate to its data elements
Relations and Cardinalities

Outstanding

Correctly interpreted all the Business Rules and created all necessary relations with clear indication to the cardinalities and observing the three normalizations forms.
Adequate

Correctly Interpreted most Business Rules and created most of the necessary relations with some indication to cardinalities and observing at least two normal forms.
Not Adequate

Incorrectly Interpreted the Business Rules, few relations were created and few indications to Cardinalities and Normal forms
Keys and Entities

Outstanding

Correctly choose all primary and foreign keys respecting the naming convention
Adequate

Correctly choose most of the primary and foreign keys respecting the naming convention
Not Adequate

Incorrectly choose most of the primary and foreign Keys, and somehow respected the naming convention
Implementation

Outstanding

Created all tables properly using correct DDL SQL statements
Completely populated tables with correct data elements reflecting the ERD design.
Adequate

Created most of the tables properly using correct DDL SQL statements.
Populated tables with majority of data elements outlined in the ERD design
Not Adequate

Created tables properly using DDL SQL statements with significant errors.
Populated tables with minimal data elements defined in project the ERD design
Queries and Views

Outstanding

Created relevant queries properly and stored them as views
Adequate

Relevant queries partially correct and and stored as views
Not Adequate

Queries incorrect/ Views missing
Procedures and Triggers

Outstanding

A chosen trigger/stored procedure correctly enforces clearly specified relevant business rule
Adequate

A chosen trigger/stored procedure partially enforces business rule
Not Adequate

Trigger/stored procedure missing completely



Keywords:
  • ERD, Database Design, SQL



Discuss this rubric




Do more with this rubric:
Preview

Preview

Preview this rubric.
Edit

Edit

Modify this rubric.
Copy

Copy

Make a copy of this rubric and begin editing the copy.

Print

Print

Show a printable version of this rubric.
Categorize

Categorize

Add this rubric to multiple categories.
Bookmark

Bookmark

Bookmark this rubric for future reference.
Assess
Test run

Test run

Test this rubric or perform an ad-hoc assessment.
Grade

Grade

Build a gradebook to assess students.
Collaborate

Collaborate

Apply this rubric to any object and invite others to assess.
Share
Publish

Publish

Link, embed, and showcase your rubrics on your website.
Email

Email

Email this rubric to a friend.
Discuss

Discuss

Discuss this rubric with other members.
 

Do more with rubrics than ever imagined possible.

Only with iRubrictm.


Copyright © 2024 Reazon Systems, Inc.  All rights reserved.
n98