Unit 3 - Individual Project View Assignment Details for Unit 3 - Individual Projectas PDFAssignment OverviewType: Individual ProjectUnit: Data Definition and Data Manipulation LanguageDue Date: Wed,12/9/20Grading Type: NumericPoints Possible: 100Points Earned: Points Earnednot availableDeliverable Length: Word document of 4–5 pages (excluding references and cover page)View objectives for this assignmentGo To:Assignment DetailsScenarioLearning MaterialsReading AssignmentMy Work:Online Deliverables: SubmissionsLooking for tutoring? Go to SmarthinkingAssignment DetailsAssignment DescriptionThe 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?Examples are provided here to help with this assignment.As indicated in Unit 1, 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 TasksInsert 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 ListTotal revenue (sales) per month, grouped by customerTotal revenue (sales) per month, grouped by productTotal count of products, grouped by categoryAdd 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 (Unit 2).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.Name the document "yourname_CS660_IP3.doc."

Answer the three (3) questions on Process Management.Submit your answers in a single Excel® file with multiple worksheets (tabs), and answer each question on a separate worksheet.

For the Unit V PowerPoint Presentation, you will continue to work on your course project, and you will present on the ways in which your selected organization will reduce errors in communication.Start by researching your organization, and determine if they have made an error in communication through an advertisement, consumer policy, or verbal actions to employees. If they have, you will explain that error in your presentation. If not, please research another organization that has, and use this as an example of a situation to avoid.Continuing in your role as the CEO of the organization you chose in the Unit III Assignment, create a presentation to give to your employees that explains the communication blunders and your solutions to avoid them in the future.Include the components listed below in your presentation.If your organization committed a communication blunder, outline the communication error and what went wrong (highlight the shortfalls). If you researched an example, share the example with your organization, and explain what happened and how you can learn from it.Outline your suggested solution(s) to fix the problem and what processes from Chapter 9 in your textbook can be implemented.Explain what your organization can learn from this mistake and ways to improve communication in the future.Support your work with a references slide.Your completed PowerPoint presentation should include a minimum of seven slides, not counting the title and reference slides. You must reference the textbook at a minimum.