CS425 Database Systems

Course
36593
Section
F01
Credits
3 + 0
Prerequisites:
  • CS311
  • CS321
Instructor
John Quan
Phone
907-474-7098
Office
Chapman 201C
Email
jquan2@alaska.edu
Office Hours
MWF
By Appointment
Meeting Time
Room
Chapman 104
Course Website
/courses/cs425/2015-spring/
Required Texts
Fundamentals of Database Systems (w/Access code) Edition: 6th ISBN: 9780136086208 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; Lab 0: Lab Machine Familiarization
      • Read Chapter 1, 2, & 7; Assignment 1
    • Alaska Civil Rights Day (no classes, most offices closed)
    • Chapter 7 Data Modeling Using the Entity-Relationship Model
      • Read Chapter 8; Assignment 2
    • Lab 1
      • Assignment 1 Due
    • Chapter 8 The Enhanced Entity-Relationship Model
      • Read Chapter 3; Assignment 3
    • Lab 2
      • Assignment 2 Due
    • Deadline for student- and faculty-initiated drops (course does not appear on academic record)
    • Chapter 3 Relational Data Model & Relational Database Constraints
      • Read Chapter 4; Assignment 4
    • Lab 3
      • Assignment 3 Due
    • Chapter 4 Basic SQL
      • Read Chapter 5; Assignment 5
    • Lab 4
      • Assignment 4 Due
    • Deadline to apply for Spring 2015 graduation
    • Chapter 5 More SQL: Complex Queries, Triggers, Views & Schema Modification
      • Read Chapter 9; Assignment 6
    • Lab 5
      • Assignment 5 Due
    • Chapter 9 DB Design By ER- & EER-to-Relational Mapping
      • Assignment 7
    • Lab 6
      • Assignment 6 Due
    • Lab 7; Project discussion
    • MIDTERM EXAM
    • MIDTERM EXAM
      • Read Chapter 10
    • Chapter 10 Practical Database Design Methodology & Use of UML Diagrams; PROJECT IDEAS DUE
      • Assignment 7 Due; Read Chapter 12; Assignment 8
    • Deadline for student- and faculty-initiated withdrawals (W grade appears on academic transcript)
    • SPRING BREAK
    • SPRING BREAK
    • Chapter 12 XML: Extensible Markup Language
      • Read Chapter 14; Assignment 9: Mid-Project Presentation preparation
    • Lab 8
      • Assignment 8 Due
    • Web Database Programming Using Django
      • Read Chapter 15; Assignment 10
    • MID-PROJECT PRESENTATIONS
    • Lab 9
      • Read Chapter 16; Assignment 11
    • Chapter 15 Basics of Functional Dependencies & Normalization for Relational Databases
      • Assignment 10 due
    • Lab 10: Individual Projects
      • Read Chapter 20; Assignment 12
    • Chapter 16 Relational Database Design Algorithms & Further Dependencies
      • Assignment 11 Due
    • Lab 11 Individual Projects
      • Assignment 13
    • Chapter 20 Physical Database Design & Tuning
      • Assignment 12 Due
    • SpringFest (no classes)
    • FINAL EXAM
    • FINAL EXAM
      • Assignment 13 Due
    • Last day of instruction
    • PROJECT PRESENTATIONS: 1:00pm – 3:00pm

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 drop your lowest assignment grade instead of allowing make-up homework, but please do all homework for your own sake. TURN IN ASSIGNMENTS BEFORE CLASS BEGINS ON THE DAYS IDENTIFIED BY THE SCHEDULE UNLESS OTHERWISE SPECIFIED.

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 11 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. Payment allows access to the Chapman 103 lab.

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: