CptS 451 - Introduction to Database Systems (Spring 2017)

 

Instructor: SakireArslan Ay

Office: EME 102D

Email: arslanay[at] eecs . wsu .edu

Phone: (509) 335-4089

Office Hours: Mon, Wed, Fri: 12:10pm-1:10pm; Tue, Thu: 1:20pm-2:20pm, EME 102D

Lectures: Tu - Thu   12noon - 13:15pm Sloan 175

Teaching Assistant: TBA

Office: TBA

Email: TBA/font>TBA

Office Hours: TBA

 

RECENT UPDATES

[01.10.2017] Welcome to CptS 451!

COURSE DESCRIPTION

This course introduces students to practical and theoretical database concepts. In addition students learn to model databases using the entity relationship diagram method. The database language concepts while general in nature are demonstrated using an SQL platform. Overall database design and implementations issues will also be presented.

Prerequisites:"Cpts 223 - Advanced Data Structures", "Cpts 224 - Programming Tools"

Textbooks and Reading Materials:

Required Textbook:
[DMS] Database Management Systems (3rd Edition), Raghu Ramakrishnan, Johannes Gehrke, ISBN-13: 978-0072465631 ISBN-10: 0072465638 McGraw-Hill , 2003 (Also known as the “Cow Book”)

Recommended Textbook:
[DS-CB]

Database Systems: The Complete Book (2nd Edition), Hector Garcia-Molina, Jeffrey Ullman, Jennifer Widom, ISBN: 0131873253 Pearson , 2009

OUTLINE

Topics

Reading

# of Lectures

Overview of Database Systems

DMS Ch 1

1

Project Overview and JSON Data

1

Introduction to Database Design – ER Model

DMS Ch 2

2

Relational Model

DMS Ch 3

3

Relational Algebra

DMS Ch 4

2

SQL Overview: Queries, Constraints and Triggers

DMS Ch 5

6

Database Design Theory and Normal Forms

DMS Ch 19

3

Database Application Development and Stored Procedures

DMS Ch 6

2

Storage and Indexing

DMS Ch 8,9,10,11

3

Query Execution

DMS Ch 12,14

3

Query Optimization

DMS Ch 15

1

NoSQL Databases (if time permits)

 

Academic Integrity

All work in this class must be done individually. If you use material found on the web, reference any and all material you use. Anyone cheating on work in this class will receive a failing grade for the work and will be subject to the university’s academic dishonesty policy. Cheating involves giving assistance or receiving assistance on work assigned in this class. If you have any questions regarding an assignment or a quiz, see the instructor or teaching assistant. The WSU statement on academic integrity can be found at http://www.eecs.wsu.edu/~schneidj/Misc/academic-integrity.html.

Students with Disabilities

Reasonable accommodations are available for students with documented disability. If you have a disability and may need accommodations to fully participate in this class, please visit the Access Center (Washington Building 217) to schedule an appointment with an Access Advisor. All accommodations MUST be approved through the Access Center. Additional information can be viewed at the URL http://drc.wsu.edu

Campus Safety

The Campus Safety Plan, which can be found at http://safetyplan.wsu.edu, contains a comprehensive listing of university policies, procedures, statistics, and information relating to campus safety, emergency management, and the health and welfare of the campus community. The left side bar at this safety plan homepage contains many important links to safety information.