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
What is the code i need to do
Greeley [361]
What section is it? I did the same thing a bit ago on edhesive
3 0
3 years ago
In most languages, if a file does not exist and a program attempts to open it in append mode, what happens?
chubhunter [2.5K]

Answer:

It create a new file in which writing of data begins.

Explanation:

A file can be open in the three mode:

-r (Read mode): open an existing file for the purpose of reading data from it.

-w (write mode): Create a new file for the purpose of writing data to it.

-a (append mode): open an existing file for the purpose of appending extra data to it but if the file does not exist, it create a new file and start writing data to it.

5 0
4 years ago
Arrange the binary number in increasing order of their arithmetic output in the decimal number system ?
tiny-mole [99]
I think the order would be

10010001-1000001 (as the biggest amount)
100101100/101
10011x101
10010x11
10100+10101 (as the least amount)

hope this helps! :)
6 0
3 years ago
What are the differences between tkinter toolkit and PyQt?
lesantik [10]

Answer:

See the explanation  

Explanation:

tkinter toolkit                                            

  • Easy to use
  • Easy to learn
  • Easy to debug
  • Good for simple tasks
  • TkInter applications are simpler as compared to PyQt because it is included in standard Python distribution.
  • Faster than PyQt.
  • Does not have advanced widgets.
  • No interface builder available.
  • Free for commercial utilization.

PyQt

  • More flexible in terms of coding.
  • Harder to debug as compared to tkinter
  • GUI is clearer in display than tkinter
  • Widgets are more interactive than that of tkinter
  • size of a PyQt program is larger than that of tkinter
  • uses a variety of paltform APIs and gives primary access to these APIs through a unique API.
  • Has an interface builder that allows to design interfaces without writing any code.
  • Has modern widgets.
  • Due to its vast interface and several UI components it is a bit confusing to learn as compared to tkinter.
  • Commercial license is required to release the code.
  • Cross-platform and native GUI.

Widgets are GUI components such as buttons, labels, menus.

a) Label

This is a tkinter widget to show the text or image on the screen. It looks like a display box. The user can easily edit or update label.

For example to display a label with text "Hello World" the following chunk of code is used:

import tkinter

widget = tkinter.Tk()

label =tkinter.Label(widget, text="Hello World")

label.pack()

tkinter.mainloop()

b) Entry

This is a tkinter widget to accept the text input from user. For example if you want to get a single line text from user then you can use Entry widget. The code below displays an entry widget with the message: Enter input text: Here the user can input the text.

import tkinter

widget = tkinter.Tk()

entry = tkinter.Entry(widget)

entry.insert(0, "Enter input text:")

entry.pack()

tkinter.mainloop()

c) Button

This is a tkinter widget to add a button in an application. You can enter some text or an image in this button convey its purpose. When you click on the button a function is called or an event is emitted.

The following chunk of code displays a button with the text "Click Me" on the button.

import tkinter

widget = tkinter.Tk()

button = tkinter.Button(widget, text="Click Me")

button.pack()

tkinter.mainloop()

d) Frame

This is a tkinter widget to group together and organize other widgets and arranges their position.

The following chunk of code displays an outer frame with a label with text "parent label" and an inner frame with a label of text "child frame".

import tkinter

widget = tkinter.Tk()

frame = tkinter.LabelFrame(widget,text="parent frame")  

label= tkinter.Label(frame,text="child frame")

frame.pack(padx=10, pady=10)

label.pack()

tkinter.mainloop()

5 0
4 years ago
The space where text and content is entered and positioned for onscreen reading or printing
tino4ka555 [31]

Answer:

Page.

Explanation:

A page typically occupies the largest portion of a document layout as it houses the main writeup or content of the document. The text contained in a document is written on a the main page of the document. The main page is surrounded by the page margin, which is an area which separates the tips or edges of an entire papwr and the writing area (page) of the document. The insertion point refers to an indicator which shows the position which a typed character will fall or be placed. Content written on a document's page is what is printed when the document is to be printed out and test entered on the page are what is seen by the reader.

4 0
3 years ago
Other questions:
  • What is the error and why is there an error in the code below?
    14·1 answer
  • Why shouldn't a server use a glass to scoop ice?
    6·2 answers
  • WILL GIVE MEDAL NEED HELP ASAP
    7·1 answer
  • The ____ layer protocols are the rules for implementing end-user services provided by a network. Transport Application Physical
    11·1 answer
  • Decision support systems (or DSSs) model information using OLAP, which provides assistance in evaluating and choosing among diff
    7·1 answer
  • Explain why the computer is powerful working tool???​
    7·1 answer
  • What sort of technique would you use to sort 10,000 items using just 1000 available slot in your RAM?
    6·1 answer
  • Marissa is designing a web page that features lessons on how to build cabinets. how can she make the page most engaging for the
    7·1 answer
  • Write a program which will -
    14·1 answer
  • when doing a complex presentation which of the fallowing will be the best tool to begin designing your presentation
    12·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!