Structured Query Language - SQL

lab notes

Exercise1 Consider the following schema:

    Suppliers( sid: integer, sname: string, address: string );

    Parts( pid: integer, pname: string. color: string );

    Catalog( sid: integer, pid: integer, cost: real );

Execute the script to creating tables (The script contains all tables used in Chapter 5 in the textbook - not only these used in this exercise ). Load data into the tables.

• Find the pid of parts with cost lower than 10$

• Find the name of parts with cost lower than 10$

• Find the address of the suppliers who supply "Fire Hydrant Cap"

• Find the name of the suppliers who supply green parts

Here are the script and the data files

chapter5_new

catalog

parts

suppliers