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 S

profileUOPOnlineTutor
 (Not rated)
 (Not rated)
Chat

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 ITD640_GPx where "x" is your group letter. Populate your database with appropriate test data.

Include all of the scripts in a single file called ITD640_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:

I will need the mfd and log files

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, a log file, query files in a zip file called ITD640_GP.ZIP, and his or her own individual summary document as a separate submission. You will have to detach the database before creating the zip file.

    • 4 years ago
    A+ Solution 100% Correct Already Graded
    NOT RATED

    Purchase the answer to view it

    • attachment
      sql_solution.zip