Project #3

1) Page 186 example 6.18 c) d) e) f) and g). Write relational algebra query and draw expression tree corresponding to each question.

2) Create Library database for tables given in Fig 6.12 in Access or other DB software. Populate tables with data and answer the same questions in SQL.

For question 2 submit:

Screenshots of tables populated with data and results of each query.

Printout of queries in standard SQL.

Database saved on floppy or CD.

· CS580 students should also do additional examples on pages 580-581

17.22 c), d)

17.23

17.24