home

== =Introduction= This is the home page of our group portfolio for the a 3-unit Database Systems course, maintained by **Ma. Cecilia Santillan**, **Jewel Lex Javier**, and **George Heleman Tobias**. This will be updated weekly as the class progresses.

Please refer to the following pages for the main content:


 * **Journal** || **Design** || **Implementation** ||
 * A weekly summary of the database concepts we learned at class. || The iterations of our design in the form of class diagrams, flow charts, and/or pseudocodes. || The implementation of our design. ||

//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.//

=Project: Lending Company Loan System=

Project Description
The **Lending Company Loan System** is a software designed to facilitate the operation of a small lending company. A lending company lends money to clients, and profits by receiving interests over the time the client takes to pay the principal amount.

Our software will assist the record keeping, money tracking, and daily transacting of the client. It will have features to create, view, and update loans, borrowers, the company's employees, and the company's investors and stockholders. It will show reminders of a borrower's payment dates, and trivialities such as birthdays of people involved. It will show general statistics of how the business is doing at the present.

Project Objectives

 * To be able to create a usable product for use in a lending company setting, that is, it should be:
 * a product with little learning difficulty, for use by managers, secretaries, and assistants
 * a product that adequately fulfills the user's requirements
 * a product that has relatively few or zero bugs
 * a product that will be of use for the client for a long time
 * To be able to apply knowledge on databases
 * To be able to hone software development skills
 * To be able to create a User Interface that is easy to use

=Computer Science 165: Database Systems=

Official 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

 * 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.