CS425 Database Systems

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

1. Mon, Aug 27

   Introduction; Lab 0; Syllabus

   • Skim Chapter 1 & 2

2. Wed, Aug 29

   Chapter 1: Databases and Database Users; Chapter 2: Database System Concepts and Architecture

   • Read Chapter 3; Assignment 1

3. Fri, Aug 31

   Chapter 3: Data Modeling Using the ER Model

4. Mon, Sep 03

   LABOR DAY (offices closed — no classes, registration or fee payment)

5. Wed, Sep 05

   Chapter 3 continued

   • Assignment 1 due; Assignment 2

6. Fri, Sep 07

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

7. Fri, Sep 07

   Lab 1: ER Diagramming

   • Read Chapter 4

8. Mon, Sep 10

   Deadline for tuition and fee payment; 5 p.m. in person, midnight at UAOnline

9. Mon, Sep 10

   Chapter 4: The EER Model

10. Wed, Sep 12

    Chapter 4 continued; Lab 2: EER Diagramming

    • Assignment 2 due; Assignment 3

11. Fri, Sep 14

    Lab 2: EER Diagramming continued

    • Read Chapter 5

12. Mon, Sep 17

    Chapter 5: The Relational Data Model and Relational Database Constraints

13. Wed, Sep 19

    Chapter 5 continued

    • Assignment 4

14. Fri, Sep 21

    Lab 3: Managing MySQL from the Command Line

    • Assignment 3 due; Read Chapter 6

15. Mon, Sep 24

    Chapter 6: Basic SQL

16. Wed, Sep 26

    Chapter 6 continued

    • Assignment 4 due; Assignment 5

17. Fri, Sep 28

    Lab 4: Managing MySQL from the Command Line continued

    • Read Chapter 7

18. Mon, Oct 01

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

19. Wed, Oct 03

    Chapter 7 continued

    • Assignment 5 due; Assignment 6

20. Fri, Oct 05

    Lab 5: MySQL from the Command Line

    • Read Chapter 9

21. Mon, Oct 08

    Early progress reports due

22. Mon, Oct 08

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

23. Wed, Oct 10

    Chapter 9 continued

    • Assignment 7

24. Fri, Oct 12

    Lab 6: MySQL Workbench

    • Assignment 6 due

25. Mon, Oct 15

    Lab 7: MySQL Workbench continued

26. Mon, Oct 15

    Deadline to apply for fall 2018 graduation

27. Mon, Oct 15

    Deadline to apply for admission for spring semester (graduate students)

28. Wed, Oct 17

    MIDTERM REVIEW; PROJECT Discussion

    • Assignment 7 due

29. Fri, Oct 19

    MIDTERM EXAM

30. Mon, Oct 22

    MIDTERM EXAM

31. Wed, Oct 24

    MIDTERM EXAM

    • Read Chapter 13

32. Fri, Oct 26

    Chapter 13: XML: eXtensible Markup Language

    • Chapter 13 continued

33. Mon, Oct 29

    Chapter 13 continued

34. Mon, Oct 29

    Spring 2019 course list available at UAOnline

35. Wed, Oct 31

    Lab 8: XPath & XQuery

    • Assignment 8; Read Chapter 14

36. Thu, Nov 01

    Deadline to apply for admission for spring semester (undergraduate students)

37. Fri, Nov 02

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

38. Fri, Nov 02

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

39. Mon, Nov 05

    Chapter 14 continued

    • Assignment 9 MID-PROJECT PRESENTATION

40. Wed, Nov 07

    Lab 9: Django-CMS

    • Assignment 8 due; Read Chapter 15

41. Fri, Nov 09

    Chapter 15: Relational Database Design Algorithms and Further Dependencies

    • Assignment 10

42. Mon, Nov 12

    Assignment 9 MID-PROJECT PRESENTATION due

43. Mon, Nov 12

    Begin spring and WINTERmester 2019 priority registration (UAF degree students)

44. Wed, Nov 14

    Chapter 15 continued

    • Read Chapter 24

45. Fri, Nov 16

    Lab 10: Django-CMS continued

46. Mon, Nov 19

    Lab 10: Django-CMS continued

    • Assignment 11

47. Wed, Nov 21

    THANKSGIVING (no classes, most offices closed) Wednesday-Sunday, Nov. 21-25

48. Fri, Nov 23

    THANKSGIVING (no classes, most offices closed) Wednesday-Sunday, Nov. 21-25

49. Mon, Nov 26

    Chapter 24: NoSQL Databases and Big Data Storage

    • Assignment 10 due

50. Mon, Nov 26

    Begin spring and WINTERmester 2019 open registration (all UAF, UAA and UAS students, including nondegree students)

51. Wed, Nov 28

    Lab 12: Node.js and MongoDB

    • Assignment 11 due

52. Fri, Nov 30

    FINAL EXAM

53. Mon, Dec 03

    FINAL EXAM

54. Wed, Dec 05

    FINAL EXAM

55. Fri, Dec 07

    PROJECT PRESENTATIONS I

56. Sat, Dec 08

    Last day of instruction

57. Mon, Dec 10

    PROJECT PRESENTATIONS II, 1 - 3 p.m.

Grading Policies

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.