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-Systems rubric
find rubric
Your browser does not support iframes.
edit
print
share
Copy to my rubrics
Bookmark
test run
assess...
delete
Do more...
Database-Systems
Database-Systems
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:
AXW75BB
By
tarenburg
Ready to use
Public Rubric
Subject:
Business
Type:
Exam
Grade Levels:
Undergraduate
Your browser does not support iframes.
Desktop Mode
Mobile Mode
MId-Term-Database Systems
Outstanding
40 pts
Adequate
20 pts
Not Adequate
10 pts
Overall Crow's Foot Model
Outstanding
Logically designed the database design exhibiting a firm understanding of Crow's Foot notation
Completely and accurately explained design usage and purpose
Adequate
Exhibited a partial understanding of Crow's Foot database design and manipulation.
Some minor innaccuracy when explaining design usage and purpose
Not Adequate
Exhibited minimal understanding of Crows's Foot database design and manipulation
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
Completely populated tables with correct data elements reflecting the ERD design
Adequate
Populated tables with majority of data elements outlined in the ERD design
Not Adequate
Populated tables with minimal data elements defined in project the ERD design
Mechanics
Outstanding
Accurately entered data elements into tables with no keypunch errors
No spelling or grammar errors in database documentation
Adequate
Entered data elements into tables with minimal keypunch errors
Some minor spelling or grammar errors evident in documentation
Not Adequate
Multiple keypunch errors when entering data elements into tables
Numerous errors.
Reports
Outstanding
Created all of the reports needed for the as defined in project requirements
Report name is indicitive of data it will return
Adequate
Created some of the reports needed for the company as defined in project requirements
Report name partially correlates to the data it will return
Not Adequate
Created minimal reports needed for the company as defined in project requirements. Report names does not indicate what data will be returned
Keywords:
Crow's Foot design, Database Systems
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.