Lab Work 5.pdf - International Information Technology University Information Systems Department Lab Work 5 QUERYING THE DATABASE 4 March 10 am

Lab Work 5.pdf - International Information Technology...

This preview shows page 1 - 3 out of 4 pages.

International Information Technology University, Information Systems Department Lab Work 5. QUERYING THE DATABASE 4 March, 10 am INTRODUCTION This exercise will cover a variety of queries you can accomplish using SQL’s SELECT statement. If you have completed Exercises 1 and 2 then your database should contain tables for Artist and CD records. In order to add some variety for the queries, we shou ld add a few more CDs. If you’d like more practice with INSERT and UPDATE operations then try to match your tables to these: SELECT * FROM Artist;
Image of page 1