Question: Provide only SQL commands as a solution. Exercise: 1:Create the following tables and insert data in to the tables- Student info: DEPARTMENT_ID Stu_name Stu_address 10

 Provide only SQL commands as a solution. Exercise: 1:Create the following

tables and insert data in to the tables- Student info: DEPARTMENT_ID Stu_name

Provide only SQL commands as a solution.

Exercise: 1:Create the following tables and insert data in to the tables- Student info: DEPARTMENT_ID Stu_name Stu_address 10 Asif Dhaka 20 Ana Sylhet 30 Bobi Rajshahi 40 Rupa Dhaka 50 Asif Dhaka 60 Robi Khulna 70 Nazrul Khulna 80 Ovi Barisal Employees: Course_id ECE-105 ECE-465 ECE-105 ICE-301 ICE-301 ICE-245 ECE-465 ICE-245 LAST_NAME Getz Davis King Davis Kochhar DEPARTMENT_ID 10 20 20 30 SALARY 3000 1500 2200 5000 7000 40 Departments: DEPARTMENT_ID Sales Marketing Accounts Administration DEPARTMENT_NAME 10 20 30 40 2.Using syntax of join or inner join Show the DEPARTMENT_ID of both Employees and Departments

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!