Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

The case study retail store has provided a list of reports and data manipulation tasks that are needed in the processing of orders for their customers. Answer the following: What structured query lang

The case study retail store has provided a list of reports and data manipulation tasks that are needed in the processing of orders for their customers. Answer the following:

  • What structured query language (SQL) statement scripts are needed to create the database schema for the relational database system and manipulate the data in the solution that you are proposing to the company?
  • How does each of these scripts specifically support the goals and objectives of the company?

Review these examples to help you with this assignment.

It is assumed that Microsoft SQL Server Express Edition (with management tools) was chosen as the database platform. It can be downloaded for free at this Web site.

The project deliverables are as follows:

  • Data Manipulation Tasks
    • Insert 20 records into each table for testing purposes.
    • Delete an entire order by using the unique identifier for that order.
    • Update the price of a product by using the unique identifier for that product.
    • Add a minimum of 3 of your own data manipulation language (DML) scripts based on the needs and specifications of your retail store.
  • Report List
    • Total revenue (sales) per month, grouped by customer
    • Total revenue (sales) per month, grouped by product
    • Total count of products, grouped by category
    • Add minimum of 3 of your own report scripts based on the needs and specifications of your retail store (one must be a CROSSTAB)
  • SQL (4–5 pages)
    • Include the database definition language (DDL) scripts to CREATE to database schema as described in the entity–relationship (E–R) diagram.
    • Include the database manipulation scripts (DML) that will be used to INSERT, DELETE, and UPDATE data in the proposed database system.
    • Include the SELECT, CROSSTAB, and AGGREGATE FUNCTION statements that will be used to read data from the proposed database system.
    • Provide your analysis as to how this part of the project fulfills the mission and 1 or more goals of the case study organization.
    • Provide the following attachments (in addition to embedding in document):
      • DDL.sql (including CREATE and INSERT statements so that they execute in the correct order [top-down])
      • DML.sql (including DELETE and UPDATE statements so that they can be executed in any order as selected)
      • REPORT.sql (including SELECT, CROSSTAB, AGGREGATE FUNCTION statements so that they can be executed in any order as selected)
    • Note: You will embed each script in the Word document and also provide it as an attachment.
  • All sources should be cited both in-text and in references using APA format.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

Foundations Of Information Systems Management (Summative Assessment: DIKW and Business Strategy) As a leader in your selected field, it is important to be able to organize and explain the resources av

Foundations Of Information Systems Management (Summative Assessment: DIKW and Business Strategy) As a leader in your selected field, it is important to be able to organize and explain the resources available within the organization. The data, information, knowledge, and wisdom (DIKW) model is a tool for knowledge management.  In this

Utilizing material from your text, along with the breadth and depth of the Internet, please provide a well-developed response for each of the three (3) questions provided below. What is the defining d

Utilizing material from your text, along with the breadth and depth of the Internet, please provide a well-developed response for each of the three (3) questions provided below. What is the defining difference between computer security and information security? Why can we argue that information security is really an application

I need a 12-page Cybersecurity Breach Analysis paper written by August 2, 2025. The paper must be 100% plagiarism-free, AI-free, and meet all assignment requirements and word count expectations (has t

I need a 12-page Cybersecurity Breach Analysis paper written by August 2, 2025. The paper must be 100% plagiarism-free, AI-free, and meet all assignment requirements and word count expectations (has to be more than 3500 words “quality work”. Please check attached file for details about the paper. 

Virtualization AssignmentSUBMIT ASSIGNMENT Start Date Jul 24, 2025, 12:00 AM Due Date Jul 30, 2025, 11:59 PM Points60RubricView RubricStatusActiveAssessment TraitsRequires LopeswriteAssessment Descrip

Virtualization AssignmentSUBMIT ASSIGNMENT Start Date Jul 24, 2025, 12:00 AM Due Date Jul 30, 2025, 11:59 PM Points60RubricView RubricStatusActiveAssessment TraitsRequires LopeswriteAssessment Description Virtualization began in the 1960s, as a method for logically dividing the system resources provided by mainframe computers between different applications. Since then, the meaning of the term

Requires LopeswriteAssessment Description Understanding all the components needed to write a technical report is essential to your program of study. Build upon the information in your “Reference List”

Requires LopeswriteAssessment Description Understanding all the components needed to write a technical report is essential to your program of study. Build upon the information in your “Reference List” assignment from Topic 2 to create a 750- to 1,000-word technical report. Include the following: A Background of the Topic – This

I have attached the screenshot of the ass below for the graph!! Question 1 (25 pts): Figure 1 Graphs for Question 1. a. In Figure 1(a), determine if the graph is simple. Also determine if ther

I have attached the screenshot of the ass below for the graph!! Question 1 (25 pts): Figure 1 Graphs for Question 1. a. In Figure 1(a), determine if the graph is simple. Also determine if there is a cycle in this graph. b. In Figure 1(a), determine if the vertices 3 and 9 are connected. If these vertices

Harnessing the Power of AI for Strategic Decision- Making: Opportunities and Challenges The objective of this assignment is to understand and analyze the role of artificial intelligence (AI), busines

Harnessing the Power of AI for Strategic Decision- Making: Opportunities and Challenges The objective of this assignment is to understand and analyze the role of artificial intelligence (AI), business intelligence (BI), and business analytics (BA) in enhancing organizational decision-making processes, while also considering the ethical and social implications. Using PowerPoint,

It is important to understand what information systems are and why they are essential for running and managing a business. It is also important to understand the different systems that support differe

It is important to understand what information systems are and why they are essential for running and managing a business. It is also important to understand the different systems that support different groups or levels of management. In addition, digital technology and the Internet play a key role in executing

It is important to understand what information systems are and why they are essential for running and managing a business. It is also important to understand the different systems that support differe

It is important to understand what information systems are and why they are essential for running and managing a business. It is also important to understand the different systems that support different groups or levels of management. In addition, digital technology and the Internet play a key role in executing