O'Reilly logo

Oracle by Elena Silvestrova Rakhimov, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix B Student Database Schema

Table and Column Descriptions

COURSE: Information for a course

COLUMN NAME

NULL

TYPE

DESCRIPTION

COURSE_NO

NOT NULL

NUMBER(8, 0)

The unique course number

DESCRIPTION

NULL

VARCHAR2(50)

The full name of this course

COST

NULL

NUMBER(9,2)

The dollar amount charged for enrollment in this course

PREREQUISITE

NULL

NUMBER(8, 0)

The ID number of the course that must be taken as a prerequisite to this course

CREATED_BY

NOT NULL

VARCHAR2(30)

Audit column—indicates who inserted data

CREATED_DATE

NOT NULL

DATE

Audit column—indicates the date of insertion

MODIFIED_BY

NOT NULL

VARCHAR2(30)

Audit column—indicates who made the last update

MODIFIED_DATE

NOT NULL

DATE

Audit column—date of the last update

SECTION: Information ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required