CSCI4350 Intro. to Database Systems

Textbook: Database System Concepts, Korth, Silberschatz and Sudarshan

This is an overview class on the principles of database systems. Topics include database systems, data models, database management systems, query languages, database design, indexing and hashing, crash recovery, integrity of database systems, and database transaction systems.
Grade: The grade will be determined from exams and projects. There will be two major exams and a final exam. There will be several projects. There will be group projects. Grades will be calculated as follows:
major exams 50%
final exam 33%
projects 17%

Note on final exam: the final exam will be given at the scheduled time. No final exams will be given at other times.
Note on grading: If you do the minimum work required to meet the project description, you will receive a C or maybe a B grade for the project. To get an A grade you must do a very thorough job on the project and turn in an excellent solution to the project problem.

Note on cheating: Cheating is attempting to get credit for work that someone else has done. This occurs most often on projects. Be sure when you turn in a project or program that you did the work yourself. Taking someone else's program and changing trivial things such as variable names and function names does not make it your work. The penalty for cheating is a failing grade and perhaps other disciplinary action.

If you bring a cell phone to class, make sure it is turned off. Do not be late to class. Do not leave class early unless you have gotten permission from me before class starts. These things are rude and disrupt the class. If you do these things I will deduct points from your final grade in the class. We will all treat each other with courtesy and respect.

We will cover the following chapters:
September : Chapter 1 Introduction; Chapter 2 ER model; Chapter 3 Relational Data Model
October : Chapter 4,5 Relational Languages; Chapter 6 Integrity Constraints; Chapter 7 Database Design
November: Chapter 8,9 Object-Oriented Model, Chapter 11 File and System Structure; Chapter 12 Indexing and Hashing
December : Chapter 15 Transaction Processing; Chapter 16 Concurrency Control; Chapter 17 Crash Recovery