Use the star schema developed in Portfolio Milestone 1 - Option 1 in Module 3; incorporate your instructor's feedback.Use the tables created in Portfolio Milestone 2 - Option 1 in Module 5; incorporate your instructor's feedback.Develop and execute the SQL commands to populate the fact and dimension tables by extracting data from the Northwind OLTP database and loading the data into the tables within the Northwind Data Warehouse. Your ETL workflow should consist of selecting the required variables from the source database and tables and inserting the required variables into the destination database and tables. After you have populated the tables, construct an SQL command to count the number of rows in each table. Capture a screenshot of the row count for each table. Finally, construct an SQL command to list the first ten rows of each table. Capture a screenshot of each listing.Your deliverable for this Portfolio Project is a report containing the following information:Changes to your business process, business questions, and fact table grain from Module 5Updated version of the star schema incorporating your instructor's feedback from Module 5Screenshots of the row counts and table listingsListing of SQL commands used in this assignmentA brief description of lessons learned in completing the Portfolio Project and the two Milestones. Based on your lessons learned, what advice would be offer to an organization embarking on building a data warehouse system?Your paper should be six to eight pages in length, organized and well-written, and in conformity with the CSU Global Writing Center (Links to an external site.).In support of your response, cite and integrate at least one credible outside source, which can be your textbook. Place the sources in a reference page formatted in accordance with APA style. This reference page does not count toward the total page requirement. The CSU Global Library is a great place to find these resources.

TRANSCRIPT The United States' critical infrastructure—power, water, oil and natural gas, military systems, financial systems—have become the target of cyber and physical attacks as more critical infrastructure systems are integrated with the internet and other digital controls systems. The lesson learned in mitigating and defending against cyberattacks is that no entity can prevent or resolve cyberattacks on its own. Collaboration and information sharing are key for success and survival. This is a group exercise, representing collaboration across all sectors to support and defend US critical infrastructure. In the working world, a team like this would include agencies, industrial partners, and private sector corporations. Each organization has different strengths and skills, different access to information, and different authorities to report to. When the sectors work together and share resources and skills, the result is that everyone benefits from the defense and protection of US IT infrastructure. In your teams, you can model the same collaboration, leveraging each other's expertise, sharing each other's knowledge, and teaching each other. This will include providing contributions specific to your role in the scenario: PLEASE NOTE YOU ARE DOING JUST THE AAR REPORT WHICH IS 5 PAGES AND REFERENCES AND PRESENTATION OF SLIDES 3. After Action Report The purpose of the AAR is to share the systems life cycle methodology, rationale, and critical thinking used to resolve this cyber incident. Identify the purpose and function of firewalls for organization network systems, and how they address the threats and vulnerabilities you have identified. Also discuss the value of using access control, database transaction and firewall log files. Identify the purpose and function of encryption, as it relates to files and databases and other information assets on the organization's networks. After Action Report Feedback 4. Presentation (Complete Set of Team Slides and Voice Narration) Title Slide Use of Readable Fonts and Color Summarize SAR and AAR for non-technical audience Summarizes Findings and Recommendations at High Level Slide Narration or In Class Presentation (5-6 minutes or a portion of report) Presentation Slides Feedback

Part I—Hands-on Lab For the hands-on lab, you will submit a Microsoft Access database and a Microsoft Word document with SQL statements for the following: Create a new Microsoft Access database named Travel. Note that Microsoft Access does not support the use of SQL scripts to create databases. In Microsoft Word, type the SQL script that you would have used to create the database. Now, add a table named Car_Rental to the Travel database. Make sure that you include the Car_Rental_ID field whose datatype is AutoNumber. In Microsoft Word, type the SQL script that you would have used to create the table. Include the following fields: Car_Rental_ID (AutoNumber, primary key, required) Agency (Text(25), required) Size (Text(25), required) Make (Text(12), required) Model (Text(25)) Daily_Cost (Currency) Write INSERT statements for adding the following data to the new table: Agency Size Make Model Daily_Cost Avis Mid Ford 89.95 Avis Full Ford Taurus 112.95 Hertz Comp Chev Cavalier 69.95 Hertz Mid Chev Malibu 84.99 Hertz Full Chev Impala 114.99 National Mid Chrys Stratus 77.95 National Full Chrys Intrepid 109.95 Verify the values inserted by using a query. Display each distinct agency (each agency only once). Display the average cost of a Chrysler rental. Display the total count of cars available. Display the highest-priced vehicle. Display each unique agency with the average car price for that agency. Part II—Course Project Course Project Part 4—Creating a Database Continuing with the project you worked on for Weeks 1, 2 and 3, this week, complete the following tasks: In Microsoft Access, create the database and tables that you identified in W3 Assignment 2. In Microsoft Word, write the SQL statements to create the database and tables. Write SQL statements to populate the tables. Run the SQL statements in Microsoft Access for populating the tables. Assignment Deliverable After you complete the lab and course project, collate the information from both in a 3- to 4-page report in a Microsoft Word document. Include the SQL scripts in the Microsoft Word document. Include the Travel database as a separate attachment.