Assume that you have been tasked by your employer to develop an incident response plan. Create a list of stakeholders for the IR planning committee. For each type of stakeholder, provide the reasons for inclusion and the unique aspects or vision that you believe each of these stakeholders will bring to the committee.Make sure to follow APA style. Please make sure your submission is 2 - 3 pages in length and meet the minimum APA formatting guidelines:• Only one set of bullet points is allowed* Paper must have a minimum of 750 words12-pt, Times New Roman font• Double-spaced• 1” margins on all sides• Please provide a title page including your Name, Course Number, Date of Submission, and Assignment name.• Paraphrasing of content – Demonstrate that you understand the case by summarizing the case in your own words. Direct quotes should be used minimally.• Reference Section (A separate page is recommended.) Please cite the source using APA formatting guidelines. If you need guidance or a refresher on this, please visit: https://owl.english.purdue.edu/owl/resource/560/10... (link is external) Be sure to include at least three reference sources.• In-text citations – If you need additional guidance, please visit: https://owl.english.purdue.edu/owl/resource/560/02... (link is external)

Option #1: Johnson Video StoreYou are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Johnson Video Store in town. The owners 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 the owners 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 for 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 from 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 The owners assign in their inventory, in addition to the distributor's serial number for the item. Each movie also has a unique identification number. The owners assign in addition to the title and any movie IDs the distributors use in their electronic catalogs. Distributors provide electronic catalogs to the owners, and the information from these catalogs must be included in the database.The owners 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 specific 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. The owners 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 the owners 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.Draw an ERD utilizing a software of your choice.Develop metadata from the ERD and document in an Excel spreadsheet.Using PostgreSQL, develop and execute an SQL script file of DDL SQL to create the database tables in the metadata document.Using PostgreSQL, 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 PostgreSQL develop and execute an SQL script file to:Show the contents of all tablesRetrieve 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 lifecycle steps and methodologies and a conclusion section containing lessons learned from this project.Your paper should be 6-10 pages in length, not including the cover page and references page, and conform to CSU-Global Guide to Writing and APA (Links to an external site.). Include at least five credible references in addition to the course textbook. The CSU-Global Library is a good place to find these references.

In this project, you will use a database to answer questions about scholarships awarded to students at a college. You will create a relationship between two tables, create a query from an existing query, and create queries using text, numeric, compound, and wildcard criteria based using the fields in one or both tables. You will create calculated fields, group data when calculating statistics, create a crosstab query, and create a parameter query. will attach files you needThis is a link to the access file that youll be working on since i cant upload it on here. https://www.mediafire.com/file/doyyxm9x7hvifju/Ram...