Group Project For the group project, you will be creating

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

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

As an addiction professional, you may contribute to social change

  As an addiction professional, you may contribute to social change in a variety of ways. For example, you may educate clients and families, engage in local community and political agendas to help those in need, and connect with other professionals in the field across the city, state, or nation.

Think about disasters your community has or could potentially face.

Think about disasters your community has or could potentially face. Now, think about how your community is helping its members prepare. Explore your community and find an advertisement that represents helping community members be prepared for a disaster. Examples could be a billboard, poster at a bus stop, marquee sign,

CRIT 502 Exploratory Essay

What Is an Exploratory Essay? The purpose of an exploratory essay is to investigate a topic through critical inquiry and present the research findings to your audience. An exploratory essay can take different forms, depending on its purpose. For example, a literature review in the social sciences is a form

Define Marketing Go into marketing concepts by identifying the

Assignment Task The Swedish home retailer expects 7,500 jobs to be cut across its operations as it simplifies the organisation. Javier Quinones, country retail manager for Ikea in the UK and Ireland, said the company had to make difficult decisions as it adapts to a “fast-changing retail environment” (https://www.independent.co.uk/news/business/news/ikea-uk-job-cuts-stores( accessed

Briefly describe one of the symbolic actions carried out by

  Briefly describe one of the symbolic actions carried out by Ezekiel, as described in chapters 4-5.  Why would a prophet do such a thing?  Drawing on the discussion of the assigned reading by Petersen, when and where is Ezekiel doing these strange things and how can that help us understand

Hopkins’ Article – 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.

What is your gut reaction, if any, to Singer’s depiction

What is your gut reaction, if any, to Singer’s depiction of the treatment of veal calves and chickens on the modern industrialized farm? Did his article change your attitude toward the treatment of animals? Why or why not? How would Kant’s ethical perspective on the moral status of animals compare

PLEASE LOOK THROUGH EVERYTHING PROPERLY AS TO WHAT YOU NEED

PLEASE LOOK THROUGH EVERYTHING PROPERLY AS TO WHAT YOU NEED TO DO! LOOK AT THE ATTACHMENT! HERE’S A LINK  Social Media and Mental Health – HelpGuide.org  Objective: Students will be writing a formal format to convince readers that they should be pro- or anti- whatever topic you have chosen. You

Response to nursing peer DB_ar Nursing Assignment Help

Response 150 words 1 nursing reference within 5 yrs Qualitative research is a strategy for systematic collection, organization, and interpretation of phenomena that are difficult to measure quantitatively. In health care, qualitative methodologies aim to explore complex phenomena encountered by nurses, other providers, policy makers, and patients (Vaismoradi, 2013). Qualitative research

In the case of Minot, smoke-free dining was not the

  In the case of Minot, smoke-free dining was not the first step toward greater protection against tobacco. A coalition of health, education, and advocates, Stop Tobacco’s Access to Minors Program (STAMP), came together with the aim of reducing tobacco sales to minors (Mason et. al; 2021). Do you think tobacco

Assignment 2: Credible Science and Real-World Problems Due: Week 6

  Assignment 2: Credible Science and Real-World Problems Due: Week 6Points: 150 Skill(s) Being Assessed: Problem Solving Criteria for Success: In this assignment, you will: Explain why the NEJM is a credible and high quality source. Summarize the findings about treating COVID-19 with remdesivir. Explain how the drug’s effectiveness was

Please write a journal reflection on your experience on the

Please write a journal reflection on your experience on the clinical setting for the day. Reflections must demonstrate a high degree of critical thinking in applying, analyzing, and evaluating key course concepts and theories from readings, lectures, media, discussions activities, and/or assignments. Insightful and relevant connections are made through contextual

Usability Evaluation examines the way users interact with products and

Usability Evaluation examines the way users interact with products and services in order to achieve a goal. Often times, there are measures that are tied to those goals that are quantified. Academic literature has a robust catalog of research on studies that examine various perspectives that explore user attitudes and

NSG5003- Advanced Pathophysiology Case Study Nursing Assignment Help

Directions Students should complete Part 1. All students should select three (3) clients (of your choosing) from Part 2 to assess. Part 1 K.S. is a 35-year-old man who has been homeless for the past 5 years. He presents to the health department complaining of flulike symptoms and abdominal pain.

Excel Online Structured Activity: Lease versus Buy Sadik Industries must

Excel Online Structured Activity: Lease versus Buy Sadik Industries must install $1 million of new machinery in its Texas plant. It can obtain a bank loan for 100% of the required amount. Alternatively, a Texas investment banking firm that represents a group of investors believes that it can arrange for

Purpose of the assignment: evaluate 2 professional and/or consumer health

  Purpose of the assignment: evaluate 2 professional and/or consumer health websites. According to recent studies, due to its accessibility and “easiness” patients are using the Internet as the second source of health information after physicians, (HON, 2014).  In light of this, it is important that nurses are able to identify reliable, accurate