Instructor: Berkay Aydin
Course Webpage: this webpage or can be reached via iCollege
Credit Hours: 4.0 hours
Class Policies: can be accessed from iCollege.
Pre-requisites: CS 2720 with a grade of “C” or higher (for CS 4710) and CS 3410 (for CS 6710)
Textbook: Fundamentals of Database Systems (7th Edition) by Elmasri & Navathe (ISBN: 0133970779)
Description: This course introduces the fundamental concepts and principles that underlie modern-day database systems, which are necessary for designing, using, and implementing database systems and applications. We will review database systems topics such as conceptual data modeling, relational data model and design, normalization and functional dependencies, query languages, and indexing. We will also cover recent advances in database systems, including non-relational databases.
Outcomes: The major goal of this course is for students to gain fundamental knowledge of, and practical experience with database systems. Upon successful completion, the student will be able to differentiate database systems from trivial storage (such as file systems), analyze a storage problem and create a conceptual model, demonstrate an understanding of relational model, functional dependencies, normalization, relational algebra, and database indexing, and formulate, using SQL, solutions to a broad range of data creation, querying and manipulation problems
Requirements: Students are expected to have at least intermediate programming skills in Java (see prerequisites) and an understanding of basic mathematical skills, specifically formal properties of sets
Grade CSc 4710 CSc 6710
A+ [100, ∞) [100, ∞)
A [95, 100) [96, 100)
A- [90, 95) [92, 96)
B+ [85, 90) [88, 92)
B [80, 85) [83, 88)
B- [75, 80) [79, 83)
C+ [70, 75) [75, 79)
C [65, 70) [70, 75)
C- [60, 65) [66, 70)
D [50, 60) [60, 66)
F [0, 50) [0, 60)
Week 1 Introduction to Database Concepts and Architecture
Week 2 Data Modeling & ER Diagrams
Week 3 Relational Data Model
Week 4 Relational Algebra
Week 5 Functional Dependencies & Normalization
Week 6 Mapping ER models
Week 7 Basic SQL - SQL Setup
Week 8 Basic SQL
Week 9 Advanced SQL
Week 10 File Organizations & Indexing
Week 11 Query Processing & Optimization
Week 12 XML - ODB - ORDB
Week 13 DDB - NoSQL - Big Data
* The last two weeks of the term will include the final reports of the projects