CSCI 275 Student Database

The relational schema of the "Student" database is as follows:

The following are the text files used to create the "Student" database.

• Table Creation
• Insert Buildings
• Insert Departments
• Insert Students
• Insert Courses
• Insert Sections
• Insert Enrollments

SQL Loader Files

• Course Control File course.ctl
• Course Data File course.dat
• Student Control File student.ctl
• Student Data File student.dat

SQL Loader Command

\\caesar\apps\oracle~2\sqlldr userid=username/passwd@csci275 control=controlfile.ctl

If that does not work, try:

\\caesar\apps\oracle~2\sqlldr userid=username/passwd@iras.ad.stfx.ca:1521/CSCI275 control=controlfile.ctl

Notes:

• Run from command prompt from directory containing control file
• Table must be empty before loading
• Control file must contain complete path to data file
• Data file must end in a newline character or last record lost
• Bad data will go into controlfile.bad
• You may use any character as a delimeter
• Any text, including spaces, between delimeters will be inserted into character fields
• Null values are created by including no content between two delimeters