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
olga55 [171]
3 years ago
8

Considering the tables

Computers and Technology
1 answer:
MrRa [10]3 years ago
6 0

Answer:

a) SELECT COUNT(*)

FROM Supplies

WHERE sid=T OR sid=X;

b) SELECT sid

CASE

WHEN sid=IMB AND pid=T

THEN 'YES'

ELSE 'No'

END AS 'check'

FROM Supplies

c) SELECT pid

WHERE partname != computers

FROM Parts

LEFT JOIN Supplies

ON Parts.pid=Supplies.pid;

d) SELECT color

FROM Parts

WHERE pid=T;

Explanation:

a) Here we will use aggregate function along with WHERE and operators to count for specifc part ids

b) This is a CASE query

c) This is again a case query but invloves two separate tables. So, here 1st required values from 1st table are selected and then table is joined with the other table using OUTER JOIN

d) This is again a CASE query. It can be written by calling upon the all the values in one column corresponding to values in another column

You might be interested in
What is the maximum duration of daily scrum meetings A:15minsB:45minsC10mins:30mins
scoray [572]

Answer:

A

Explanation:

A common approach to a daily scrum (although not the only approach) is for each member of the development team to address the following three daily scrum questions:

1. What did I accomplish since the last daily scrum?

2. What do I plan to work on by the next daily scrum?

3. What are the obstacles or impediments that are preventing me from making progress?

Development teams are typically between five to nine people. Each development team member should need no more than 90 seconds to address the three questions listed above. So, if you had a team of nine people, each of whom took 90 seconds to cover the questions, combined with some overhead of getting the meeting started and transitioning from person to person, you would end up with a meeting duration of about 15 minutes.

To emphasize that 15 minutes should be thought of as a timeboxed limit.

8 0
3 years ago
Read 2 more answers
Read each of the following statements about Computer Science and explain why you think that statement is true.
larisa86 [58]

Answer:

sytaragadr

Explanation:

3 0
3 years ago
What is meant by usability and what characteristics of an interface are used to assess a system’s usability?
ahrayia [7]

Answer:

The answer is below

Explanation:

Usability is a term that describes the assessment of the performance of a system in assisting the task of the user, or how effective a certain product system or design supports the task of a user in accomplishing a set out objective as desired.

The characteristics of an interface that are used to assess a system’s usability are:

1. Effectiveness

2. Efficiency

3. Error Tolerance

4. Engagement

5. Ease of Learning and Navigation

3 0
3 years ago
There are two activities on your schedule, which are: 1) install server in lab 2) move server into the data center. however, the
astra-53 [7]
Quality Assurance or testing.
4 0
4 years ago
ABC inc. has built a large, normalized, relational database to capture current/historical data originating /copied from its tran
kow [346]

Answer:

"Datawarehouse" is the correct answer for the above question.

Explanation:

  • The Datawarehouse is a collection of large data or database which holds the historical data and the current or operation data for future decisions of the profit of the organization.
  • The decision can be made after being analyzed the data which is extracted from the Dataware house.
  • The above question also states the database which works like the above-defined concept. Hence Datawarehouse is the correct answer to the above question.
6 0
4 years ago
Other questions:
  • How can i put this sign in my keybord?<br><br> :::::<br> ^<br> Here is the sign
    8·1 answer
  • Write a program that a C++ program that can be used to determine grades at the end of the semester. For each student, who is ide
    12·2 answers
  • When computer manufacturers overcame the enormous 13,000 Chinese character barrier by creating a workable keyboard through voice
    15·1 answer
  • A company that wants to send data over the Internet has asked you to write a program that will encrypt it so that it may be tran
    6·1 answer
  • You are using a new release of an application software package. You think that you have discovered a bug. Outline the approach t
    14·1 answer
  • What sound signal tells another boater that you wish to pass on your starboard (right) side?
    15·1 answer
  • How are procedural and object-oriented programming approaches similar?
    14·1 answer
  • An administrator has just changed the IP address of an interface on an IOS device. What else must be done in order to apply thos
    5·2 answers
  • 1st person to answer gets brainliest for free after 5 mins I wont be handing out brainliest
    11·1 answer
  • Before entering an intersection, the safest searching process is to search ________. right, left, right, center left, center, ri
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!