CSC4710/6710 Database systems

Administrative Info

Instructor: Berkay Aydin

Email: baydin2@gsu.edu

Room: ADERHOLD LEARNING CENTER RM 323

Course Webpage: cs.gsu.edu/~baydin2/courses/csc4780/index.html (SHOULD I REMOVE THIS?)

Office Hours: Mondays 1:30-2:30 PM or by appointment

Office Location: 25 Park Pl NE - Room 740

Webex: https://gsumeetings.webex.com/meet/baydin2 (SHOULD IT BE INCLUDED?)

Course Overview

Credit Hours: 4.0 hours

Class Policies: can be accessed here. (https://grid.cs.gsu.edu/~baydin2/courses/policy.html)

Pre-requisites: CS 2720 with a grade of “C” or higher (for CS 4710) and CS 3410 (for CS 6710) (TO MAKE SURE ABOUT LAST)

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

Grading

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)

Course Outline

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