A: University Database Example

Last updated
Save as PDF

Page ID: 93288

\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

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