Project requirements the oracle database engine
Advanced Relational Database
Programming Project
A trigger should be used to generate invoices once a customer reaches $200 in shipping costs.
An instead-of trigger should be employed to update and/or populate multi-table views.
Deliverables:
All sql scripts and run scripts and instructions for successfully building your database and testing your database.
The test data and results you used for your database,
Your approach, lessons learned, design strengths, limitations and suggestions for future improvement and alternative approaches, the most challenging aspects of developing this application.
Code format:
Header comment block,
Grading Rubric:
| Attribute | Unacceptable | Acceptable | Distinguished | Points |
|---|---|---|---|---|
| Program Design | - Database is not normalized | - Database is in 1st or 2nd normal form | - Database is in 3rd normal form | |
| Functionality | - Few requirements were fulfilled | - Meets some requirements | - Meets most requirements | |
Test Data |
- Little or no test data suite included | - Some test data and results included but some vital functionality not tested | - Comprehensive test data suite included with results | |
- Does not consider alternatives - Rarely identifies strengths and weaknesses of the experimental design and of the data |
- Considers alternatives and shows how and why they should/should not be accepted - Identifies strengths and weaknesses of the experimental design and of the data |
|||
-Sentence structure (run-ons, fragments) needs improvement and impedes readability -Numerous spelling errors |
-Sentence structure and diction are effective and clear - No obvious spelling errors |
