December 2002
Intermediate to advanced
745 pages
17h 26m
English
COURSE: Information for a course
| Column Name | Null | Type | Comments |
|---|---|---|---|
| COURSE_NO | NOT NULL | NUMBER(8, 0) | The unique course number |
| DESCRIPTION | NULL | VARCHAR2(50) | The full name for 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 user who inserted data |
| CREATED_DATE | NOT NULL | DATE | Audit column—indicates date of insert |
| MODIFIED_BY | NOT NULL | VARCHAR2(30) | Audit column—indicates who made last update |
| MODIFIED_DATE | NOT NULL | DATE | Audit column—date of last update |
SECTION: Information for an individual section (class) of a particular ...