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

Unit 4 Assignment: OSHA 300 Log and 301 ReportOutcomes addressed in this activity: Unit Outcomes: Associate safety rules and regulations related to reporting injuries or illnesses in the workplace.Com

Unit 4 Assignment: OSHA 300 Log and 301 ReportOutcomes addressed in this activity: Unit Outcomes: Associate safety rules and regulations related to reporting injuries or illnesses in the workplace. Complete the OSHA 300 Log and 301 Injury Report for a workplace injury. Discuss the OSHA 300 Log and 301 Injury

️ A PERSONAL WARNING TO ACADEMIC WRITERS I want to share this for any writer still working on Studydaddy.com. In my experience, that platform is a serious waste of time and effort. After completing or

️ A PERSONAL WARNING TO ACADEMIC WRITERS I want to share this for any writer still working on Studydaddy.com. In my experience, that platform is a serious waste of time and effort. After completing orders and delivering work, it often feels like working for free. Earnings are heavily reduced, and

IMPORTANT NOTICE TO ACADEMIC WRITERS To writers currently working on Studydaddy.com, Many writers have reported serious problems with Studydaddy.com, including excessive commission deductions, lack of

IMPORTANT NOTICE TO ACADEMIC WRITERS To writers currently working on Studydaddy.com, Many writers have reported serious problems with Studydaddy.com, including excessive commission deductions, lack of payment clarity, ignored messages, and repeated muting or blocking when payment concerns are raised. Writers feel undervalued, disrespected, and powerless on the platform. Because of

WRITER WARNING & OPPORTUNITY NOTICE I’m speaking directly to academic writers who are currently working on Studydaddy.com. From what I have seen and from experiences shared by many writers, Studyd

WRITER WARNING & OPPORTUNITY NOTICE I’m speaking directly to academic writers who are currently working on Studydaddy.com. From what I have seen and from experiences shared by many writers, Studydaddy.com is one of the worst platforms to invest your time and effort in. Working there often feels like working without

project assignment papers NOTICE TO ACADEMIC WRITERS To all writers currently working on Studydaddy.com, Over time, many writers have expressed concerns about high commission deductions, lack of tra

project assignment papers NOTICE TO ACADEMIC WRITERS To all writers currently working on Studydaddy.com, Over time, many writers have expressed concerns about high commission deductions, lack of transparency, and poor communication on certain academic platforms. These challenges make it difficult for writers to grow, earn fairly, and work in a

This is just part one my research paper so it should include….the paper’s title, area of intended research, a statement of the problem, situational analysis, premise, definitions, limitations, delim

This is just part one my research paper so it should include….the paper’s title, area of intended research, a statement of the problem, situational analysis, premise, definitions, limitations, delimitations, and introduction if relevant.  Please do not use any AI, no plagiarism, cite references and APA style is preferred.  Requirement is

In this reflective activity, you will reflect on the critical aspects of managing systems projects and enhancing cybersecurity within the operations phase of the SDLC.For this Reflection activity, res

In this reflective activity, you will reflect on the critical aspects of managing systems projects and enhancing cybersecurity within the operations phase of the SDLC. For this Reflection activity, research and answer the following questions: What role does risk assessment play in cybersecurity planning? How can a security-first mindset be

Imagine that you are the director of health information for a large hospital. As director, you sit on various institution-wide committees that govern organizational procedures. In collaboration with i

Imagine that you are the director of health information for a large hospital. As director, you sit on various institution-wide committees that govern organizational procedures. In collaboration with interdepartmental committees, you have been asked to write a blog post explaining blockchain in healthcare to non-technical stakeholders within the organization. Your

A critical security patch has just been developed to address a significant vulnerability in your product. Usually, your team conducts thorough regression testing on updates to ensure they do not intro

A critical security patch has just been developed to address a significant vulnerability in your product. Usually, your team conducts thorough regression testing on updates to ensure they do not introduce new bugs or issues. However, due to pressures to meet tight deployment deadlines, your manager instructs you to skip

In this chapter you learned about quality assurance in system maintenance and support. This exercise helps to deepen your understanding of quality assurance practices during system maintenance and sup

In this chapter you learned about quality assurance in system maintenance and support. This exercise helps to deepen your understanding of quality assurance practices during system maintenance and support. Instructions: Answer the following questions: Why is the Maintenance and Support phase crucial for IT systems? How can effective documentation enhance

Instructions Imagine that you are the director of health information for a large hospital. As director, you will create a chronological timeline of federal initiatives that have progressed health info

Instructions Imagine that you are the director of health information for a large hospital. As director, you will create a chronological timeline of federal initiatives that have progressed health information exchange in the United States. The timeline should include the following information: Select at least 8 federal initiatives that have

In this chapter you learned about managing system implementation. This exercise helps to deepen your understanding of the critical aspects of managing system implementation and ensuring quality throug

In this chapter you learned about managing system implementation. This exercise helps to deepen your understanding of the critical aspects of managing system implementation and ensuring quality throughout the process. Instructions: Answer the following questions: Why is quality assurance crucial during system implementation? How can effective documentation enhance the implementation

In this chapter you learned about the Implementation Phase in the SDLC. This exercise deepens the understanding of the Implementation Phase in the SDLC. Instructions: Research: Conduct research on the

In this chapter you learned about the Implementation Phase in the SDLC. This exercise deepens the understanding of the Implementation Phase in the SDLC. Instructions: Research: Conduct research on the Implementation Phase. Explore its purpose, key activities, and significance within the SDLC. Create a Summary: Write a concise summary of

The Impact Of Technology On OrganizationsWk 8 – Summative Assessment: Technology-Management Plan Imagine this scenario: You are a technology development consultant for a large service organization. Ex

The Impact Of Technology On OrganizationsWk 8 – Summative Assessment: Technology-Management Plan Imagine this scenario: You are a technology development consultant for a large service organization. Executive leadership has given you the responsibility of developing a technology-management plan. Write a 1,400- to 1,750-word paper in which you evaluate the management