Computers and Technology, 22.02.2021 18:40 alwaysneedhelp84

Consider the following schema: Suppliers ( sid: integer, sname: string, address: string )
Parts ( pid: integer, pname: string, color: string )
Catalog ( sid: integer, pid: integer, cost: real )
The Catalog relation lists the prices charged for parts by Suppliers.

Write the following queries in SQL.

a. Find the pnames of parts for which there is some supplier.
b. Find the snames of suppliers who supply every part.
c. Find the snames of suppliers who supply every red part.
d. Find the sids of suppliers who supply only red parts.

5. Find the sids of suppliers who supply a red part and a green part.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 24.06.2019 02:00

Read the following scenario, and then answer the question below. you want to send an e-mail to your boss requesting a meeting to discuss a raise. what is the best example of an e-mail to an employer about this meeting? “hey jason. can we chat about getting me more money soon? let me know. peace, meg.” “hello jason. pardon me for sending yet another e-mail today about my need to talk to you about my position and a possible pay increase. i am dying to know when you can talk. sincerely, meg.” “hello jason. i have been with the company for one year and have taken on more responsibilities than outlined in my job description. i would appreciate an opportunity to speak with you about my position. let me know when we can schedule a meeting. you, meg.” “greetings jason! i hope this e-mail finds you well and happy today. i really, really want to talk to you about something important. i am not sure if you have time. i hope you do. get back in touch with me and let me know when we might talk. ever so much for taking the time to read this. sincerely, meg.”

Answers: 3

Answer

Computers and Technology, 24.06.2019 03:30

It is not necessary to develop strategies to separate good information and bad information on the internet. true or false

Answers: 1

Answer

Computers and Technology, 24.06.2019 10:50

In 2009 to 2010, how many social network users were reported as being victims of online abuse? a. 1 in 10 b. 100% c.1 in 100 d. 50%

Answers: 2

Answer

Computers and Technology, 24.06.2019 12:50

Write a new lc-3 trap subroutine (i.e. a subroutine that will be invoked via the trap instruction) that will receive a numeric digit entered at the keyboard (i.e. an ascii character), echo it to the screen, and return in r0 the corresponding numeric value: so if the user types the digit '7', the character '7' will appear on the screen, but the value returned in r0 will be b0000 0000 0000 0111 (#7) you may not use any trap calls in your code - you must implement the "polling" code that interrogates the keyboard status and data registers. ; getnum_tsr ; a subroutine for obtaining a numeric value ; given ascii numeric digit input to keyboard. ; the numeric digit is echoed to the console (e.g. '7' = b0000 0000 0011 0111), ; but the value returned in r0 is the actual numeric value ; corresponding to the digit (e.g. b0000 0000 0000 0111 =

Answers: 3

Answer

You know the right answer?

Consider the following schema: Suppliers ( sid: integer, sname: string, address: string )
Par...

Questions