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
Mariana [72]
3 years ago
13

Write SQL queries to answer the following questions: What are the names of the course(s) that student Altvater took during the s

emester I-2018? List the names of the students who have taken at least one course that Professor Collins is qualified to teach. List the names of the students who took at least one course with ""Syst"" in its name during the semester I-2018.

Engineering
1 answer:
amm18123 years ago
6 0

Answer:

See explanations

Explanation:

Consider the following Venn diagram to retrieve the name of course that student Altvater took during semester I-2015.

• In above Venn diagram inner Ellipse represent the subquery part, this subquery part select the Student ID from STUDENT table.

• Second sub query is used to determine the SectionNo of all student whose studentID retrived in the first subquery

• Finally the main query displays the CourseName from COURSE table.

You might be interested in
La probabilidad de que un nuevo producto tenga éxito es de 0.85. Si se eligen 10 personas al azar y se les pregunta si compraría
liq [111]

Answer:

La probabilidad pedida es 0.820196

Explanation:

Sabemos que la probabilidad de que un nuevo producto tenga éxito es de 0.85. Sabemos también que se eligen 10 personas al azar y se les pregunta si comprarían el nuevo producto. Para responder a la pregunta, primero definiremos la siguiente variable aleatoria :

X: '' Número de personas que adquirirán el nuevo producto de 10 personas a las que se les preguntó ''

Ahora bien, si suponemos que la probabilidad de que el nuevo producto tenga éxito se mantiene constante (p=0.85) y además suponemos que hay independencia entre cada una de las personas al azar a las que se les preguntó ⇒ Podemos modelar a X como una variable aleatoria Binomial. Esto se escribe :

X ~ Bi(n,p) en donde ''n'' es el número de personas entrevistadas y ''p'' es la probabilidad de éxito (una persona adquiriendo el producto) en cada caso.

Utilizando los datos ⇒ X ~ Bi(10,0.85)

La función de probabilidad de la variable aleatoria binomial es :

p_{X}(x)=P(X=x)=\left(\begin{array}{c}n&x\end{array}\right)p^{x}(1-p)^{n-x}    con x=0,1,2,...,n

Si reemplazamos los datos de la pregunta en la función de probabilidad obtenemos :

P(X=x)=\left(\begin{array}{c}10&x\end{array}\right)(0.85)^{x}(0.15)^{10-x} con x=0,1,2,...,10

Nos piden la probabilidad de que por lo menos 8 personas adquieran el nuevo producto, esto es :

P(X\geq 8)=P(X=8)+P(X=9)+P(X=10)

Calculando P(X=8), P(X=9) y P(X=10) por separado y sumando, obtenemos que P(X\geq 8)=0.820196

7 0
3 years ago
Where do greywater pipes generally feed into?
Mekhanik [1.2K]

Answer:

c   Waste stack

Explanation:

7 0
3 years ago
PLEASE HELP!! Its easy!!!
Rina8888 [55]

Answer:

C is tire

F is cassette

D is hub

4 0
3 years ago
Read 2 more answers
Six housing subdivisions within a city area are target for emergency service by a centralized fire station. Where should the new
Marina86 [1]

Answer:

Explanation:

Since there are six points, the minimum distance from all points would be the centroid of polygon formed by A,B,C,D,E,F

To find the coordinates of centroid of a polygon we use the following formula. Let A be area of the polygon.

C_{x}=\frac{1}{6A} sum(({x_{i} +x_{i+1})(x_{i}y_{i+1}-x_{i+1}y_{i}))     where i=1 to N-1 and N=6

C_{y}=\frac{1}{6A} sum(({y_{i} +y_{i+1})(x_{i}y_{i+1}-x_{i+1}y_{i}))

A area of the polygon can be found by the following formulaA=\frac{1}{2} sum(x_{i} y_{i+1} -x_{i+1} y_{i}) where i=1 to N-1

A=\frac{1}{2}[ (x_{1}  y_{2} -x_{2}  y_{1})+ (x_{2}  y_{3} -x_{3}  y_{2})+(x_{3}  y_{4} -x_{4}  y_{3})+(x_{4}  y_{5} -x_{5}  y_{4})+(x_{5}  y_{6} -x_{6}  y_{5})]

A=0.5[(20×25 -25×15) +(25×32 -13×25)+(13×21 -4×32)+(4×8 -18×21)+(18×14 -25×8)

A=225.5 miles²

Now putting the value of area in Cx and Cy

C_{x} =\frac{1}{6A}[ [(x_{1}+x_{2})(x_{1}  y_{2} -x_{2}  y_{1})]+ [(x_{2}+x_{3})(x_{2}  y_{3} -x_{3}  y_{2})]+[(x_{3}+x_{4})(x_{3}  y_{4} -x_{4}  y_{3})]+[(x_{4}+x_{5})(x_{4}  y_{5} -x_{5}  y_{4})]+[(x_{5}+x_{6})(x_{5}  y_{6} -x_{6}  y_{5})]]

putting the values of x's and y's you will get

C_{x} =15.36

For Cy

C_{y} =\frac{1}{6A}[ [(y_{1}+y_{2})(x_{1}  y_{2} -x_{2}  y_{1})]+ [(y_{2}+y_{3})(x_{2}  y_{3} -x_{3}  y_{2})]+[(y_{3}+y_{4})(x_{3}  y_{4} -x_{4}  y_{3})]+[(y_{4}+y_{5})(x_{4}  y_{5} -x_{5}  y_{4})]+[(y_{5}+y_{6})(x_{5}  y_{6} -x_{6}  y_{5})]]

putting the values of x's and y's you will get

C_{y} =22.55

So coordinates for the fire station should be (15.36,22.55)

5 0
3 years ago
Technician A says a solenoid is not used on modern automobiles. Technician B says fuel injectors and starter motor solenoids are
julia-pushkina [17]

Answer:

ON THE BOTTOM

Explanation:

red cord plus black cord

5 0
3 years ago
Other questions:
  • Explain the differences between 1- Energy 2- Power 3- Work 4- Heat Your answer should explain the mathematica and physical meani
    5·1 answer
  • A 2-cm-diameter vertical water jet is injected upward by a nozzle at a speed of 15 m/s. Determine the maximum weight of a flat p
    10·1 answer
  • The reverse water-gas shift (RWGS) reaction is an equimolar reaction between CO2 and H2 to form CO and H2O. Assume CO2 associati
    10·1 answer
  • Calculate the number of vacancies per cubic meter for some metal, M, at 749°C. The energy for vacancy formation is 0.86 eV/atom,
    5·1 answer
  • Is a compass a analog or a digital sensor?
    14·1 answer
  • Can someone please help me with this <br>I've an exams tomorrow ​
    7·1 answer
  • Cup-sveg-aph<br><br>I m finding gf<br><br>if anyone interested pls come​
    11·2 answers
  • IF A CAR AHEAD OF YOU HAS STOPPED AT A CROSSWALK, YOU SHOULD:
    12·1 answer
  • What energy does a curcuit board run on
    11·2 answers
  • Water flow enters a pipe at a velocity of 1m/s. The pipe inlet is 10cm. The pipe outlet is 6cm. 1. Determine the velocity of the
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!