Syllabus

Instructor: Dr. Ramazan Aygün

Office: Technology Hall N360

Email: raygun@cs.uah.edu

Phone: 824-6455

Office Hour: Thursday 1:55-3:55

Meeting day(s): TR 3:55-5:15

Location: N302

Objective

The objective of this course is to introduce the student to the fundamental concepts necessary for the design, use, and implementation of database systems.

Prerequisites

Knowledge of data structures and operating systems.

Required Texts

Elmasri and Navathe, Fundamentals of Database Systems, Addison-Wesley, Fourth Edition

Course Outline

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	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
Data mining	27
Advanced database systems

Grading

20% Homeworks

15% Project

15% Paper

20% Midterm exam

30% Comprehensive final exam

Notes

Late Policy. The assignments are to be submitted on time. One day late submissions will be accepted with a late penalty of 15%. Assignments those are late more than one day past the due date will not be accepted (except for medical reasons). The students have one week for raising questions on grading after the return of a graded assignment.

WebCT. The students are urged to use WebCT. The assignments and grades will be posted by WebCT.

Official UAH Statement on Plagiarism. “UAH is committed to the fundamental values of preserving academic honesty as defined in the Student Handbook (7.III.A). The instructor reserves the right to utilize electronic means to help prevent plagiarism. Students agree that by taking this course all assignments are subject to submission for textual similarity review to Turnitin.com. Assignments submitted to Turnitin.com will be included as source documents in Turnitin.com's restricted access database solely for the
purpose of detecting plagiarism in such documents. The terms that apply to the University's use of the Turnitin.com service, as well as additional information about the company, are described at www.uah.edu/library/turnitin.”

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 papers. The instructor will use turnitin.com in the evaluation of the papers.