- Database Scheme
Current Database
New Database
Description of New Fields:
TABLE STUDENT
Field
Description
STUDENT.URL
URL of the Student
STUDENT.PROJECTTOPIC
Topic of the main research of the student
STUDENT.SKILLS
Skills of the student. Separated by “,”.
STUDENT.AREAS
Areas of interest of the student. Separated by “,”.
STUDENT.AVG_RATING
GPA of the Student
STUDENT.REVIEW
Comments about the student. Could be used as advertisement.
STUDENT.SSN_ADVISOR
SSN of the student’s advisor. This will help boost the network search results.
TABLE TEA_PAS
Field
Description
TEA_PAS.URL
URL of the teacher
TEA_PAS.AREAS
Areas of interest of the teacher. Separated by “,”.
TEA_PAS.COURSES
Courses taught by the instructor. Separated by “,”.
TEA_PAS.AVG_RATING
Latest rating of the instructor.
TABLE COURSE
Field
Description
COURSE.TOPIC
Topics of the course. Used as keywords for search. The topics are separated by spaces " ".
TABLE IS_ENROLLED
Field
Description
IS_ENROLLED.GRADE
Grade of the student in the course.
- Data population (data for testing the Automatic Helper Finder and the Yellow Pages)
I have manually added data to the database in order to test the program.
- Security
I have implemented a simple code to encrypt the password and user of the database administrator. This information is saved and used by the system, while connecting to the database.
Notes:
- The real database of VC is in MS SQL Server, and it is centralized. However, my implementation has been done in a local copy of the database, in a MS Access version gently provided by Xin Li. Later on, it can be easily migrated to MS SQL Server again.
- My implementation assumes that the Student VT will feed the database automatically. My implementation won’t upload the files, since it should be an automatic procedure of update (it shouldn’t be done in search time).
