Database and Design Systems Assignment

Group Project

For the group project, you will be creating a database system to solve a business problem of your choice. The database system must meet the criteria shown below. In addition to the database solution, each student will prepare a system summary.

Database System Requirements (Group Work):

Create a database and name it ITCO630_GPx where “x” is your group letter. Populate your database with appropriate test data.
Include all of the scripts in a single file called ITCO630_GPx.SQL where x is your group letter.
Create at least 3 related tables in the database.
Create at least 2 stored procedures and a script to use each of them.
Create at least 1 view (using a script).
Create at least 1 trigger.
Create at least 5 useful queries. At least one of these queries should use a subquery and at least 1 of the queries should use an aggregate function.
All scripts should be well-documented.

Individual Summary:

In addition to the group work described above, each group member will prepare a summary document with the following information. This document will be submitted as a separate item along with the ZIP of the database and the associated files. Do not submit a single group document. This document must be created individually, and copying from other group members is not allowed. Your assignment must include the following:

Grading Criteria

Project Criteria	Exceeds: 90%–100%	Very Good: 80%–89%	Meets: 70%–79%	Needs Improvement: Below 70%
Content (40%)	Response covers all topics indicated in the assignment and adds additional content.	Response covers most topics indicated in the assignment.	Response covers many of the topics indicated in the assignment.	Response covers none to some of the topics indicated in the assignment.
Effective Communication (10%)	Demonstrates outstanding or exemplary application of written, visual, or oral skills. Demonstrates outstanding expression of topic, main idea, and purpose. Audience is addressed appropriately. Language clearly and effectively communicates ideas and content relevant to the assignment. Errors in grammar, spelling, and sentence structure are minimal. Organization is clear. Format is consistently appropriate to assignment. Presentation and delivery are confident and persuasive (where applicable). The writing was of collegiate level with no errors in spelling or grammar.	Demonstrates very good written, visual, or oral skills. Demonstrates sound expression of topic, main idea, and purpose. Audience is usually addressed appropriately. Language does not interfere with the communication of ideas and content relevant to the assignment. Errors in grammar, spelling, and sentence structure are present, but do not distract from the message. Organization is apparent and mostly clear. Format is appropriate to assignment, but not entirely consistent. The writing was of collegiate level with two or less errors in spelling or grammar.	Demonstrates acceptable written, visual, or oral skills. Demonstrates reasonable expression of topic, main idea, and purpose. Sometimes, audience is addressed appropriately. Language does not interfere with the communication of ideas and content relevant to the assignment. Errors in grammar, spelling, and sentence structure are present and may distract from the message. Organization is a bit unclear. Format is inconsistent. The writing was of collegiate level with several errors in spelling or grammar.	Demonstrates inadequate or partially proficient application of written, visual, or oral skills. Demonstrates inadequate or partial expression of topic, main idea, and purpose. Audience is often not addressed appropriately. Language often impedes the communication of ideas and content relevant to the assignment. Errors in grammar, spelling, and sentence structure are frequent and often distract from meaning or presentation. Organization is inadequate, confusing, and distracting. The format is inadequate and obscures meaning. The writing was less than collegiate level with numerous errors in spelling or grammar.
Supporting Analysis (25%)	Analysis exceeds minimum requirements. Sources are used to support analysis, are appropriate, and are properly referenced.	Basic analysis provided to support assertions. Sources are cited, appropriate, and properly referenced.	Limited analysis provided to support assertions. Some sources are cited, appropriate, and properly referenced.	No or inaccurate analysis, no sources are cited when needed, analysis and/or sources are not appropriate. When sources are used, they are not properly referenced.
Effective Planning and Execution of Project (25%)	Student participated fully, offered significant contributions to the development of a plan that identified all necessary tasks. Student demonstrated exceptional team skills in most of these areas: collaboration, leadership, consensus building, negotiation, conflict resolution, respect, problem solving, management, organizational, time management, etc. Supported other team members at the highest level.	Student participated at an adequate level (85%), offered reasonable suggestions for the development of a plan that identified nearly all necessary tasks. Student demonstrated very good team skills in several of these areas: collaboration, leadership, consensus building, negotiation, conflict resolution, respect, problem solving, management, organizational, time management, etc.. Provided support to other team members.	Student participated in a limited fashion and contributed very little to the development of a plan that identified some of the necessary tasks. Student demonstrated at least one team skill (i.e. collaboration, leadership, consensus building, negotiation, conflict resolution, respect, problem solving, management, organizational, time management, etc.).

Last Updated on February 11, 2019