Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Multimedia Database Systems

Authors: V.S. Subrahmanian

1st Edition

1558604669, 978-1558604667

More Books

Students also viewed these Databases questions