Question

Task 1 Create two script files: • Al_yourname_create_warehouse.sql • Al_yourname_data_warehouse.sql (for example, my answer is called Al_mila_create_warehouse.sql). Change the comments (-- in the sql) and add your name and modification date/time) Use the DDL script file Assignment1_schema.sql as an example to create required four tables only. (please create each table separately and DO NOT RUN the entire script - this is easier to find errors). Use the DML script Assignment1_data.sql to populate the four tables with data. Use the INSERT statements for the four tables only. Please note the statements to disable and later unable the constraints. Upload the Script files to Moodle. Task 2 Write an SQL query to create a view LOCATIONS_COUNTRIES with the columns from both tables. Query (using courier new)

          Task 1
Create two script files:
• Al_yourname_create_warehouse.sql
• Al_yourname_data_warehouse.sql
(for example, my answer is called Al_mila_create_warehouse.sql).
Change the comments (-- in the sql) and add your name and modification date/time)
Use the DDL script file Assignment1_schema.sql as an example to create required four
tables only. (please create each table separately and DO NOT RUN the entire script - this is
easier to find errors).
Use the DML script Assignment1_data.sql to populate the four tables with data. Use the
INSERT statements for the four tables only. Please note the statements to disable and later
unable the constraints.
Upload the Script files to Moodle.
Task 2
Write an SQL query to create a view LOCATIONS_COUNTRIES with the columns from
both tables.
Query (using courier new)

Task 1
Create two script files:
• Alyournamecreatewarehouse.sql
• Alyournamedatawarehouse.sql
(for example, my answer is called Almilacreatewarehouse.sql).
Change the comments (– in the sql) and add your name and modification date/time)
Use the DDL script file Assignment1schema.sql as an example to create required four
tables only. (please create each table separately and DO NOT RUN the entire script - this is
easier to find errors).
Use the DML script Assignment1data.sql to populate the four tables with data. Use the
INSERT statements for the four tables only. Please note the statements to disable and later
unable the constraints.
Upload the Script files to Moodle.
Task 2
Write an SQL query to create a view LOCATIONSCOUNTRIES with the columns from
both tables.
Query (using courier new)

Added by Carla H.

Question

Please give Ace some feedback