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
Crank
4 years ago
13

g Write an SQL statement to list all of the names of students who have not taken a classwith an instructorwho is a faculty of th

eComputer 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:
iogann1982 [59]4 years ago
4 0

Answer:

SELECT StudentFullname FROM Studentdata INNER JOIN Student_Class ON Studentdata.uniqueno = Student_Class.student_id LEFT JOIN Student_Instructor ON Student_Class.instructor_id = Student_Instructor.id WHERE Student_Instructor.faculty <> 'Computer Science'

Explanation:

Assume the following table names;

Studentdata - for student table

Student_Class - for each class

Student_Instructor - for student's instructors

The code first list out StudentFullname from studentdata table.

The code is the connected to Student_Class to get a list of students in class

The code is then connected to Student_Instructor table to get a list of instructors in class

Lastly, the where then filters instructors that are not from computer science department

You might be interested in
How have you improved the technology function to provide the right services at the right price and right level of quality?
kaheart [24]
What did you do? Write that as the first part
7 0
2 years ago
The formatting option functions like space bar. However instead of moving one space at a time, it allows you to move your text i
Schach [20]
What are the options???
4 0
3 years ago
The Web team you manage is designing a new Website for a company that wants to reach a specific audience. After discussing the c
____ [38]

Answer:

Cultural diversity

Explanation:

Cultural diversity can be described as having a variety of cultures in the same area.

Culture on its own means beliefs, customs, and traditions of a specific group of people. It simply means the way of life of a people.

Cultural diversity usually fosters cultural unity in most cases becsuse the different cultures always tend to do everything together.

The design plan that encourages the use of two or more languages and the use of a recommended colour in creating a webpage in a place that has multiple ethnic groups is cultural diversity approach. As this puts into consideration all the cultures in its design.

4 0
3 years ago
Happy Valentine's day!!
Lorico [155]
Happy valentine’s u too !!
7 0
2 years ago
What is a core in computer
Evgesh-ka [11]
<span>Hey there, this isn't really my part of town, I'm what you call a math freak, but here.

In relation to computer processors, a core is the processing kinda like a brain we ppl have, this is the unit that receives instructions and performs calculations, or actions, based on those instructions like when you click something. A set of instructions can allow a software program perform a specific function. Processors can have a single core or multiple cores that do many different things.
Hopefully i helped you, please mark brainly if possible.</span><span />
4 0
3 years ago
Read 2 more answers
Other questions:
  • What is typically unique in each database table?
    5·2 answers
  • What is the first step to creating a PivotTable?
    11·1 answer
  • What is Administrator windows 10
    8·1 answer
  • Heelo how do u do python syntax lesson 11 on code academy
    12·1 answer
  • Taking a group of recipes and identifying the similarities is an example of _____.
    13·1 answer
  • Which of the following statements is true for DMA: (only one correct answer) A. In DMA, Processor checks status until the operat
    9·1 answer
  • When working in outline mode, press __________ and click the eye icon to change only one layer back to preview mode.
    10·1 answer
  • Choose the answer that best completes the visual analogy.
    11·1 answer
  • The internet is ________. an internal communication system for businesses a large network of networks a communication system for
    6·1 answer
  • In the bremmer article, the author states that _________ translates into greater risks.
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!