4 Tutorial: Creating Objects for a Small Database

Create objects for a simplified library database, which will include tables for books, patrons (people who have library cards), and transactions (checking a book out, returning a book, and so on).

The tables are deliberately oversimplified for this tutorial. They would not be adequate for any actual public or organizational library.

This tutorial assumes that you have a database connection to a database user that will own the tables and other objects that you create.

The major steps are:

• Create a Table (BOOKS)
• Create a Table (PATRONS)
• Create a Table (TRANSACTIONS)
• Create Two Sequences
• Insert Data into the Tables
• Create a View
• Create a PL/SQL Procedure
• Use the SQL Worksheet for Queries