Library DB

Schema

A schema has been provided with the following structure:

authors
- id
- name TEXT
- nationality TEXT
- birth_year INTEGER
books
- id
- title TEXT
- publication_date INTEGER
- author_id INTEGER (Foreign key)

Load the schema into your DB:

$ psql -d library < schema.sql

Load the given seed file into your db. Take a look at it, and note how authors and books are related.

$ psql -d library < seed.sql

There are two exercise sets:

Name		Name	Last commit message	Last commit date
Latest commit History 16 Commits
advanced_queries.sql		advanced_queries.sql
basic_queries.sql		basic_queries.sql
readme.md		readme.md
schema.sql		schema.sql
seed.sql		seed.sql