Computers and Technology, 11.02.2020 17:28, asaadasaadasaad6524

Write the following queries in SQL based on the following schema:COP5725 - Spring 2011• Product(maker, model, type)• PC(model, speed, ram, hd, price)• Laptop(model, speed, ram, hd, screen, price)• Printer(model, color, type, price)a) Give the manufacturer and speed of laptops with a hard disk of at least 30 gigabytesSELECT R. maker AS manufacturer, L.speed AS gigahertzFROM Product R, Laptop LWHERE L. hd>= 30AND R. model = L. modelAND R. type= ‘laptop’;b) Find the model number and price of all products (of any type) made by manufacturer 'B'SELECT R. model, P. price FROM Product R, PC PWHERE R. maker= 'B‘ AND R. model = P. modelUNIONSELECT R. model, L. price, FROM Product R, Laptop LWHERE R. maker= 'B‘ AND R. model = L. modelUNIONSELECT R. model, T. price FROM Product R, Printer TWHERE R. maker= 'B’ AND R. model = T. model ;c) Find those manufacturers that sell Laptops, but no PC'sSELECT R. makerFROM Product R, Laptop LWHERE R. model = L. model and R. Type= ‘Laptop’EXCEPTSELECT R. makerFROM Product R, PC PWHERE R. model = P. model and R. Type= ‘PC’ ;d) Find those hard-disk sizes that occur in two or more PC'sSELECT DISTINCT P1.hdFROM PC P1, PC P2WHERE P1.hd = P2.hd AND P1.model > P2.model ;Alternate SELECT DISTINCT P. hdFROM PC PGROUP BY P. hdHAVING COUNT(*) >= 2 ;

Answers: 2

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 23:50, Emptypockets451

You need to design a circuit that implements the functions in the following table: s0 s1 function0 0 a + 10 1 a – b1 0 a + b1 1 a – 1s0 and s1 are 1-bit control inputs to select the function of the circuit. inputs a and b are 4-bitnumbers in 2s complement form. the output is also a 4-bit number in 2s complement form. you are allowed to use only one ttl 7483 4-bit adder to implement all the functions. but anynumber of other components (except the adder) can be used. hint: design a combinational logic circuit to modify the input b and the “carry input” of theadder depending on the control inputs s0 and s1.important: lab grade will depend on the working of the circuit & will be checked of by your labinstructor.1. is the output valid for the following input combinations: a. s0 = 0, s1 = 0, a = 7, b = 3? b. s0 = 0, s1 = 1, a = 7, b = 3? c. s0 = 1, s1 = 0, a = -4, b = -5? d. s0 = 1, s1 = 1, a = -8, b = 6? 2. what is the range of inputs (for both a and b) that will produce the valid output for all the functions?

Answers: 3

continue

Computers and Technology, 24.06.2019 20:30, lowwlifelivv

Where is permanent data in the computer stored whenever gym starts his laptop he sees some commands in numbers appearing on the screen these instructions are being preceded by the control unit in

Answers: 1

continue

Computers and Technology, 24.06.2019 21:30, erickamiles1797

How do i copy and paste equations and pictures like math graphs, to post on this site to get my questions answered?

Answers: 2

continue

Computers and Technology, 25.06.2019 06:00, tay8556

Write a method public static string getdigits(string phonenumber) that takes an 11-character phone number written with any combination of 11 uppercase letters, lowercase letters and/or digits, and zero or more hyphens, and which returns the digits that a person would have to press on a cell phone to dial that phone number. we will use the mapping of letters to digits given at en. wikipedia. org/wiki/telephone_keypad# /media/file: telephone-keypad2.svg you may assume that the string parameter phonenumber contains some combination of exactly 11 uppercase letters, lowercase letters and/or digits, but that any number of hyphens may be present. you can assume that a hyphen will not appear as the first or last character of the string. do not assum

Answers: 3

continue

Do you know the correct answer?

Write the following queries in SQL based on the following schema:COP5725 - Spring 2011• Product(make...