Explore BrainMass
Share

Database System Requirements.

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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 three related tables in the database.
Create at least two stored procedures and a script to use each of them.
Create at least one view (using a script).
Create at least one trigger.
Create at least five useful queries. At least one of these queries should use a subquery and at least one 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.

1. A Word document describing the system
2. An ERD or other graphical representation of the system
3. A description of the views, stored procedures, triggers, and queries
4. Step-by-step instructions on how to run the queries that will demonstrate the functionality of the system
5. A summary of strengths and weaknesses of the system, as designed

© BrainMass Inc. brainmass.com October 25, 2018, 7:21 am ad1c9bdddf
https://brainmass.com/business/management-information-systems/database-system-requirements-500437

Solution Summary

Solution for the given problem statement is attached as a zip file along with sql queries.

$2.19
See Also This Related BrainMass Solution

Normalized Relational Database Management System

Please help with the following problem.

Design a completely Normalized Relational Database Management System that meets both the high-level and technical requirements of the web-based project management system.
Submit a word doc answering all parts of the question.
Thanks in advance.

File is attached.

View Full Posting Details