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

Discuss the importance of user interfaces in technology and the principles of HCI. Objective: In this chapter you learned about the principles and best practices of designing user interfaces and sourc

Discuss the importance of user interfaces in technology and the principles of HCI. Objective: In this chapter you learned about the principles and best practices of designing user interfaces and source documents/forms. Instructions:  Choose a specific topic related to user interfaces and HCI (e.g., the importance of user research, the role

In this reflective activity, you will reflect on your understanding of how data is organized, stored, and managed, and to recognize the importance of mastering data design for systems analysts.For thi

In this reflective activity, you will reflect on your understanding of how data is organized, stored, and managed, and to recognize the importance of mastering data design for systems analysts. For this Reflection activity, research and answer the following questions: In 1000 words, how would you explain the importance of

Review the journal article about cloud security in healthcare, “Data Privacy in Cloud-assisted Healthcare Systems: State of the Art and the Future Challenges“ by Anam Sajid and Haider Abbas and provid

Review the journal article about cloud security in healthcare, “Data Privacy in Cloud-assisted Healthcare Systems: State of the Art and the Future Challenges“ by Anam Sajid and Haider Abbas and provide ALL of the following information: A summary of the article’s main points List and summarize the main areas of

Discuss the difference between a logical model and a physical model. Objective: In this chapter you learned that systems development involves creating models to understand and design information syste

Discuss the difference between a logical model and a physical model. Objective: In this chapter you learned that systems development involves creating models to understand and design information systems. This exercise explores the relationship between logical and physical models in the context of systems development. Instructions: Answer the following questions: Why is it essential

In this reflection activity, we will explore the concept of object modeling, its significance in software development, analyze the benefits of using object-oriented approaches, and consider real-world

In this reflection activity, we will explore the concept of object modeling, its significance in software development, analyze the benefits of using object-oriented approaches, and consider real-world scenarios where object modeling plays a crucial role. Begin by reviewing the object modeling information in Chapter 6. Pay attention to the key

Your supervisor manages the corporate office where you work as a systems analyst. Several weeks ago, after hearing rumors of employee dissatisfaction, they asked you to create a survey for all IT empl

Your supervisor manages the corporate office where you work as a systems analyst. Several weeks ago, after hearing rumors of employee dissatisfaction, they asked you to create a survey for all IT employees. After the responses were returned and tabulated, your supervisor was dis-appointed that many employees assigned low ratings

The computer science instructor at a local high school asked you to visit her class and give a presentation about project management. You have just a few days to prepare, and you need to develop a pre

The computer science instructor at a local high school asked you to visit her class and give a presentation about project management. You have just a few days to prepare, and you need to develop a presentation that describes project management, project management tools and techniques. Thinking about what to

Information Systems for Life: Chapter 4 Activity: Discuss the key benefits and challenges of Joint Application Development (JAD). Objective: In this chapter you learned that joint application developm

Information Systems for Life: Chapter 4 Activity: Discuss the key benefits and challenges of Joint Application Development (JAD). Objective: In this chapter you learned that joint application development (JAD) is a user-oriented technique for fact-finding and requirements engineering. This exercise strengthens the understanding of techniques used to capture a comprehensive and accurate

Activity: Discuss the importance of effective communication within systems projects. Objective: In this chapter you learned that effective communication is a critical aspect of systems projects. This

Activity: Discuss the importance of effective communication within systems projects. Objective: In this chapter you learned that effective communication is a critical aspect of systems projects. This exercise highlights the impact of effective communication on a company’s systems projects. Instructions: Research effective communication on the Project Management Institute website (  Consider the significance of communication in

A SWOT analysis categorizes an organization’s top strengths, weaknesses, opportunities, and threats into an organized list and is usually presented in a simple two-by-two grid. Tasks: From the followi

A SWOT analysis categorizes an organization’s top strengths, weaknesses, opportunities, and threats into an organized list and is usually presented in a simple two-by-two grid. Tasks: From the following list of possible corporate threats, select one (1): A disconnected, and less loyal, customer base Being leap-frogged by competitor’s technology Breach of

Information Systems for Life: Chapter 1 Activity: Discuss the Pros and Cons of “Bring Your Own Device” (BYOD) in a corporation. Objective: In this chapter you learned about the impact that the develop

Information Systems for Life: Chapter 1 Activity: Discuss the Pros and Cons of “Bring Your Own Device” (BYOD) in a corporation. Objective: In this chapter you learned about the impact that the development of mobile devices and the app ecosystem have had on systems analysts and the knowledge they have to acquire

The Impact Of Technology On Organizations Summative Assessment: Innovative Capabilities Audit Innovation is essential to an organization’s success. When evaluating an organization’s ability to mana

The Impact Of Technology On Organizations Summative Assessment: Innovative Capabilities Audit  Innovation is essential to an organization’s success. When evaluating an organization’s ability to manage technology and innovation, leaders and managers must be cognizant of (and realistic about!) the firm’s capabilities. However, measuring an organization’s capability to innovate can be challenging. The

Systems Analysis and Design Reflection Activity: Chapter 2 Feasibility studies are critical in project management, helping us determine whether proposed projects are viable. As systems analysts, unde

Systems Analysis and Design Reflection Activity: Chapter 2  Feasibility studies are critical in project management, helping us determine whether proposed projects are viable. As systems analysts, understanding feasibility is essential. Let’s explore how reflection can enhance the feasibility evaluation process by answering the following questions:   1. Why are feasibility studies

Systems Analysis and Design Reflection Activity: Chapter 1 In this reflection activity, we will explore the critical role of systems analysts within organizations. Systems analysts play a pivotal rol

Systems Analysis and Design Reflection Activity: Chapter 1  In this reflection activity, we will explore the critical role of systems analysts within organizations. Systems analysts play a pivotal role in bridging the gap between business needs and technology solutions. By understanding their responsibilities, skills, and challenges, we gain insights into the

Provide a one-page summary of your learning experience from the class that I took about Fundamentals of Information Systems Security ( Kim, D., & Solomon, M. G. (2023). Fundamentals of information

Provide a one-page summary of your learning experience from the class that I took about Fundamentals of Information Systems Security ( Kim, D., & Solomon, M. G. (2023). Fundamentals of information systems security (4th ed.). Jones & Bartlett Learning.).  What critical thinking skills have you acquired over the past nine weeks, which

You are in the early stages of preparing a presentation for your organization’s Global Partners Meeting to be held in Geneva. Executive management, inspired by your unstoppable drive for sustainable

You are in the early stages of preparing a presentation for your organization’s Global Partners Meeting to be held in Geneva.  Executive management, inspired by your unstoppable drive for sustainable and viable information security practices across the organization, has asked you to prepare a presentation that will address the issues

Continued from 591164 Unit VII Final Research Paper Assignment objective: In this assignment, you will produce your final paper with the addition of the counterargument and conclusion paragraph,

Continued from 591164 Unit VII Final Research Paper Assignment objective: In this assignment, you will produce your final paper with the addition of the counterargument and conclusion paragraph, your revised introduction paragraph and developed body paragraphs, and a references page with at least three sources. Length: The overall paper should be 1,300