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.

Tentative Schedule

1. Thu, Jan 15

   Introduction; Syllabus; Lab 0: Lab Machine Familiarization

   • Read Chapter 1, 2, & 7; Assignment 1

2. Mon, Jan 19

   Alaska Civil Rights Day (no classes, most offices closed)

3. Tue, Jan 20

   Chapter 7 Data Modeling Using the Entity-Relationship Model

   • Read Chapter 8; Assignment 2

4. Thu, Jan 22

   Lab 1

   • Assignment 1 Due

5. Tue, Jan 27

   Chapter 8 The Enhanced Entity-Relationship Model

   • Read Chapter 3; Assignment 3

6. Thu, Jan 29

   Lab 2

   • Assignment 2 Due

7. Fri, Jan 30

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

8. Tue, Feb 03

   Chapter 3 Relational Data Model & Relational Database Constraints

   • Read Chapter 4; Assignment 4

9. Thu, Feb 05

   Lab 3

   • Assignment 3 Due

10. Tue, Feb 10

    Chapter 4 Basic SQL

    • Read Chapter 5; Assignment 5

11. Thu, Feb 12

    Lab 4

    • Assignment 4 Due

12. Sun, Feb 15

    Deadline to apply for Spring 2015 graduation

13. Tue, Feb 17

    Chapter 5 More SQL: Complex Queries, Triggers, Views & Schema Modification

    • Read Chapter 9; Assignment 6

14. Thu, Feb 19

    Lab 5

    • Assignment 5 Due

15. Tue, Feb 24

    Chapter 9 DB Design By ER- & EER-to-Relational Mapping

    • Assignment 7

16. Thu, Feb 26

    Lab 6

    • Assignment 6 Due

17. Tue, Mar 03

    Lab 7; Project discussion

18. Thu, Mar 05

    MIDTERM EXAM

19. Tue, Mar 10

    MIDTERM EXAM

    • Read Chapter 10

20. Thu, Mar 12

    Chapter 10 Practical Database Design Methodology & Use of UML Diagrams; PROJECT IDEAS DUE

    • Assignment 7 Due; Read Chapter 12; Assignment 8

21. Fri, Mar 13

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

22. Tue, Mar 17

    SPRING BREAK

23. Thu, Mar 19

    SPRING BREAK

24. Tue, Mar 24

    Chapter 12 XML: Extensible Markup Language

    • Read Chapter 14; Assignment 9: Mid-Project Presentation preparation

25. Thu, Mar 26

    Lab 8

    • Assignment 8 Due

26. Tue, Mar 31

    Web Database Programming Using Django

    • Read Chapter 15; Assignment 10

27. Thu, Apr 02

    MID-PROJECT PRESENTATIONS

28. Tue, Apr 07

    Lab 9

    • Read Chapter 16; Assignment 11

29. Thu, Apr 09

    Chapter 15 Basics of Functional Dependencies & Normalization for Relational Databases

    • Assignment 10 due

30. Tue, Apr 14

    Lab 10: Individual Projects

    • Read Chapter 20; Assignment 12

31. Thu, Apr 16

    Chapter 16 Relational Database Design Algorithms & Further Dependencies

    • Assignment 11 Due

32. Tue, Apr 21

    Lab 11 Individual Projects

    • Assignment 13

33. Thu, Apr 23

    Chapter 20 Physical Database Design & Tuning

    • Assignment 12 Due

34. Fri, Apr 24

    SpringFest (no classes)

35. Tue, Apr 28

    FINAL EXAM

36. Thu, Apr 30

    FINAL EXAM

    • Assignment 13 Due

37. Mon, May 04

    Last day of instruction

38. Fri, May 08

    PROJECT PRESENTATIONS: 1:00pm – 3:00pm

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

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.

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.