CSCI 250 - Table Example

NameTable

StudentID	LastName	FirstName
123	Doe	John
124	Doe	Jane
125	Jones	John

CourseTable

StudentID	Course
123	CSCI 250
123	MATH 240
123	MATH 130
124	CSCI 150
124	HIST 110

Click here to see the SQL statements that create these tables and add the data.