Final Exam Project
Rubric
Total: 100 points possible
Steps 5-7:
Steps
Criterion
Points
Possible
Points
Earned
1
Build a list of business needs, rules and assumptions
based upon the scenario and information provided.
10
2
For organizational purposes, create a data dictionary
table (refer to Table 3.6 in Chapter 3).
9
3
Create a relational diagram following the rules of
normalization from the contents of your data dictionary
table. Show your progression through each normal form
from 1st through 3rd, including an explanation of how you
have met each normal form.
16
4
Define the relationships between the entities, including
optionality and cardinality in the logical model. Use
Crow's Foot notation.
16
5
Determine indexes you will create for each table.
4
6
Write the DLL statements that you will use to create the
tables and indexes. Don't forget about the constraints
identified from your list of business rules.
18
7
Build the tables in the class DBMS.
9
8
Using DML commands, insert data into your tables.
9
9
Create two Views of your choice. Provide an explanation
of their purpose.
4
10
Write a short 1⁄2 to 1 page paper to explain how and why
you did everything.
5
