Syllabus          CS460        Database Concepts           Spring 2007

INSTRUCTOR

Dr. Irena Pevac,  Associate Professor

OFFICE

Maria Sanford 303

PHONE

832-2721

e-mail

pevac   @   ccsu.edu

WEB

members.cox.net/pevac

 

 

 

OFFICE HOURS

Monday, Wednesday

Tuesday, Thursday

4:00 - 5:15  PM 

2:15 - 3:15  PM  and by appointment

 

CREDIT LOAD

3 credits

PREREQUISITE

CS 253 and MATH218 or graduate standing

TEXTBOOK

Elmasri, Navathe: Fundamentals of Database Systems, 5th ed, Addison Wesley, 2006

OVERVIEW: This is a theoretical course with emphasis on design and modeling which is covered using EER modeling, and UML  modeling.   Another important part is relational design.  The database relations (tables) are created by translating EER model into database relations. Tables are normalized to the highest normal form possible. Database manipulation includes retrieving information without changing the database state and  updating,  inserting and deleting records which changes database state. Querying is done on abstract theoretical level using relational algebra and on applied programming level using standard SQL.  The emphasis is on fundamental DBMS concepts, not on specific software.

Topics covered in student presentations will include database processing using Internet technologies. Web oriented programming languages like JavaScript, VBScript, Visual Basic and Java, as well as markup languages DHTML and XML and finally Active Server Pages will be described.   Storage level will be discussed on device level (magnetic disc) and  index structure level (B trees and B+ trees).  See other topics bellow.

SOFTWARE: Software will include Microsoft Access available in Computer lab. Project covering SQL can also be done in Oracle.

 

 

COURSE TOPICS - Read the topic before it is covered in the class.

Introduction to Database Processing

Definition of a Database and DBMS

Components of a Database Systems and Database Development Process

Entity-Relationship Model (standard and extended)

Entities

Relationships and Cardinalities

Referential Integrity Constraints

UML  Diagrams

Converting  EER Model into Relational Database

Normalization for Relational Model

Querying

Relational Algebra

Structured Query Language

The research paper (with oral presentations) will be done on the following topics.

Visual Basic Databases

 ADO

 OLAP

Database Security and Authorization

 MySQL

 Data Warehouses

Distributed Databases

 XML

 Java Server Pages

Object Oriented Databases

 JDBC

 Microsoft Access

VB NET

 ODBC

 VBScript

Search Trees, B-trees, B+-trees

JDBC

Data Storage Devices

Each student will select one of the above topics and write a 10 page research paper about it. If two students agree to do the same topic they will write 20 page paper and present topic jointly.  Each paper should have at least 5 references. At most 3 can be web addresses.  Paper should be submitted on the floppy or CD-ROM together with printout of it. Presentation should be done using PPT format and students should present the topic in front of the class.

 

DATES for TESTS, FINAL EXAM and RESEARCH PAPERS

 

                  PROJECTS DUE

  T1  02-28-07                   20 points

P1   02-21-07                    10 points

  T2  04-16-07                   20 points

P2   03-07-07                    10 points

  Final Exam 5-14-07

  TIME: 6:15PM-8:15 PM        10 points

P3   04-11-07                    10 points  

  PAPER DUE   5-02-07   

  ORAL May 02 - May 10 2007     10 points

P4   04-30-07                    10 points

LATE PROJECTS: Projects are due as mentioned. You may submit a project at most one class after the due date in which case a penalty of two points will occur. After that projects are unacceptable.

Thus, the Final Grade consists of approximately 50% on testing, 50% on projects and academic class-work. 

ATTENDANCE POLICY: You are supposed to attend classes regularly. In case of absence it is your responsibility to cover the topics done in the class. In case of missing a test date your final exam score will be used to replace the missing test score.

SPECIAL NEEDS: If you need special adaptations or accommodations because of a disability or if you need special arrangements in case the building must be evacuated, please notify me as soon as possible during my office hours.