|
facid |
fname |
lname |
|
0010 |
Amy |
Anderson |
|
0011 |
Betty |
Benson |
|
0012 |
Cathy |
Carter |
|
0013 |
Don |
Douglas |
|
0014 |
Ed |
Everette |
|
0015 |
Faye |
Faucette |
|
0016 |
George |
Grimes |
|
0017 |
Heather |
Harper |
|
0018 |
Ian |
Inverness |
|
sudid |
fname |
lname |
|
2210 |
Art |
Avery |
|
2211 |
Ben |
Baxter |
|
2212 |
Candy |
Curr |
|
2213 |
Debbie |
Denton |
|
2214 |
Ellie |
Elot |
|
2215 |
Frank |
Forbes |
|
2216 |
Gale |
Goss |
|
2217 |
Hank |
Hit |
|
2218 |
Ingred |
Ivalaos |
Faculty Table
Student Table
|
courseId |
facid |
stdid |
|
013345 |
0011 |
2210 |
|
013345 |
0011 |
2211 |
|
013345 |
0011 |
2212 |
|
013345 |
0011 |
2213 |
|
013340 |
0014 |
2210 |
|
013340 |
0014 |
2211 |
|
013340 |
0014 |
2212 |
|
013346 |
0017 |
2210 |
|
013346 |
0017 |
2211 |
Enrollment Table
What Happens at the start of the next semester?
Will the Enrollment Table Change?
Is the old data that was in the enrollment Table important?
Grades Table
|
courseId |
facid |
stdid |
term |
grade |
|
013345 |
0011 |
2210 |
20W |
A |
|
013345 |
0011 |
2211 |
20W |
A |
|
013345 |
0011 |
2212 |
20W |
A |
|
013345 |
0011 |
2213 |
20W |
A |
|
013340 |
0014 |
2210 |
20W |
A |
|
013340 |
0014 |
2211 |
20W |
A |
|
013340 |
0014 |
2212 |
20W |
A |
|
013346 |
0017 |
2210 |
20W |
A |
|
013346 |
0017 |
2211 |
20W |
A |