More practice getting around in the PostgreSQL and pgAdmin environments.
Familiarize yourself with the CAP database data.
Get some easy lab points.
Create our beloved CAP3 database in PostgreSQL. Use the script at
http://www.labouseur.com/courses/db/cap3.txt.
1. Execute the following queries (one at a time) from pgAdmin’s SQL Tool:
select *
from customers;
select *
from agents;
select *
from products;
select *
from orders;
Take a screen shot of each query and its results. Compare those to the data in the CAP
snapshot at http://www.labouseur.com/courses/db/cap3.pdf.
2. Explain the distinctions among the terms primary key, candidate key, and superkey.
3. Write a short essay on data types. Select a topic for which you might create a table.
Name the table and list its Wields (columns). For each Wield, give its data type and whether
or not it is nullable.
4. Explain the following relational “rules” with examples and reasons why they are
important.
a. The “Wirst normal form” rule
b. The “access rows by content only” rule
c. The “all rows must be unique” rule
Chapter 6.1 in our text
pgAdminIII documentation - http://www.pgadmin.org/docs/
pgAdmin tag at Stack OverWlow - http://stackoverWlow.com/questions/tagged/pgadmin
SQL tag at Stack OverWlow - http://stackoverWlow.com/questions/tagged/sql
