REK Project : Research Experience for K12

 
 Jun Qi
          My name is Jun Qi, a student currently attends Massachusetts Academy of Mathematics and Science at Worcester Polytechnic Institute. I will become a senior in the fall of 2007. This summer, I started my internship at the Computer Science Department at Worcester Polytechnic Institute. The department offers research experiences for students from kindergarten to twelfth grade. My duties during this internship are concentrated in creating a project related to store and display database publications. The project, as a website itself, displays all DSRG (Database System Research Group) publications in table forms and allows users to add, update and delete their publications.

To create this project, I was assigned to read several comprehensive books, including Oracle 8i, Oracle 9i, JSP 2.0, and Programming World Wide Web, etc. Moreover, I also used online tutorials to enhance my understanding of database related programming. From this wonderful two-month internship at WPI, I learned how to use SQL (Structured Query Language) commands create tables, insert and select data in MySQL software. Moreover, I learned basic JSP (Java Server Page) syntaxes to create User Interfaces for WPI DSRG Web Page. With all this novel knowledge, I am able to accomplish my duty during this internship. I believe that interning at the Computer Science Department is a wondrous opportunity to gain excellent experiences and knowledge from the field of Computer Science.

Weekly Activities

        Below is the list of the books, online tutorials (URL) I have accessed to learn SQL, JSP, Database Management System during the passed two weeks.

 Books:

·        Oracle 9i  Programming

o       Chapter 1 The Relational Data Model

o       Chapter 2 Oracle SQL

·        A Guide to LATEX

o       Appendix B – Bibliographic Databases

·        Oracle 8i – A Beginner’s Guide

o       Chapter 7 – SQL 101

·        Database Management Systems

·        JSP 2.0

·        Programming the World Wide Web

URLs:

n      How to use Bibtex. (1994.) Retrieved July 4th, 2007,

n      Introduction to Developing Web Applications. Retrieved July 12, 2007,

n      Jacobson, Dana. (1996.) BibTeX. Retrieved July 3rd, 2007,

n      MySQL Basics -- A Helpful MySQL Tutorial. (2006). Retrieved July 16, 2007

   n Nested Tables and VARRAYS. (2000). Retrieved July 3rd, 2007, from