Skip to main content
sign in
Username
Password
forgot?
Sign up
Share
help_outline
help
Pricing
Request Info
Please enable JavaScript on your web browser
menu
iRubric: Database-Modeling and Design Project rubric
find rubric
Your browser does not support iframes.
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
Your browser does not support iframes.
Desktop Mode
Mobile Mode
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
Subjects:
Business
Communication
Types:
Exam
Project
Discuss this rubric
You may also be interested in:
More rubrics by this author
More Business rubrics
More Exam rubrics
Do more with this rubric:
Preview
Preview this rubric.
Edit
Modify this rubric.
Copy
Make a copy of this rubric and begin editing the copy.
Print
Show a printable version of this rubric.
Categorize
Add this rubric to multiple categories.
Bookmark
Bookmark this rubric for future reference.
Assess
Test run
Test this rubric or perform an ad-hoc assessment.
Grade
Build a gradebook to assess students.
Collaborate
Apply this rubric to any object and invite others to assess.
Share
Publish
Link, embed, and showcase your rubrics on your website.
Email
Email this rubric to a friend.
Discuss
Discuss this rubric with other members.
Do more with rubrics than ever imagined possible.
Only with iRubric
tm
.
Copyright © 2024
Reazon Systems, Inc.
All rights reserved.
n98
Your browser does not support iframes.
Your browser does not support iframes.
Your browser does not support iframes.