1. Create the IMPORT_SALES_XX table based on the old Sales table 2. Create the IMPORT_MGRS_XX table based...
Question:
1. Create the IMPORT_SALES_XX table based on the old Sales table
2. Create the IMPORT_MGRS_XX table based on the old Managers table
3. Create the IMPORT_OE_XX table based on the old Operational Expenses table
4. Create a SELECT that joins the previous three IMPORT tables together
SELECT OldColumn1 AS NewColumn1,
OldColumn2 AS NewColumn2,
...
OldCoumnN AS NewColumnN
FROM ...
5. Confirm each new column name alias in your SELECT is unique
6. Add to your SELECT the PrimaryID column and then each table primary ID column name from each table in your database design diagram. Use NULL AS TableID. For instance:
SELECT ROWNUM AS PrimaryID,
NULL AS EmployeeID,
NULL AS CustomerID,
...
7. Create the IMPORT_ALL_XX table where XX is your initials using CREATE TABLE then adding your SELECT
CREATE TABLE IMPORT_ALL AS
-- your select goes here
8. Create the IMPORT_ALL_XX table where XX is your initials using CREATE TABLE then adding your SELECT
Fundamentals of Corporate Finance
ISBN: 978-0133400694
1st canadian edition
Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford, David A. Stangeland, Andras Marosi