4.2 Create a Table (PATRONS)

The PATRONS table contains a row for each patron who can check books out of the library.

1. In the SQL Worksheet, enter the following statement:

   CREATE TABLE patrons (
      patron_id NUMBER,
      last_name VARCHAR2(30)
         CONSTRAINT patron_last_not_null NOT NULL,
      first_name VARCHAR2(30),
      street_address VARCHAR2(50),
      city_state_zip VARCHAR2(50),
      CONSTRAINT patrons_pk PRIMARY KEY (patron_id));

2. Click the Run Statement icon.

   The following notification is displayed in the Script Output pane:

   Table PATRONS created.