CST-421-20, Database Concepts (FA13)

INSTRUCTOR: Kyongil Yoon

SCHEDULE/DAY/TIME: T2/Wed/6-8:45pm, 10/23/2013-12/11/13

CONTENT:

This course introduces the concepts and techniques of databases. Students will learn how to develop a database through a full development cycle. How to design relational tables and how to retrieve data from a database using SQL will be explored. Topics will include concepts of database, database design, entity-relationship models, normalization, SQL, and other DBMS issues.

LEARNING OBJECTIVES:

• Students will be able to understand the general concepts of database systems and relational database in particular.
• Students will learn the basics of SQL, the standard relational query languages.
•  Students will be able to design and implement a simple relational database

METHODS:  

Lecture

Hands-on labs and assignments

Term Project

REQUIREMENTS AND ASSIGNMENTS: 

Assignments: 40%

Exam: 25%

Final Project: 25%

Discussion and Participation: 10%

REQUIRED TEXT(S) OR MATERIALS: 

DATABASE SYSTEMS: A Practical Approach to Design, Implementation, and Management, 5th ed., Thomas Connolly, Carolyn Begg, Addison Wesley, ISBN 9780321523068

READINGS AND/OR ASSIGNMENTS TO BE DONE PRIOR TO THE FIRST CLASS:

Read chapter 1.  Introduction to Databases