home

CS 165 HTQR
= ** Database Systems ** =

Course Description
Database concepts: data independence, architecture, models, administration, relational algebra and calculus, normalization, query optimization, concurrency, recovery. Survey of database management systems.

Course Objectives:
At the end of the course, the student should be able to:
 * understand the underlying concepts and theory of database systems which include topics on database system architecture, data models, query languages, logical and physical data organization, transaction management and query optimization;
 * learn how database systems for applications are modeled, designed, created, optimized and managed;
 * learn how to use query languages such as Structure Query Language (SQL) to manipulate databases;
 * understand the design of database engines

This wikispace is dedicated to the discussion of progress and experiences of our group in the course CS165. This will serve as a forum and blog for academic discussions.

= ** //Project Name : Computerized Student Archive// ** = = ** //Description:// ** = Talk-Shop is a Communication Workshop in the Philippines. It is a facility that offers fields in English-communication, personality development and gives teaching certifications. Programs here are not as static as those of other schools. Courses assigned to a student depend on the analysis of his/her thinking style and other personality factors. Thus, there is no specific syllabus for a certain style. To support this king of education program, they would need to keep track of a student’s record, especially sessions. They would need to know which courses have the student finished. So far, their administrative methods are completely manual and thus, taking a lot of time. This made their work very time consuming and inefficient. This project aims to create a computerized student archive that can help them speed up the process. The application must let the user be able to search and edit student records and view candidates for teaching certification. It must also be simple and very informative and must display the following information for each student;

§ Student Information · Last Name · First Name · Middle Name · Sex · Birthday · Affiliation · Thinking Style · Enneagram (personality) · Archetype

§ Academic Record · Status (Ongoing, Graduate, Blacklisted) · Date Enrolled · Payment Status · Progress through enrolled sessions o Dates of sessions o Duration of sessions · Programs Finished o Levels completed

§ Contact Information · Contact Numbers · Email addresses · Home Addresses · Reasons for enrolling · Relative enrolled to TalkShop

The user must also be able to search using the mentioned student information and edit them.  = Group Members: = 2008-03187 Julmar B. Caranguian 2008-18324 Kathleen Grace R. Kam 2008-66741 Reynald M. Pader

==== //This is a course requirement of CS 165 Database Systems of the Department of Computer Science, College of Engineering, UP Diliman Quezon City, Philippines, under the guidance of Prof. Ma. Rowena C. Solamo for the 2nd semester of the academic year 2010-2011.//  ====