CS44800, Fall 2019

Home Syllabus Schedule Homework, Projects, & Handouts Readings

This course covers fundamental concepts of database systems. These concepts include database modeling and design, relational databases, querying and SQL, query optimization, data storage, transactions, database system architectures, data mining and warehousing techniques, recovery, privacy, integrity, and security. More specifically, the course covers the following topics:

Data modeling: physical, logical and conceptual data models, the entity-relationship model
Logical and Physical Design and interaction with operating systems
Disk Storage, Basic File Structures, Hashing, Indexing
Brief introduction to Hierarchical model, Network Model
The relational database model and implementation and performance issues
Relational Algebra and Relational Calculus/SQL
Relational database design, functional dependencies, and normalization, Multi-valued dependencies
Transaction Processing
Concurrency control
Atomicity control
Recovery control
Database privacy, integrity, and security
Data mining, data warehousing, online analytical processing, and information retrieval
Cloud computing and Distributed Database Systems architectures
Big Data, Hadoop, MapReduce, and NoSQL
Performance issues

Fundamentals of Database Systems, 7th Edition, Elmasri Navathe, Addison-Wesley, 2015.
Oracle 9i Programming: A Primer, Rajshekhar Sunderraman, 2004.

There will be five project assignments. The projects are an important part of the course and you will be given details in PSOs. You will learn to use and build components of a database system. There will be five homework assignments, a midterm, and a final. The final exam will be cumulative.

The final grade will be based upon the following:

Programming/Project Assignments	30%
Homework Assignments	15%
Midterm	25%
Final	25%
Class Contribution	5%

Class contributions (e.g., class attendance and participation, discussions, asking/replying questions in class, meetings with TA/professor to discuss course material, contributing to Piazza etc.) .... (5% of grade) You should attend all classes for highest class contribution credit.
The range of scores for a grade are approximately as follows:

>97%: A+, 94-97: A, 90-93: A-
>87%: B+, 83-86: B, 80-82: B-
>77%: C+, 73-76: C, 70-72: C-
>67%: D+, 60-66 D
<60%: F

If you do not do the projects or home works, you will get an F.

Penalty for late homework/project is 10% for each class day after due date. Problems on grading of assignments/exams/projects must be resolved within one week after the graded work is returned/project score is posted in Blackboard. The grades will not be modified after the one week time period.

You must attend all classes. Absence in five or more classes will lower your final grade.

Any cheating in home work, projects and Exams will lead to an F grade in course. Do not copy from anywhere. Always give a reference to work quoted or figures or data used.
This class will follow Purdue's Honor Pledge.

Purdue University is committed to advancing the mental health and well-being of its students. If you or someone you know is feeling overwhelmed, depressed, and/or in need of support, services are available. For help, such individuals should contact Counseling and Psychological Services (CAPS) at (765)494-6995 and CAPS during and after hours, on weekends and holidays, or through its counselors physically located in the Purdue University Student Health Center (PUSH) during business hours.

The Disability Resource Center (DRC) is a resource for students and instructors. Students may present a "Letter of Accommodation" to me at any point in the semester. In many cases the DRC can partner with the instructor to develop inclusive teaching strategies that benefit all students in the class. I am committed to accommodate you.

CS44800: Introduction to Database Systems, Fall 2019