













Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Material Type: Notes; Class: 198 - PRIN INFO & DATA MGT; Subject: COMPUTER SCIENCE; University: Rutgers University; Term: Unknown 1989;
Typology: Study notes
1 / 21
This page cannot be seen from the preview
Don't miss anything!
sid name login age gpa 53666 Jones jones@cs 18 3. 53688 Smith smith@eecs 18 3. 53650 Smith smith@math 19 3.
TELL INFORMATION MANAGER ASK
DEFINE
insert into books values ('0-672-31697-8', 'Michael Morgan', 'Java 2 for Professional Developers', 34.99);
SELECT author,title FROM books WHERE price > 30;
author title Michael Morgan
Java 2 for Professional Developers
... …
create table nullness ( id integer primary key, stuff text );
insert into nullness values (null, "you lose");
delete from books where isbn='0-672-31697-8‘
select C.name, O.isbn from customers C, order_items O
select C.name, I.isbn from customers C, orders O, order_items I where C.customerid = O.customerid and O.ordernumber = I.orderid
condition ( R )
select * from S where rating > 8
rating 8 ( S )
columns ( R )
select sname, rating from S
sname rating , ( S )
R Ä R. i S i. S
(^) c d ( S ) (^) c ( (^) d ( S ))
(^) c ( (^) d ( S )) (^) d ( (^) c ( S ))
(^) c ( (^) d ( S )) c ( S )