chapter2.4习题2.4.1

Exercise2.4.1(a-g) 欢迎指正

• What PC model have a speed of at least 3.00?
  $\pi_{model}(\sigma_{speed \geq3.00}(PC))$
• Which manufactures make laptops with a hard disk of at least 100GB?
  $P(maker, model) = \sigma_{type = 'laptop'}(Product)$
  $L(model, hd) = \sigma_{hd\geq100}(Laptop)$
  $S(maker) = \pi_{maker}(P \bowtie L)$
• Find the model number and price of all products(of any type) made by manufacturer B
  $R_1(model) = \pi_{model}(\sigma_{maker = 'B'}(Product))$
  $R_2(model, price) =\pi_{model,price}(PC)$
  $R_3(model, price) =\pi_{model,price}(Laptop)$
  $R_4(model, price) =\pi_{model,price}(Printer)$
  $R_5(model, price) = R_2\cup R_3 \cup R_4$
  $R_6(maker)= \pi_{maker}(R_1 \bowtie R_5)$
• Find the model numbers of all color laser printers
  $\sigma_{color = 'true'\; AND\;type = 'laser' }(Printer)$
• Find those manufacturers that sell Laptops, but not PC
  $R_1(maker)=\pi_{maker}(\sigma_{type = 'pc'}(Product) )$
  $R_2(maker)=\pi_{maker}(\sigma_{type ='laptop'}(Product))$
  $R_3(maker) = R_2-R_1$
• Find those hard-disk sizes that occur in two or more PC
  $R_1 = \rho_{R_{11}}(PC) \times \rho_{R_{12}}(PC)$
  $R_2(hd)=\pi_{hd}(\sigma_{R_{11}.hd=R_{12}.hd \cap R_{11}.model \neq R_{12}.model}(R_1))$
• 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)
  $R_1={\rho_{PC1}(PC)\times\rho_{PC2}(PC)}$
  $\pi_{PC_1.model,PC_2.model}(\sigma_{{PC_1.ram=PC_2.ram \cap PC_1.speed=PC_2.speed \cap PC_1.model>PC_2.model}}(R_1))$