CS 320: Database Systems

World

Course Description

Physical and logical organization of hierarchical, relational, and distributed database management systems; data modeling, data definition languages; query languages; management of database systems. Prerequisite: CS 250

Although the catalog description lists several forms of database organization, this class will concentrate on the design and implementation of relational database, which is the most popular form currently in use. Because of the importance of Web-based databases today, a major component of the class will be the development of Web-based applications. Since available time is limited, management of database systems will not be explicitly treated in the class. The class will be project-oriented, in the sense that at the end of the semester, you are expected to develop a database system and complete a Web application system that manipulates the database. The first part of the class will emphasize theoretical underpinnings of the database design and the review/introduction of tools needed to develop Web-based applications. The last part of the class will concentrate on the implementation of an application system on a unix-based database server.

Course Objectives

The objectives of this course include the following:

  • To learn the fundamental concepts of relational database
  • To learn how to design a database system
  • To learn the basics of Structured Query Language (SQL) for manipulating database
  • To learn how to write and use Active Server Pages (ASP)
  • To become acquainted with ActiveX Data Objects (ADO)
  • To learn to apply these concepts and techniques for Web application