-Käyttäjä etsii kirjaa sen nimen perusteella (esimerkiksi Web-sivun avulla)
SELECT title, description, state, reserve_time, borrow_time, home_office_name, current_office_name FROM Item, ItemInfo WHERE title LIKE '%Potter%';

-Asiakas lainaa kirjan
CASE (SELECT state FROM Item WHERE id = '1234123412341234')
	WHEN 'free' THEN
		(UPDATE Item SET state = 'borrowed' WHERE id = '1234123412341234'
		INSERT INTO BorrowedBy (item_id, customer_ssno, borrow_date, return_date)
		VALUES ('1234123412341234', '123456-1234', (datetime('now','localtime')), NULL));

-Asiakas palauttaa kirjan
UPDATE BorrowedBy SET return_date = (datetime('now','localtime')) WHERE (item_id = '1234123412341234') AND (customer_ssno = '123456-1234') AND (return_date IS NULL)
UPDATE Item SET state = 'free' WHERE id = '1234123412341234S';

-Lainattava esine (kirja/cd/dvd jne.) poistetaan huonon kuntonsa vuoksi
DELETE FROM Items WHERE id = '1234123412341234';