0% found this document useful (0 votes)
21 views

Database Rubric Class Project

This rubric outlines the criteria for assessing a database project in 7 phases: 1. Entities - Identifying events, agents, and resources correctly. 2. Relationships - Specifying cardinalities and relationships accurately. 3. Table Design - Defining appropriate attributes, primary keys, and foreign keys. 4. MS Access - Populating tables with correct data types and defining keys properly. 5. Queries - Writing conditional and functional queries with little assistance. 6. Forms - Designing forms well. 7. Reports - Designing reports well. The rubric scores each criteria as outstanding, acceptable, or unacceptable for a total possible score of

Uploaded by

Bellatiny
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
21 views

Database Rubric Class Project

This rubric outlines the criteria for assessing a database project in 7 phases: 1. Entities - Identifying events, agents, and resources correctly. 2. Relationships - Specifying cardinalities and relationships accurately. 3. Table Design - Defining appropriate attributes, primary keys, and foreign keys. 4. MS Access - Populating tables with correct data types and defining keys properly. 5. Queries - Writing conditional and functional queries with little assistance. 6. Forms - Designing forms well. 7. Reports - Designing reports well. The rubric scores each criteria as outstanding, acceptable, or unacceptable for a total possible score of

Uploaded by

Bellatiny
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

PXB 20303 - Database Project Rubric

Outstanding (4-5) Acceptable (2-3)


Phase: Trait Unacceptable (0-1) Score

1: Entities Identify Events Identifies all events Identifies most events correctly; few Most events missing or 5
correctly missing; few incorrectly identified incorrectly identified

Identify Agents Identifies all agents Identifies most agents correctly; few missing; Most agents missing or 5
correctly few incorrectly identified incorrectly identified

Identify Resources Identifies all resources Identifies most resources correctly; few Most resources missing or 5
correctly missing; few incorrectly identified
incorrectly identified

2: Cardinalities All cardinalities correctly Most cardinalities correctly specified Majority of cardinalities
Relationships specified missing or incorrectly 5
specified
3: Table Design Attributes All table attributes Most table attributes correctly specified Majority of table attributes
correctly specified in correctly specified
5

Primary Keys Appropriate primary key Less than ideal primary key defined Inappropriate or no
defined primary key defined 5

Foreign Keys All appropriate Foreign Most foreign keys correctly specified Majority of foreign keys
key(s) correctly specified omitted or incorrectly
specified 5

4: MS Access Tables All tables specified and Most tables specified and populated with Majority of tables 5
populated with appropriate data types unpopulated or with
appropriate data types incorrect data types

Primary Keys Primary key properly Primary key not properly defined No primary key defined
defined 5

Foreign Keys All relationships defined A few missing relationships Few or no relationships
defined 5
5: Queries Conditional Queries (If- All conditional queries Conditional queries written with significant Conditional queries not
then..) written with little or no assistance written or incorrectly
assistance specified
5

Queries that require All functional queries Functional queries written with significant Functional queries not 5
writing a function written with little or no assistance written or incorrectly
(Functional queries) assistance specified

6: Forms Design Well Design Acceptable Design Poorly Design 5

7: Reports Design Design Well Design Acceptable Design Poorly Design 5

Total points: 70
Mark to 20% 20

You might also like