4.2 Table Descriptions

The following includes the table descriptions for the data model.

 SQL> desc state_lookup  Name                            Null?    Type  ------------------------------- -------- -----------  STATE                           NOT NULL VARCHAR2(2)  STATE_DESC                      NOT NULL VARCHAR2(30) SQL> desc major_lookup  Name                            Null?    Type  ------------------------------- -------- -----------  MAJOR                           NOT NULL VARCHAR2(2)  MAJOR_DESC                      NOT NULL VARCHAR2(15) SQL> desc students  Name                            Null?    Type  ------------------------------- -------- -----------  STUDENT_ID                      NOT NULL VARCHAR2(10)  STUDENT_NAME                    NOT NULL VARCHAR2(30)  COLLEGE_MAJOR                   NOT NULL VARCHAR2(2)  STATUS                          NOT NULL VARCHAR2(15)  STATE                                    VARCHAR2(2)  LICENSE_NO                               VARCHAR2(30) SQL> desc student_vehicles  Name                            Null?    Type  ------------------------------- -------- -----------  STATE                           NOT NULL VARCHAR2(2)  TAG_NO                          NOT NULL VARCHAR2(10)  VEHICLE_DESC                    NOT NULL VARCHAR2(20)  STUDENT_ID                      NOT NULL VARCHAR2(10)  PARKING_STICKER                 NOT NULL VARCHAR2(10) SQL> desc parking_tickets  Name                            Null?    Type  ------------------------------- -------- -----------  TICKET_NO                       NOT NULL VARCHAR2(10)  AMOUNT                          NOT NULL NUMBER(5,2)  STATE                           NOT NULL VARCHAR2(2)  TAG_NO                          NOT NULL VARCHAR2(10) SQL> desc professors  Name                            Null?    Type  ------------------------------- -------- -----------  PROF_NAME                       NOT NULL VARCHAR2(10)  SPECIALTY                       NOT NULL VARCHAR2(20)  HIRE_DATE                       NOT NULL DATE  SALARY                          NOT NULL NUMBER(7,2)  TENURE                          NOT NULL VARCHAR2(3)  DEPARTMENT                      NOT NULL VARCHAR2(10) SQL> desc courses  Name                            Null?    Type  ------------------------------- -------- -----------  COURSE_NAME                     NOT NULL VARCHAR2(10)  COURSE_DESC                     NOT NULL VARCHAR2(20)  NO_OF_CREDITS                   NOT NULL NUMBER(2,1) SQL> desc students_courses  Name                            Null?    Type  ------------------------------- -------- -----------  STUDENT_ID                      NOT NULL VARCHAR2(10)  COURSE_NAME                     NOT NULL VARCHAR2(10)  PROF_NAME                       NOT NULL VARCHAR2(10)