Ask a question from expert

Ask now

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

2 Pages353 Words238 Views
   

Added on  2019-09-18

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

   Added on 2019-09-18

BookmarkShareRelated Documents
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, 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 ofthe 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: A Word document describing the system An ERD or other graphical representation of the system
Group Project. For the group project, you will be creat_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Desklib - Online Library for Study Material with Solved Assignments, Essays, Dissertations
|4
|744
|354

Build the database you designed in CA4 - Databases, 2016
|4
|955
|313

Southern Cross University Employees, Location, Alumni
|11
|1157
|17

INSY 3432 Database Systems Assignment
|3
|1000
|365

Instructions for Submission 4 - SQL.
|3
|553
|270

COMP1686- Web Database Applications Contribution
|8
|2397
|406