Database Systems
CS 687 – Spring 2006
Instructor: Dr. Ramazan Aygün
Office: Technology Hall N360
Email: raygun@cs.uah.edu
Phone: 824-6455
Office Hour: Thursday 3:50-5:20 Wednesday 2:00-2:30
Meeting day(s): TR 2:20-3:40PM
Location: N326
The objective of this course is to introduce the student to the fundamental concepts necessary for the design, use, and implementation of database systems and help students gain background for conducting further research as well.
Knowledge of data structures and operating systems.
Elmasri and Navathe, Fundamentals of Database Systems, Addison-Wesley, Fourth Edition
Worsley and Drake, Practical PostgreSQL, published by O’Reilly
Title |
Reading Chapters |
Introduction to database systems: databases, concepts, architecture |
1, 2 |
Relational model: data model, algebra, calculus |
5, 6 |
Query language (SQL) |
8, 9 |
Functional dependencies and normalization |
10, 11 |
Data storage, indexing, and physical design |
13, 14 |
Conceptual data modeling, database design, and data model mapping |
3, 4 |
Query processing and optimization |
15 |
Transaction processing, concurrency control, and recovery |
17, 18, 19 |
Object and object-relational database systems |
20, 21, 22 |
Distributed database systems |
25 |
Data Mining |
27 |
Advanced Databases |
|
15% Homework
30% Projects
10% Report/Paper
20% Midterm exam, March 2nd, Thursday
25% Final exam, April 27th Thursday, 3:00-5:00PM
The following information is from http://www.uah.edu/library/turnitin/about.htm: “Turnitin.com allows the student or educator to upload a paper into the Turnitin.com database, where software will then use algorithms to create “digital fingerprints” that can identify similar patterns in text (“About Turnitin.com”). Then the paper is matched to billions of web pages, paper mill essays, and student papers submitted online. In an hour or less, Turnitin.com creates an “originality report” that highlights any passages from the paper that might not be authentic, and lists web sites and other resources with content that matches that in the paper (“About Turnitin.com”).
Students can use Turnitin.com to:
•
Quickly track down sources used in their essays, minimizing the chance that
they will forget to cite sources.
• Learn about the concept of plagiarism and its consequences for the student,
course, and the academic community as a whole.
• Acquire tips on how to avoid both Internet and conventional plagiarism.
• Learn guidelines for proper citation.
• Gain strong research and writing skills.
• Clarify misunderstood concepts like fair use, public domain, and copyright
laws.”
For more information please visit http://www.uah.edu/library/turnitin/.
The students are urged to use turnitin.com before the submission of their reports. The instructor will use turnitin.com in the evaluation of the papers.