University Database Example

Skip to main content

\(\newcommand{\R}{\mathbb{R}} \newcommand{\Z}{\mathbb{Z}} \newcommand{\Pow}{\mathcal{P}} \newcommand{\lt}{<} \newcommand{\gt}{>} \newcommand{\amp}{&} \definecolor{fillinmathshade}{gray}{0.9} \newcommand{\fillinmath}[1]{\mathchoice{\colorbox{fillinmathshade}{$\displaystyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\textstyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\scriptstyle \phantom{\,#1\,}$}}{\colorbox{fillinmathshade}{$\scriptscriptstyle\phantom{\,#1\,}$}}} \)

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 🔗