Skip to main content

Appendix A University Database Example

Table A.0.1. Person

ID

8 digit integer, unique key

First Name

string

Last Name

string

Middle Name

string

Birth Year

integer

Birth Month

integer

Birth Day

integer

Ethnicity

string
Table A.0.2. Employee

ID

8 digit integer, unique key

Department

string

Position

string

Fund Source

string

Wage Type

string
Table A.0.3. Student

Enrolled

date

Admission Type

string

Admission Status

string

Class Standing

string

Major 1

string

Major 2

string

Catalog Year

4 digit integer
Table A.0.4. Course

CRN

digit integer

Year

4 digit integer

Semester

integer

Prefix

string length 4

Campus

string length 1

Course

string length 4

Section

string length 3
Table A.0.5. Transcript

ID

8 digit integer, unique key

CRN

digit integer

Year

4 digit integer

Semester

integer

Grade

string length 1

Last Day

date