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)