The issue was that you allowed the value passed from the client to be executed directly to the database, without performing any sort of check or validation.

In Assignment 1, you saw how an intruder can exploit your system and gain admin permissions by using a carefully crafted string. The issue was that you allowed the value passed from the client to be executed directly to the database, without performing any sort of check or validation. SQL injections rely on this type of vulnerability.
Before we introduce the solutions, we create another non-admin user. Open the SQL shell and repeat Step 3 in Assignment 1 to login database.
Comments from Customer
Currently just need Step 3.3. Create a secure count_rows() method

In the class exercise we created 3 dimension table for our tb dw: year, country and gender.

**Using pgAdmin4
**Restore backupfile to pgAdmin4
** Request Writer [430444]
In the class exercise we created 3 dimension table for our TB DW: Year, Country and Gender. Though rare, Country Names do change. For example: In 1997 Zaire became Democratic Republic of the Congo. Also, in 2018 Swaziland changed to Eswatini. For this exercise, make believe that happened in 2008
This exercise is to alter the country_dim table to become “Type 2 SCD”. Review page 27 in the Kimball Group Reader to ensure the appropriate fields are added.
Also, please consider 2 digit country codes as ‘Natural Keys’. Here is a list
– https://www.iban.com/country-codes (Links to an external site.).
For now, make sure these are updated for the countries changing (other can be value ‘NA’)
Be sure to change the fact table accordingly.
Your should show the SQL / DDL to create / alter the tables
and show the data and queries showing the varying dimension data.

Provide some color:

In class, you analyzed a Shipment OLTP ER Diagram and thought about how to make it a Dimensional Model/Data Warehouse.
For this assignment you will design, make and load (small amount of data) to your Data Warehouse?
Please provide the DIMENSIONAL design (in DB Schema or any graphical way)
Show the DDL to create the objects, be sure to have referential integrity and surrogate keys.
Show the DML to load the data.
Show the queries of some results
Provide some color:
– Is it Star or snowflake?
– Any challenges?
– What is the grain for the fact(s) table?
– Why were the dimensions chose?
Using PgAdmin, you can create a new shipment database and create the objects and load some data.
https://marine-digital.com/article_data_analytics_in_maritime
https://www.inttra.com/demand-uptake-analytics/

Consider checks of normality, deal with multicollinearity and come up with a plan to systematically add/remove variables to get to your final model and analyze.

Using the “That’s Entertainment” case study mentioned on the powerpoint, make a formal regression analysis. Consider checks of normality, deal with multicollinearity and come up with a plan to systematically add/remove variables to get to your final model and analyze. Optionally you may choose to do this using other tools mentioned in class prior such as SAS.