Final Project
- Due May 1, 2016 by 11:59pm
- Points 100
- Submitting a file upload
Final Project - Database Design
Use the Database Design Template (DDD) to document your Comic Book Database. Also
provide a backup copy of your database.
Verify that your Comic Book Database has (4-6) tables in 3rd Normalization. Create Primary Keys, Foreign Keys and Constraints.
Create (2-4) usable views, and detail the need for these views in the
overall design approach.
Create at least (2) user accounts with varying functions, and provide logon creditentials. Create
DML scripts to test user accounts.
Create at least (1) Trigger, Function or Stored Procedure and provide
detailed information in design approach. Provide DML scripts to test
functionality.
Create Entity Design Diagram.
Create Maintenance Plan.
Rubric
Find Rubric
Please include a title
Keep in mind that 8 students have already been assessed using this rubric. Changing it will affect their evaluations.
| Criteria | Ratings | Pts |
|---|---|---|
|
Normalized Comic Book Relational Databse, with 4-6 tables, with various data types (used correctly).
threshold:
pts
|
pts
--
|
|
|
Create (2) different Views with logical ifnormation being pulled from at least (2) different tables.
threshold:
pts
|
pts
--
|
|
|
Create at least (2) the following constraints (check, null, default, unique) to maintain data integrity.
threshold:
pts
|
pts
--
|
|
|
Create at least (1) package, function or trigger.
threshold:
pts
|
pts
--
|
|
|
Create (2) Users (1) with Read-Only Acces and (1) with Update Access, provide user login information.
threshold:
pts
|
pts
--
|
|
|
Create (2) different Data Manipulation Language (DML) statements to test your users access.
threshold:
pts
|
pts
--
|
|
|
Create (1) word document, with all of the tables and views scripted, so that all table information is displayed.
threshold:
pts
|
pts
--
|
|
|
Provide the Database (See FinalProject_ScriptUploadInstructions) so that you send the database objects as well as the data for me to import.
threshold:
pts
|
pts
--
|
|
|
Creat Entity Design Daigram, and include it at the end of your Database Design Document (DDD).
threshold:
pts
|
pts
--
|
|
|
Create Maintenance Plan, and include snapshot at the end of your Database Design Document (DDD).
threshold:
pts
|
pts
--
|
