1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
horsena [70]
3 years ago
11

g (15 points) Write an SQL statement to list all of the names of students who have not taken a classwith an instructorwho is a f

aculty of theComputer Sciencedepartment. Constraints:-Useat least one outer join,-Use natural joins and using conditions, exclusively, as the join conditions,-Do not use any other kinds of joins (i.e no cross products etc.)
Computers and Technology
1 answer:
Blizzard [7]3 years ago
3 0

Answer:

<em>SQL Query</em>

//////////////////////////////////////////////////////////////////////////////////////////////////

select student_name from Student

INNER JOIN Class ON Student.id = Class.student_id

LEFT JOIN Instructor ON Class.instructor_id = Instructor.id

WHERE Instructor.school <> 'Computer Science'

Explanation:

First thing is to select the student_name from <em>Student</em> table.

Next we need to connect with the <em>Class</em> table to get all Students currently taking classes.

Next we need to connect the <em>Class</em> table with the <em>Instructor</em> table, to get all of the Instructors currently teaching class(s).

Finally, we place the Where condition for the acquired instructors to not be from the Computer Science department.

You might be interested in
Which of the following should businesses and organizations do to promote a safe work environment?
nlexa [21]
<span>The correct answer should be A.Hold managers, supervisors, and employees for meeting their own responsibilities. The policies should be changed more often than every 10 years, and definitely the workers should be involved because the workers know better what is problematic than managers who sit in offices in suits and aren't exposed to dangerous activities.</span>
8 0
3 years ago
What is a device driver
Elan Coil [88]

A device driver is a computer program that operates or controls a particular type of device that is attached to a computer.

5 0
3 years ago
Because log-on procedures may be cumbersome and tedious, users often store log-on sequences in their personal computers and invo
diamong [38]

Answer:(C) Anyone with access to the personal computers could log on to the mainframe.

Explanation:

It is no doubt that log on procedures are cumbersome so what most users do is that they store log on sequences in their computer so that they could use the main frame facilities whenever they access it the second time.

Here we have to identify the associated risk with this approach.

This process could lead to access of the computer system to users and thereby making all the data available in the system vulnerable. So option C is correct.

option (A) is incorrect as the back up option who also be affected when the system is accessible to anyone.

option (B) is incorrect because it has nothing to do anything with training of the personnel.

option (D) is incorrect because it one has nothing to do with the physical system what vulnerable reside is inside the system.

7 0
3 years ago
Print "Censored" if userInput contains the word "darn", else print userInput. End with newline. Ex: If userInput is "That darn c
Alisiya [41]

Answer:

The Java code is given below

Explanation:

import java.util.*;

public class CensoredWords {

public static void main(String args[]) {

Scanner scnr=new Scanner(System.in);

String userInput;

System.out.println("Enter String: ");

userInput=scnr.nextLine();

int res=userInput.indexOf("darn");

if(res == - 1) {

System.out.println(userInput);

} else {

System.out.println("Censored");

}

}

}

8 0
4 years ago
Please Help!
tatyana61 [14]

Answer:

Its B,D,E

Explanation:

Got it right on e2020

5 0
3 years ago
Other questions:
  • Can i use both PLA and TPE or TPU for a single unit 3d printed prototype?
    13·1 answer
  • URGENT!! Which graphic design tools help you draw circles and rectangles?
    12·2 answers
  • When parallel sections of oxygen and fuel gas hoses are taped together, only _____ inches out of 12 inches should be covered by
    8·2 answers
  • Do {
    12·1 answer
  • Below is a recursive implementation of the factorial function. For what value of n will this function not produce the desired re
    8·1 answer
  • Keith is researching a controversial topic and wants to use a website he found as an information source. Which of the following
    11·2 answers
  • Which are three possible text formatting actions in wordpad?
    6·1 answer
  • Which type of storage disk and disk drive can you use in the given situation?
    9·1 answer
  • Fill in the blank to complete the sentence.
    8·1 answer
  • missy just hired a software development team to create an educational simulation app for a high school course. she has specific
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!