Skip to main content

iRubric: Database-Systems rubric

find rubric

edit   print   share   Copy to my rubrics   Bookmark   test run   assess...   delete   Do more...
Database-Systems 
Access Database Project- Brandt
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: S989W3
By Youssefbrasil
Ready to use
Public Rubric
Subject: Business  
Type: Exam  
Grade Levels: Undergraduate

Powered by iRubric 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



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.

n178