Table Design of the Demodata Sample Database

Table Design of the Demodata Sample Database

Following is a guide to the tables in the sample university database. This information is included with each table:

•

Columns in the table

•

Data types for each column

•

Size, or length, of the column in bytes

•

Keys (blank if the column is not a key)

•

Indexes (blank if the column does not have an index)

•

•

•

•

•

•

•

•

•

•


Column	Data Type	Size	Keys
Student_ID	UBIGINT	8	PRIMARY, FOREIGN
Transaction_Number	USMALLINT	2	PRIMARY
Log	TIMESTAMP	8
Amount_Owed	DECIMAL	7.2
Amount_Paid	DECIMAL	7.2
Registrar_ID	UBIGINT	8	FOREIGN
Comments	LONGVARCHAR	65500


Column	Data Type	Size	Keys
ID	IDENTITY	4	PRIMARY
Name	CHARACTER	7	FOREIGN
Section	CHARACTER	3
Max_Size	USMALLINT	2
Start_Date	DATE	4
Start_Time	TIME	4
Finish_Time	TIME	4
Building_Name	CHARACTER	25	FOREIGN
Room_Number	UINTEGER	4	FOREIGN
Faculty_ID	UBIGINT	8	FOREIGN


Column	Data Type	Size	Keys
Name	CHARACTER	7	PRIMARY
Description	CHARACTER	50
Credit_Hours	USMALLINT	2
Dept_Name	CHARACTER	20	FOREIGN


Column	Data Type	Size	Keys
Name	CHARACTER	20	PRIMARY
Phone_Number	DECIMAL	10.0
Building_Name	CHARACTER	25	FOREIGN
Room_Number	UINTEGER	4	FOREIGN
Head_of_Dept	UBIGINT	8	FOREIGN


Column	Data Type	Size	Keys
Student_ID	UBIGINT	8	PRIMARY, FOREIGN
Class_ID	INTEGER	4	PRIMARY, FOREIGN
Grade	REAL	4


Column	Data Type	Size	Keys
ID	UBIGINT	8	PRIMARY, FOREIGN
Dept_Name	CHARACTER	20	FOREIGN
Designation	CHARACTER	10
Salary	CURRENCY	8
Building_Name	CHARACTER	25	FOREIGN
Room_Number	UINTEGER	4	FOREIGN
Rsch_Grant_Money	FLOAT	8


Column	Data Type	Size	Keys
ID	UBIGINT	8	PRIMARY
First_Name	VARCHAR	15
Last_Name	VARCHAR	25
Perm_Street	VARCHAR	30
Perm_City	VARCHAR	30
Perm_State	VARCHAR	2
Perm_Zip	VARCHAR	10
Perm_Country	VARCHAR	20
Street	VARCHAR	30
City	VARCHAR	30
State	VARCHAR	2
Zip	VARCHAR	10
Phone	DECIMAL	10.0
Emergency_Phone	CHARACTER	20
Unlisted	BIT	1
Date_Of_Birth	DATE	4
Email_Address	VARCHAR	30
Sex	BIT	1
Citizenship	VARCHAR	20
Survey	BIT	1
Smoker	BIT	1
Married	BIT	1
Children	BIT	1
Disability	BIT	1
Scholarship	BIT	1
Comments	LONGVARCHAR	65500


Column	Data Type	Size	Keys
Building_Name	CHARACTER	25	PRIMARY
Number	UINTEGER	4	PRIMARY
Capacity	USMALLINT	2
Type	CHARACTER	20


Column	Data Type	Size	Keys
ID	UBIGINT	8	PRIMARY, FOREIGN
Cumulative_GPA	DECIMAL	5.3
Tuition_ID	INTEGER	4	FOREIGN
Transfer_Credits	DECIMAL	4.0
Major	CHARACTER	20	FOREIGN
Minor	CHARACTER	20	FOREIGN
Scholarship_Money	DECIMAL	19.2
Cumulative_Hours	SMALLINT	2


Column	Data Type	Size	Keys
ID	INTEGER	4	PRIMARY
Degree	VARCHAR	4
Residency	BIT	1
Cost_Per_Credit	REAL	4
Comments	LONGVARCHAR	65500