Our Services

Get 15% Discount on your First Order

Group Project For the group project, you will be creating

November 15, 2021

Group Project

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 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 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. Your assignment must include the following:

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.

Please add your file.

For assistance with your assignment, please use your text, Web resources, and all course materials.

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Complete the following ten questions with a minimum of five

Complete the following ten questions with a minimum of five (5) sentences fully detailing each response. Identify each question you are answering. Answers should incorporate the federal court site information and the questions being asked. Complete sentences are required. (Example of incorporating the question into a sentence, #1: The

main steps involved in preparing any type of speech include

main steps involved in preparing any type of speech include the following: Choose the Right Topic Narrow Your Topic Locate Supporting Material Structure Your Speech Prepare an Outline Practice Deliver Your Speech Step 2 Prepare an introduction speech. In a one-page outline, consider the following as you prepare your

W.E. Deming, the father of modern statistical quality control, is

W.E. Deming, the father of modern statistical quality control, is generally considered to be the originator of the saying “In God We Trust, All Others Bring Data.” While most of the people who cite Deming in this instance use the quote to focus on the need for data-driven decisions, and

Early learning experience and Development of the whole child

Go to FSCJ Online Library and Learning Commons Click Journals A-Z Choose YC Young Children Select Full Text Online option Choose a specific Year, Volume, and Issue to research your topic Click “Search” button Each student will review two peer-reviewed articles on one or two of the following areas: Development

You have been hired as the CSO (Chief Security Officer)

You have been hired as the CSO (Chief Security Officer) for an organization. Your job is to develop a very brief computer and internet security policy for the organization that covers the following areas: Computer and email acceptable use policy Internet acceptable use policy Make sure you are sufficiently specific

Critical Thinking and Data Analytic Technologies That Can Help. We are bombarded with information. We need help to identify what is important and then

Critical Thinking and Data Analytic Technologies That Can Help. We are bombarded with information. We need help to identify what is important and then synthesize it for practical application: 1) What are some of the technologies (data analytics, artificial intelligence, machine learning, etc.) we can use to distill down the

Instructions The assignment must be a minimum of 3-full pages

Instructions The assignment must be a minimum of 3-full pages in length with a minimum of 3-outside sources. Please be sure to follow APA guidelines for citing and referencing source. Assignments are due by 11:59 pm Eastern time on Sunday. 1) Research the United States Office of Personnel Management (OPM)

APA format Parts 1 and 2 have the same questions,

APA format Parts 1 and 2 have the same questions, however, you must answer with references and different writing always addressing them objectively, that is as if you were different students. Similar responses in wording or references will not be accepted. 1) Minimum 6 full pages (No word

Got this website from reddit Instructions Social Movements are only

Got this website from reddit Instructions Social Movements are only as important as the person leading them. The person(s) leading a social movement must have charisma and be able to captivate an audience. Political scientists and historians are taught to analyze body language, especially during debates and speeches. For this

Take a position regarding sustainable innovation based on the Readings

Take a position regarding sustainable innovation based on the Readings and the additional articles you have found on Sustainable Innovation Management and managing by design. Based on your understanding of sustainable innovation, what would need to change in an organization to enable managing by design? If you feel no

Self,Culture and Society – Premium Paper Help

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

#1: IDENTIFY (WHAT YOU CONSIDER TO BE) THE 10 MOST

#1: IDENTIFY (WHAT YOU CONSIDER TO BE) THE 10 MOST IMPORTANT ECONOMIC INDICATORS (LISTED ON MOODY’S ANALYTICS) THAT BEST EXPLAIN THE CURRENT STATE OF THE U.S. ECONOMY. DISCUSS EACH ONE OF THESE MEASURES, FOCUSING ON ITS IMPORTANCE, WHAT IT SAYS ABOUT THE CURRENT STATE, THE LATEST READING AND TREND,

Immigration : a documentary and reference guide Thomas Cieslik, Immigration:

Immigration : a documentary and reference guide Thomas Cieslik, Immigration: A Documentary and Reference Guide, Greenwood Press, 2009. E-book available free to Saint Leo students through Saint Leo University Cannon Memorial Library website. Go to Ch. 9, document 4 beginning on p. 199 “Proposition 187 of 1994 – Arguments

Assignment: For this assignment-you are being asked to submit a

Assignment: For this assignment-you are being asked to submit a research based analysis report over a Program Specific Case Study. The parameters are as follows: PLEASE USE THE DOCUMENT UPLOADED FOR THE CASE STUDY TOPIC You will provide a case study analysis report. It must be a minimum of 3,000 words (excluding

Reflect on this module’s textbook readings and resources to complete

Reflect on this module’s textbook readings and resources to complete this assignment and read this NY Times article: Don’t Toss That Shirt. They’ll Pick It Up. Answer the following questions. Do you think the appeal of recycled and upcycled clothing will surge more favorably into the future? Or do consumers

According to your textbook, the strategy-evaluation process consists of three

According to your textbook, the strategy-evaluation process consists of three basic activities: Examine the underlying bases of a firm’s strategy. Compare expected results with actual results. Take corrective actions to ensure that performance conforms to the plan. Which of the three strategy-evaluation activities do you think is most critical to

I need to do a PowerPoint project. Should be no

I need to do a PowerPoint project. Should be no less than 20 slides without counting the presentation and references, with illustrations and with the specifications required by the institution. It should be on Friday at noon. Topic: Treatment and management of Diverticular Disease Be emphatic on pathophysiology, clinical

Research Proposal Draft By the due date assigned, write a 1-page paper addressing the sections below of the research proposal. Methodology Data Analysis

Research Proposal Draft By the due date assigned, write a 1-page paper addressing the sections below of the research proposal. Methodology Data Analysis Plans Describe the plan for data analysis for demographic variables (descriptive statistical tests). Describe a plan for data analysis of study variables (descriptive and inferential statistical tests)