Database Design 4 College Dept

I am trying to do a class project. I want to build a database for the computer department of a college. Some of the things I want the database to provide are: to find out which instructors are teaching what classes, what classes students are enrolled for. Some classes are taught online, inperson, on PC and on MAC. A query should be able to run to tell if a class is online or being taught in person and is it being taught on PC or MAC. The classes are held in labs. There are nine labs so you should be able to find out which lab a class is being held in. Below are the tables I have created so far. I need to know if I need to add other fields to any of the tables or if I need to add tables and how to develop the relationship between the tables. I have a CourseHistory table but it seems if it really was to be used the data it contains might cause peformance issues because of so much data storage. Any help would be appreciated. Below are the tables I have created so far.

Student table
StudentID (int) – primary key not null
SFirstName (nvarchar)
SLastName (nvarchar)
SContactNumber (varchar)
SAddress (nvarchar)
SCity (nvarchar)
SState (varchar)
SZipCode (varchar)

Course table
CourseID (int) – primary key not null
CourseTitle (nvarchar)
StartDate (datetime)
EndDate (datetime)
DateWkHeld (datetime)
LabNumber (smallint) null (online courses have no labnumber)
CreditValue (smallint)
CourseDuration
CourseFee

CourseHistory table
CourseHistoryID (int) – primary key not null
CourseID (int) foreign key
StartDate (datetime)
EndDate (datetime)
DateWkHeld (datetime)
LabNumber (smallint) – null where should this be?
CourseFee – denomalization

Enrollment Table
EnrollmentID (int) prmary key not null
StudentID (int) foreign key not null
CourseHistoryID (int) foreign key not null
Instrutor D (int) foreign key
EnrollmentDate (datetime)
NumGrade (smallint)
Pass/Fail (bit)
CourseLoad(FT/PT) (bit)
TypeClassID (int) key would have one of 2 values: 1 or 2 1=MAC 2=PC)
LabNumber (smallint) foreign key
OnlineClass/InPerson (bit)
CreditClass/NonCreditClass (bit)
CourseFeePayDate

Instructor table
InstructorID (int) primary key not null
EnrollmentID (int) foreign key
IFirstName (nvarchar)
ILastName (nvarchar)
IContactNumber (varchar)
IAddress (nvarchar)
ICity (nvarchar)
IState (varchar)
IZipCode (varchar)

The tables did not attach.

Also, you may want to start with an abstract model than go straight to tables. (ER/UML modeling).