Oracle PL/SQL by Example, Fifth Edition (2015)

B. Student Database Schema

Table and Column Descriptions

This appendix lists all the tables from the STUDENT database schema that are used in the book. Each table is listed here with the database table name first; what follows are the columns in that table, an indicator of whether a null value is allowed, the column data type, and a description. The scripts to install this database can be found on the companion website for this book.

COURSE: Information for a Course

SECTION: Information for an Individual Section (Class) of a Particular Course

STUDENT: Profile Information for a Student

ENROLLMENT: Information for a Student Registered for a Particular Section of a Particular Course (Class)

INSTRUCTOR: Profile Information for an Instructor

ZIPCODE: City, State, and ZIP Code Information

GRADE_TYPE: Lookup Table of a Grade Type (Code) and its Description

GRADE_TYPE_WEIGHT: Information on How the Final Grade for a Particular Section is Computed; For Example, the Midterm Constitutes 50%, the Quiz 10%, and the Final Examination 40% of the Final Grade

GRADE: The Individual Grades a Student Received for a Particular Section (Class)

GRADE_CONVERSION: Converts a Number Grade to a Letter Grade

The entity–relationship diagram for the tables in the student schema shown in Figure B–1 shows the tables and their foreign key relationships using the standard crow’s feet arrows.

Figure B-1