Group Project. For the group project, you will be creat

Added on - 18 Sep 2019

  • 2

    Pages

  • 353

    Words

  • 102

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 1 of 2 pages
Group ProjectFor 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, eachstudent 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 databasewith 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 ofthe 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 documentwith the following information. This document will be submitted as a separate item along with the ZIP ofthe database and the associated files. Do not submit a single group document. This document must becreated individually, and copying from other group members is not allowed. Your assignment mustinclude the following:A Word document describing the systemAn ERD or other graphical representation of the system
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document