A First Course in Database Systems 연습문제 2장 - 2

본 글은 데이터베이스 수업을 들으며 시험을 위해 A First Course in Database Systems 연습문제를 풀이한 글입니다. 일개 학부생이 적은 글(본 글은 답이 아닙니다. 참고용으로 사용하시길....)이므로 틀린 내용이 있을 수 있습니다. 만약 틀린 내용이 있으면 댓글이나 이메일 주시면 감사하겠습니다. 지적은 언제나 환영입니다. 

A First Course in Database Systems 책 사진

http://book.interpark.com/product/BookDisplay.do?_method=detail&sc.prdNo=257670552

싸니까 믿으니까 인터파크도서

---

위 책의 연습문제를 정리한 내용입니다. 

p49 4.1, p59 5.1

 

연습문제 4.1

a) What PC models have a speed of at least 3.00?

b) Which manufacturers make laptops with a hard disk of at least 100GB?

c) Find the model number and price of all products (of any type) made by

manufacturer B.

d) Find the model numbers of all color laser printers.

e) Find those manufacturers that sell Laptops, but not PC’s.

f)Find those hard-disk sizes that occur in two or more PC’s.

g) 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).

h) Find those manufacturers of at least two different computers (PC’s or laptops) with speeds of at least 2.80.

i) Find the manufacturer(s) of the computer (PC or laptop) with the highest available speed.

j) Find the manufacturers of PC’s with at least three different speeds.

k) Find the manufacturers who sell exactly three different models of PC.

 

연습문제 5.1

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 PC’s 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.