CS460 Database
Concepts Spring 2008
Instructor Fatemeh Abdollahzadeh, Professor
Phone: 860-832-2714
Fax: 860-832-2712
Office: 303 Maria Sanford Hall
E-mail: abdollah@ccsu.edu URL: http://www.cs.ccsu.edu/~abdollah/
Office hours MW 4:45 to 5:10 and 6:30 to 8:05 PM and TR 8:00 to 8:30 PM
Text Book 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.
Course outline:
·
Database Systems Concepts and Architecture
·
Data Modeling Using the Entity-Relationship (ER) Model
·
The Enhanced Entity-Relationship
(EER) Model
·
Relational Model: Concepts, Constraints, Languages, Design , and
Programming
· Relational Algebra
· Structured Query Language
Objectives: After completing this course successfully, the student should:
·
Understand and be able to model any business “mini-world” using EER
and/or UML graphical diagram.
·
Know how to convert EER and/or UML
graphical diagram into
Relational
Database Design (i.e. database relations).
·
Know how to write relational algebra
queries as relational algebra
expressions and as relational algebra tree.
·
Know how to write Standard SQL queries.
Evaluation
40% Mid-Term Exams
40%
Assignments and project
20%
Comprehensive Final Exam
Late Project: 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.
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 will be used to replace the missing test score.
Special need: If score 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.
The research paper (with oral presentation) will be done on one of the
following topics.
|
Delphi Databases |
|
OLAP |
|
Database Security and Authorization |
MySQL |
Data Warehouses |
|
Distributed Databases |
XML |
Java Server Pages |
|
Object Oriented Databases |
JDBC |
Microsoft Access |
|
VB NET Databases |
ODBC |
VBScript |
|
Search Trees, B-trees, B+-trees |
JDBC |
Data Storage Devices |
Each group of two students will select one of the above topics and write a 15 page research paper about it. Two students covering the same topic will write 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.
Projects