For your final paper, pick one of the following departments:A Manufacturing Department producing widgets with an internal production rejection rate of 2% and a return within warranty period of 5%.A Service Department with complaints from 7% of its customers.Neither department has detailed records of what the issues are. In your paper, recommend a proposed quality improvement plan based on the COPIS model. The recommendation should include the following:Build the justification for a quality improvement plan.Identify several approaches to customer service and describe one more in depth; illustrate the relationship between customer loyalty and output satisfaction.Design an output-control and measurement approach to improve process performance.Evaluate different process-improvement and management approaches.Justify a recommended process-improvement approach.Develop an input-measurement and management approach.Develop a supplier-management approach to improve input and supplier quality.Propose your customer-focused recommendations in your summary or conclusion.You improvement plan must incorporate at least three scholarly sources in addition to the course text.The Final PaperMust be five to seven double-spaced pages (1,500 - 1,750 words) in length (not including title and references pages) and formatted according to APA style as outlined in the Ashford Writing Center’s APA Style (Links to an external site.)Links to an external site.Must include a separate title page with the following:Title of paperStudent’s nameCourse name and numberInstructor’s nameDate submittedFor further assistance with the formatting and the title page, refer to APA Formatting for Word 2013 (Links to an external site.)Links to an external site..Must utilize academic voice. See the Academic Voice (Links to an external site.)Links to an external site. resource for additional guidance.Must include an introduction and conclusion paragraph. Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.For assistance on writing Introductions & Conclusions (Links to an external site.)Links to an external site. as well as Writing a Thesis Statement (Links to an external site.)Links to an external site., refer to the Ashford Writing Center resources.Must use at least three scholarly sources in addition to the course text.The Scholarly, Peer Reviewed, and Other Credible Sources (Links to an external site.)Links to an external site. table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.Must document any information used from sources in APA style as outlined in the Ashford Writing Center’s Citing Within Your Paper (Links to an external site.)Links to an external site.Must include a separate references page that is formatted according to APA style as outlined in the Ashford Writing Center. See the Formatting Your References List (Links to an external site.)Links to an external site. resource in the Ashford Writing Center for specifications.Carefully review the Grading Rubric (Links to an external site.)Links to an external site. for the criteria that will be used to evaluate your assignment.

You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database.You sit down with Mom and Pop to discuss their business, and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent, therefore there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices to them are based on the quantity of their shipment and the past business they have done with each company.The price of a DVD for a movie might be different than the price of a video for the same movie, even from the same distributor. Each distributor provides different types of movies (e.g., suspense, horror, mystery, comedy, etc.). A single distributor may provide several different types of movies in both video and DVD format. It is possible to obtain the same movie from multiple distributors and at different wholesale prices.Each video and DVD has a unique identification number that Mom and Pop assign in their inventory, in addition to the distributor's serial number for the item. Each movie also has a unique identification number Mom and Pop assign in addition to the title and any movie IDs the distributors use in their electronic catalogs. Distributors provide electronic catalogs to Mom and Pop, and the information from these catalogs must be included in the database.Mom and Pop need to record when a video or DVD is rented, when a video or DVD is returned, and all customer charges such as late and damaged fees, failure to rewind fees, and taxes. They need a report of which videos are returned late because there are standard and late charges. On occasion there are discount prices for certain movies or types of movies. Customers want to rent movies based on actors or actresses, running length, type of movie, rating, year released, the director, and the Academy Awards won (by the movie, the actors, the actresses and/or the directors). Customers also want to know how many videos they have rented in the last month, year, and so forth. Mom and Pop need to keep only basic information on customers in their database, such as name, address, telephone numbers, etc.There must be no limit to the number of video and/or DVD copies of a movie that Mom and Pop can have in their inventory. Video/DVD ID numbers, movie ID numbers, and distributor ID numbers for videos, DVDs, and movies are all different. Also, each movie must be able to have an unlimited number of actors, actresses, directors, and Academy Awards (i.e., Oscars). Other types of awards (e.g., Golden Globe, People's Choice, etc.) are not of interest for this application. The rental of equipment, sale of videos, DVDs, popcorn, etc., is not to be kept in the database.Identify and describe the entities and their attributes.Develop relationship sentence pairs.Draw an ERD using any graphics tool of your choice. (Viso, PowerPoint, Lucidchart, etc.)Develop metadata from the ERD and document in an Excel spreadsheet.Using your selected RDBMS (SQL Server, Oracle, or MySQL), develop and execute an SQL script file of DDL SQL to create the database tables in the metadata document.Using your selected RDBMS, develop and execute an SQL script file of DML SQL INSERT statements to populate the tables using SQL INSERT statements for at least 5 rows of data per table.Using your selected RDBMS develop and execute an SQL script file to:Show the contents of each of your tables, one at a timeRetrieve all of the customers' names, account numbers, and addresses (street and zip code only), sorted by account numberRetrieve all of the DVDs rented in the last 30 days and sort in chronological rental date orderUpdate a customer name to change their maiden names to married names. You can choose which row to update. Make sure that you use the primary key column in your WHERE clause to affect only a specific row.Delete a specific customer from the database. You can choose which row to delete. Make sure that you use the primary key column in your WHERE clause to affect only a specific row.The metadata should be submitted in an Excel spreadsheet. All other outputs for the database design, SQL code, and SQL results should be submitted in a single Word file in order, by step, and clearly labeled.The Word file should also have a preface describing the database life cycle steps and methodologies and a conclusion section containing lessons learned from the course. The paper should be well written and formatted in conformity with CSU-Global Guide to Writing and APA Requirements.