Data Definition Language (DDL) SQL Script
grenjo
DBST651_Project_Part3_Evaluation_Guideline.docDBST651 Project Part 3 Evaluation Guideline
|
Evaluation Criteria |
Description |
Weight |
Score |
Feedback |
|
Format |
Submit one executable plain text file, and one output file. |
10 |
|
|
|
Comment |
Describe the business purpose of your views and triggers. |
5 |
|
|
|
Drop |
Drop existing tables and sequences first. |
5 |
|
|
|
Tables |
Create at least 5 tables. DDL statements run without error. |
15 |
|
|
|
Keys |
Primary keys, foreign keys, and unique keys specified. |
10 |
|
|
|
Indexes |
Indexes created on unique key, foreign key, and filter columns. |
10 |
|
|
|
Sequences
|
At least two sequences (ideally one for each PK column). |
5 |
|
|
|
Views |
At least two views (with good business value). |
15 |
|
|
|
Triggers |
At least two triggers (with good business value). |
15 |
|
|
|
Catalog |
Check data dictionary to make sure all objects are valid. |
10 |
|
|
|
Total |
|
100 |
|
|
