Question: It is SQL quries. Please solve the question by the hand. Task 2: Consider the following tables. Table name: Customers_of_an_organization Column Name Data Type Constraint

It is SQL quries. Please solve the question by

It is SQL quries. Please solve the question by the hand.

Task 2: Consider the following tables. Table name: Customers_of_an_organization Column Name Data Type Constraint Customer_ID Integer NOT NULL, Primary key Varchar NOT NULL Customer_Name Customer_Phone Integer NOT NULL Customer_Address varchar Table Name: Orders_Placed_by_Customers Column Name Data Type Constraint Order_ID Integer NOT NULL, Primary key Order_Description varchar NOT NULL DEFAULT SYSTEM DATE Order_Date Date Customer_who_placed_order Integer FOREIGN KEY, REFERENCES Customer ID of the table Customers_of_an_organization Fundamentals of Relational Database Management Systems (COMP-20002) - Summer-2020 -CW2 Assignment) -ALL-QP Total_Amount_of_Order Number with NOT NULL decimal point Write SQL Statements to: a create the above two tables as per the given specification and display the structure of thus created tables. (6 marks) b. insert three customers into the customers of an organization table and display the inserted rows (6 Marks) place five orders into the table Orders placed_by_Customers such that 3 orders belong to one customer, 2 orders belong to another customer and 1 order belonging to last the customer. Display the thus inserted rows. (6 Marks) d display order details of all customers who have placed more than 1 order (6 Marks) e display total amount of all the orders placed by each of the customer. Output should be displayed in increasing order of the total amount. (6 marks)

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 General Management Questions!