Question: Need Tuple Relarion Calculus, Domain Relation Calulus, SQL, Datalog and Relational algebra for below schema Product(maker, model, type) PC(model, speed, ram, hd, price) Laptop(model, speed,
Need Tuple Relarion Calculus, Domain Relation Calulus, SQL, Datalog and Relational algebra for below schema
Product(maker, model, type)
PC(model, speed, ram, hd, price)
Laptop(model, speed, ram, hd, screen, price)
Printer(model, color, type, price)
Need Tuple Relarion Calculus, Domain Relation Calulus, SQL, Datalog and Relational algebra for below schema
a) A PC with a processor speed less than 2.00 must not sell for more than $500.
b) A laptop with a screen size less than 15.4 inches must have at least a 100 gigabyte hard disk or sell for less than $1000.
c) No manufacturer of PCs may also make laptops. d) A manufacturer of a PC must also make a laptop with at least as great a processor speed.
e) If a laptop has a larger main memory than a PC, then the laptop must also have a higher price than the PC.
f) Give the manufacturer and speed of laptops with a hard disk of at least thirty gigabytes.
g) Find the model number and price of all products (of any type) made by manufacturer B.
h) Find those manufacturers that sell Laptops, but not PCs.
i) Find those hard-disk sizes that occur in two or more PCs.
j) Find those pairs of PC models that have both the same speed and RAM. A pair should be listed only once; e.g., list (i,j) but not (j,i). !! f) Find those manufacturers of at least two different computers (PCs or laptops) with speeds of at least 3.0.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
