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 tab

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.

a Word document describing the system
an ERD or other graphical representation of the system
a description of the views, stored procedures, triggers, and queries
step-by-step instructions on how to run the queries that will demonstrate the functionality of the system
a summary of strengths and weaknesses of the system, as designed
Each student will submit the database, log file, and query files in a zip file called ITCO630_GP.ZIP, and his or her own individual summary document as a separate submission. Please detach the database before creating the zip file.

    • Posted: 3 years ago
    A+ Solution 100% Correct Already Graded

    Purchase the answer to view it

    blurred-text
    Save time and money!
    Our teachers already did such homework, use it as a reference!