Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME ELC D102 D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE S103 Hisham 6/1/1999 Male 90 D102 A102 Level 1 22 12/30/1994 Female 45 D103 Diploma Dipioma S102 Sara A104 27 S101 Salim 6/1/1999 Male 45 D103 A104 22 S/6/1995 Male 10/15/1992 Male S107 Khalil 45 D101 A101 BTech 26 S109 Said 45 D104 A101 Advanced Diploma 29 45 D101 S/1/1995 Male 4/5/1998 Male $100 Ahmad A103 STech 26 S104 Faisal 90 D104 A101 Advanced Diploma 23 Fatima 2/23/1992 Female 90 D102 A102 Level 2 Level 3 | Dipioma $105 29 S106 Arwa 9/12/1999 Female 45 D102 A102 22 8/13/1991 Female 90 D103 S108 Ibtisam A104 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of all students who belong to BSD department with the USING clause 3. Display the advisor name, student name and gender for all students who belong to Level 1, Level 2 or Level 3 by using the FROM clause 4. Display the department name and allowance of students 5. Display the advisor name, student name and department name
Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME ELC D102 D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE S103 Hisham 6/1/1999 Male 90 D102 A102 Level 1 22 12/30/1994 Female 45 D103 Diploma Dipioma S102 Sara A104 27 S101 Salim 6/1/1999 Male 45 D103 A104 22 S/6/1995 Male 10/15/1992 Male S107 Khalil 45 D101 A101 BTech 26 S109 Said 45 D104 A101 Advanced Diploma 29 45 D101 S/1/1995 Male 4/5/1998 Male $100 Ahmad A103 STech 26 S104 Faisal 90 D104 A101 Advanced Diploma 23 Fatima 2/23/1992 Female 90 D102 A102 Level 2 Level 3 | Dipioma $105 29 S106 Arwa 9/12/1999 Female 45 D102 A102 22 8/13/1991 Female 90 D103 S108 Ibtisam A104 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of all students who belong to BSD department with the USING clause 3. Display the advisor name, student name and gender for all students who belong to Level 1, Level 2 or Level 3 by using the FROM clause 4. Display the department name and allowance of students 5. Display the advisor name, student name and department name
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Transcribed Image Text:Table name: ADVISORS
ADVISORID
ADVISORNAME
A102
Sami
A103
Alice
A104
Suad
A105
Tamil
A101
Arun
Table name: DEPARTMENTS
DEPTID DEPTNAME
D102
ELC
D101
IT
D103
BSD
D104
ENG
Table name: STUDENTS
STUDENTID
STUDENTNAME
DOB
GENDER
ALLOWANCE
DEPTID
ADVISORID
STUDENTLEVEL
AGE
Hisham
6/1/1999 Male
90 D102
S103
A102
Level 1
22
12/30/1994 Female
45 D103
S102
Sara
A104
Diploma
27
S101
Salim
6/1/1999 Male
45 | D103
A104
Diploma
22
5107
Khalil
5/6/1995 Male
45 D101
A101
Blech
26
45 | D104
Advanced Diploma
S109
Said
10/15/1992 Male
A101
29
5/1/1995 Male
45 D101
90 D104
5100
Ahmad
BTech
Advanced Diploma
A103
26
4/5/1998 Male
2/23/1992 Female
9/12/1999 Female
S104
Faisal
A101
23
0 D102
45 D102
S105
Fatima
90
A102
Level 2
29
S106
Arwa
A102
Level 3
22
S108
Ibtisam
8/13/1991 Female
90 D103
A104
Diploma
30
Write the SQL statement for the following:
1. Using the ON clause, display the advisor name and student name for all students in the BTech
level
2. Display the student name, gender and department name of all students who belong to BSD
department with the USING clause
3. Display the advisor name, student name and gender for all students who belong to Level 1, Level
2 or Level 3 by using the FROM clause
4. Display the department name and allowance of students
5. Display the advisor name, student name and department name
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education