CS425 Database Systems

Course
76704
Section
F01
Credits
3 + 0
Prerequisites:
  • CS311 or CS321
Instructor
John Quan
Phone
907-474-7098
Office
Chapman 201C
Email
jquan2@alaska.edu
Office Hours
MWF
By Appointment
Meeting Time
Room
Chapman room 103
Course Website
/courses/cs425/2017-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.

Course Outcomes

  • Understand the relational model and relational database constraints
  • Design, develop, and query relational databases
  • Understand trade-offs in design decisions
  • Perform database normalization and test for normal forms
  • Design, develop, and query eXtensible Markup Language documents
  • Explore NoSQL and Big Data Systems

Tentative Schedule

    • First day of instruction; late registration begins
    • Introduction; Lab 0; Syllabus
      • Skim Chapter 1 & 2
    • Chapter 1: Databases and Database Users; Chapter 2: Database System Concepts and Architecture
      • Read Chapter 3; Assignment 1
    • Chapter 3: Data Modeling Using the ER Model
    • Deadline to apply for admission for spring semester (international students)
    • LABOR DAY
    • Chapter 3 continued
      • Assignment 1 due; Assignment 2
    • Lab 1: ER Diagramming
      • Read Chapter 4
    • Deadline for adding classes and late registration; 5 p.m. in person, midnight at UAOnline
    • Last day for student- and faculty-initiated drops with refund (course does not appear on academic record)
    • Chapter 4: The EER Model
    • Deadline for tuition and fee payment; 5 p.m. in person, midnight at UAOnline
    • Chapter 4 continued; Lab 2: EER Diagramming
      • Assignment 2 due; Assignment 3
    • Lab 2: EER Diagramming continued
      • 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
    • Early progress reports due
    • 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
    • Lab 6: MySQL Workbench
      • Assignment 6 due
    • Deadline to apply for admission for spring semester (graduate students)
    • Lab 7: MySQL Workbench continued
    • Deadline to apply for fall 2017 graduation
    • 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
    • Spring 2018 course list available at UAOnline
    • Lab 8: XPath & XQuery
      • Assignment 8; Read Chapter 14
    • Deadline to apply for admission for spring semester (undergraduate students)
    • Chapter 14: Basics of Functional Dependencies and Normalization for Relational Databases
    • Last day for student- and faculty-initiated withdrawals (W grade appears on academic transcript)
    • Chapter 14 continued
      • Assignment 9 MID-PROJECT PRESENTATION
    • Lab 9: Django-CMS
      • Assignment 8 due; Read Chapter 15
    • Chapter 15: Relational Database Design Algorithms and Further Dependencies
    • Chapter 15 continued
      • Assignment 9 MID-PROJECT PRESENTATION due; Assignment 10
    • Begin registration and fee payment for degree students for spring 2018 semester and WINTERmester 2018
    • 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
    • Begin registration and fee payment for nondegree students for spring 2018 semester and WINTERmester 2018
    • Lab 12: Node.js and MongoDB continued
    • THANKSGIVING
    • THANKSGIVING
    • Chapter 25: Big Data Technologies Based on MapReduce
    • Lab 13: Hadoop
      • Assignment 11 due
    • Lab 14: Hadoop continued
    • FINAL EXAM
    • FINAL EXAM
    • FINAL EXAM
    • Last day of instruction
    • PROJECT PRESENTATIONS, 1 - 3 p.m.
    • Deadline for faculty to post grades, noon

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%)

Affirmative Action/Equal Opportunity

The University of Alaska Board of Regents have clearly stated in BOR policy that discrimination, harassment and violence will not be tolerated on any campus of the University of Alaska. If you believe you are experiencing discrimination or any form of harassment, including sexual harassment/misconduct/assault, you are encouraged to report that behavior. If you disclose sexual harassment or sexual violence to faculty members or university employees, they must notify the UAF Title IX coordinator about the basic facts of the incident. Your choices for disclosure include:

  1. You may confidentially disclose and access confidential counseling by contacting the UAF Health and Counseling Center at 474-7043.
  2. You can get support and file a Title IX report by contacting the UAF Title IX coordinator at 474-7599.
  3. You may file a criminal complaint by contacting the UAF Police Department at 474-7721.

From Disability Services: UAF is obligated to provide accommodation only to the known limitations of an otherwise qualified student who has a disability. Please identify yourself to UAF Disability Services by applying for accommodations. To be considered for UAF Disability Services accommodations, individuals must be enrolled for at least one credit as a UAF student. For more information contact Disability Services at uaf-disabilityservices@alaska.edu, 474-5655 or by TTY at 474-1827.

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. 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: