CS425 Database Systems

Course
73353
Section
F01
Credits
3 + 0
Prerequisites:
  • CS311
  • CS321
Instructor
John Quan
Phone
907-474-7098
Office
Duckering 529
Email
jquan2@alaska.edu
Office Hours
By Appointment
MWF
Meeting Time
Room
Duckering 536
Course Website
/courses/cs425/2018-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

    • 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
    • LABOR DAY (offices closed — no classes, registration or fee payment)
    • Chapter 3 continued
      • Assignment 1 due; Assignment 2
    • Last day for student- and faculty-initiated drops with refund (course does not appear on academic record)
    • Lab 1: ER Diagramming
      • Read Chapter 4
    • Deadline for tuition and fee payment; 5 p.m. in person, midnight at UAOnline
    • Chapter 4: The EER Model
    • 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
    • Chapter 7 continued
      • Assignment 5 due; Assignment 6
    • Lab 5: MySQL from the Command Line
      • Read Chapter 9
    • Early progress reports due
    • Chapter 9: Relational Database Design by ER- and EER-to-Relational Mapping
    • Chapter 9 continued
      • Assignment 7
    • Lab 6: MySQL Workbench
      • Assignment 6 due
    • Lab 7: MySQL Workbench continued
    • Deadline to apply for fall 2018 graduation
    • Deadline to apply for admission for spring semester (graduate students)
    • 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
    • Chapter 13 continued
    • Spring 2019 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
      • Assignment 10
    • Assignment 9 MID-PROJECT PRESENTATION due
    • Begin spring and WINTERmester 2019 priority registration (UAF degree students)
    • Chapter 15 continued
      • Read Chapter 24
    • Lab 10: Django-CMS continued
    • Lab 10: Django-CMS continued
      • Assignment 11
    • THANKSGIVING (no classes, most offices closed) Wednesday-Sunday, Nov. 21-25
    • THANKSGIVING (no classes, most offices closed) Wednesday-Sunday, Nov. 21-25
    • Chapter 24: NoSQL Databases and Big Data Storage
      • Assignment 10 due
    • Begin spring and WINTERmester 2019 open registration (all UAF, UAA and UAS students, including nondegree students)
    • Lab 12: Node.js and MongoDB
      • Assignment 11 due
    • FINAL EXAM
    • FINAL EXAM
    • FINAL EXAM
    • PROJECT PRESENTATIONS I
    • Last day of instruction
    • PROJECT PRESENTATIONS II, 1 - 3 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%)

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.

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: