CS425 Database Systems

Course
76470
Section
F01
Credits
3 + 0
Prerequisites:
  • CS311 or CS480
  • CS321
Instructor
John Quan
Phone
907-474-7098
Office
Duckering 529
Email
jquan2@alaska.edu
Office Hours
By Appointment
MWF
Meeting Time
Room
Chapman 103
Course Website
/courses/cs425/2016-fall/
Required Texts
Fundamentals of Database Systems, 7th Ed., ISBN: 9780133970777 By: Elmasri and Navathe

Course Description

Data independence, modeling, relationships and organization. Hierarchical, network, and relational data models; canonical schema. Data description languages, SQL, query facilities, functional dependencies, normalization, data integrity, and reliability. Review of current database software packages.

Tentative Schedule

    • Introduction; Syllabus

      • Read Chapter 1

    • Chapter 1: DBs and DB Users; Chapter 2: DB System Concepts and Architecture

      • Read Chapter 2; Assignment 1

    • Lab 0: Setting up our Operating System

      • Read Chapter 3

    • LABOR DAY

    • Chapter 3: Data Modeling Using the ER Model

      • Assignment 1 due

    • Last day for student- and faculty-initiated drops (course does not appear on academic record)

    • Chapter 3 continued

      • Assignment 2

    • Lab 1: ER Diagramming

      • Read Chapter 4

    • Chapter 4: The EER Model

    • Chapter 4 continued

      • Assignment 2 due; Assignment 3

    • Lab 2: EER Diagramming

      • Read Chapter 5

    • Chapter 5: The Relational Data Model and Relational Database Constraints

    • Chapter 5 continued

      • Assignment 4

    • Lab 3: Managing MySQL from the Command Line

      • Assignment 3 due; Read Chapter 6

    • Chapter 6: Basic SQL

    • Chapter 6 continued

      • Assignment 4 due; Assignment 5

    • Lab 4: Managing MySQL from the Command Line continued

      • Read Chapter 7

    • Chapter 7: Complex Queries, Triggers, Views and Schema Modification

    • Chapter 7 continued

      • Assignment 5 due; Assignment 6

    • Lab 5: MySQL from the Command Line

      • Read Chapter 9

    • Chapter 9: Relational Database Design by ER- and EER-to-Relational Mapping

    • Chapter 9 continued

      • Assignment 7

    • Deadline to apply for fall 2016 graduation

    • Lab 6: MySQL Workbench

      • Assignment 6 due

    • Lab 7: MySQL Workbench continued

    • MIDTERM REVIEW; PROJECT Discussion

      • Assignment 7 due

    • MIDTERM EXAM

    • MIDTERM EXAM

    • MIDTERM EXAM

      • Read Chapter 13

    • Chapter 13: XML: Extensible Markup Language

    • Chapter 13 continued

      • Assignment 8

    • Last day for student- and faculty-initiated withdrawals (W grade appears on academic transcript)

    • Lab 8: XQuery

      • Read Chapter 14

    • Chapter 14: Basics of Functional Dependencies and Normalization for Relational Databases

    • Chapter 14 continued

      • Assignment 8 due; Assignment 9 MID-PROJECT PRESENTATION

    • Lab 9: Django-CMS

      • Read Chapter 15

    • Chapter 15: Relational Database Design Algorithms and Further Dependencies

    • Chapter 15 continued

      • Assignment 9 MID-PROJECT PRESENTATION due; Assignment 10

    • Lab 10: Django-CMS continued

      • Read Chapter 24

    • Chapter 24: NoSQL Databases and Big Data Storage

      • Read Chapter 25

    • Lab 11: Node.js and MongoDB

      • Assignment 10 due; Assignment 11

    • THANKSGIVING

    • THANKSGIVING

    • Chapter 25: Big Data Technologies Based on MapReduce

    • Lab 12: Hadoop

      • Assignment 11 due

    • Lab 13: Hadoop continued

    • FINAL EXAM

    • FINAL EXAM

    • FINAL EXAM

    • Last day of instruction

    • PROJECT PRESENTATIONS, 3:15-5:15 p.m.

Grading Policies

Weight Description
10% Labs
20% Projects
30% Assignments
40% Exams

Grades will be assigned based on the following percentage intervals:

A+
[95%, 100%)

A
[90%, 95%)
A-
[85%, 90%)
B+
[80%, 85%)

B
[75%, 80%)
B-
[70%, 75%)
C+
[65%, 70%)

C
[60%, 65%)
C-
[55%, 60%)
D+
[50%, 55%)

D
[45%, 50%)
D-
[40%, 45%)
F
[0%, 40%)

Assignments

The assignments will reinforce lecture concepts, demonstrate your application of critical thinking skills, and consist of written and/or diagramming problems. Individuals submitting the same or highly similar homework solutions will each receive an F for the semester. I will deduct 10% per day for up to three days for late assignments.

Exams

Examinations may consist of short answer, multiple choice questions, and short programming/diagramming exercises to demonstrate critical thinking skills, and your application of database concepts. ALL EXAMINATIONS MUST BE TAKEN AS SCHEDULED EXCEPT IN EXTREME CIRCUMSTANCES.

Labs

I have included a significant amount of time between chapters that I am dedicating to hands-on database design to ensure that you are getting the concepts down. I plan to hold 13 lab sessions in class throughout the semester, and each is worth 10 points. I will drop your lowest lab grade instead of allowing make-up labs, but please attend all of the labs for your own sake.

Policies

Students are expected to be at every class meeting on time, and are responsible for all class content, whether present or not. If absence from class is necessary, in-class work (other than quizzes) and homework may be made up only if the instructor is notified as soon as possible; in particular, absences due to scheduled events must be arranged ahead of time. Academic dishonesty will not be tolerated, and will be dealt with according to UAF procedures. Students in this class must pay the CS lab fee.

UAF academic policies http://www.uaf.edu/catalog/current/academics

CS Department policies http://www.cs.uaf.edu/departmental-policies/

Disabilities Services:

The UAF Office of Disability Services implements the Americans with Disabilities Act (ADA), and ensures that UAF students have equal access to the campus and course materials. I will work with the UAF Office of Disability Services (208 WHITAKER BLDG, 474-5655) to provide reasonable accommodation to students with disabilities.

Updated: