Question: I have sent two questions please send answer within 1hr Merge the Above mentioned two tables and load all the data into Cust_Merge table. Create

 I have sent two questions please send answer within 1hr Merge

I have sent two questions please send answer within 1hr

Merge the Above mentioned two tables and load all the data into Cust_Merge table. Create Cust_Merge table in your database by including column names given below: Columns of the Cust_Merge table:- Orderid, CustomerID, CustomerName, Address, City, PostalCode, Employeeld, OrderDate (50 Marks] 3. Create another two table with the same columns as per the Cust_Merge and give the Cust_Merge_Colombo and Cust_Merge_Gampaha names for each of the created tables. Based on the Cust_Merge table's data, load into Cust_Merge_Colombo table the customers who live in Colombo and load into Cust_Merge_Gampaha table the customers who live in Gampaha. [25 Marks] [Total Marks : 100] Merge the Above mentioned two tables and load all the data into Cust_Merge table. Create Cust_Merge table in your database by including column names given below: Columns of the Cust_Merge table:- Orderid, CustomerID, CustomerName, Address, City, PostalCode, Employeeld, OrderDate (50 Marks] 3. Create another two table with the same columns as per the Cust_Merge and give the Cust_Merge_Colombo and Cust_Merge_Gampaha names for each of the created tables. Based on the Cust_Merge table's data, load into Cust_Merge_Colombo table the customers who live in Colombo and load into Cust_Merge_Gampaha table the customers who live in Gampaha. [25 Marks] [Total Marks : 100]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!