CPSC 343 Database Theory and Practice Fall 2017

CPSC 343 Schedule

Reading and class prep exercises are to be done for the class period where they are listed. "Additional Reading" is optional and is provided if you want greater depth. "Elmasri and Navathe" refers to Fundamentals of Database Systems, 5th edition; this book has been placed on reserve in the library.

Dates for things in light gray are for planning purposes and may be adjusted slightly.

 Assignments

Week 1: 8/28-9/1

Topics: course introduction; introduction to data modeling and database design; conceptual models (ER)

   

Mon Materials:

Additional Reading:

  • Elmasri and Navathe, chapters 1 and 2
   

Wed Reading:

Class Prep: available on Canvas

Materials:

Additional Reading:

  • Elmasri and Navathe, sections 3.1-3.5
   

Fri Reading:

Materials:

Additional Reading:

  • Elmasri and Navathe, sections 3.7.2-3.7.3 and 3.9
   

Week 2: 9/4-9/8

Topics: the entity-relationship model; the relational model

   

Mon Materials:    

Wed Reading:

Class Prep: available on Canvas

Materials:

Additional Reading:

  • Elmasri and Navathe, chapter 4 through section 4.5.2
  project team survey
due Fri Sep 8

(available on Canvas under Quizzes)

Fri Reading:

Class Prep: available on Canvas

Materials:

Additional Reading:

  • Elmasri and Navathe, sections 5.1-5.2
  • chapters 20, 21, 22 of Elsmasri and Navathe deal with the object-oriented databases - chapter 21 is the best place to start if you are interested in alternatives to the relational model
homework 1
ER modeling

due Fri Sep 15

solutions: #1, #3

Week 3: 9/11-9/15

Topics: ER-to-relational mapping; relational design principles, decomposition and normalization

 

Mon Reading:

Materials:

Additional Reading:

  • Elmasri and Navathe, chapter 7
project specifications
due Mon Sep 25

(teams are listed near the beginning)

Wed Reading:

Materials:

Additional Reading:

  • Elmasri and Navathe, section 10.1

Fri Reading:

Class Prep: available on Canvas

Materials:

Additional Reading:

  • Elmasri and Navathe, sections 10.2-10.6 (also chapter 11 for more advanced material that is beyond what we'll do in class)
 

Week 4: 9/18-9/22

Topics: decomposition and normalization; SQL: data definition, SELECT/PROJECT/JOIN

 

Mon Materials: homework 2
ER-to-relational mapping and normalization

due Mon Sep 25

solutions: #1, #3, #4

Wed Reading:

Class Prep: available on Canvas (MySQL Workbench installation)

Materials:

Additional Reading:

  • Elmasri and Navathe, sections 8.1-8.3

Fri Reading:

Class Prep: available on Canvas

Materials:

Additional Reading:

  • Elmasri and Navathe, sections 8.4-8.5.1

Week 5: 9/25-9/29

Topics: SQL: set operations, subqueries, aggregation and grouping


Mon Reading:

Class Prep: available on Canvas

Materials:

Additional Reading:

  • Elmasri and Navathe, section 8.5.2.-8.5.6
homework 1
ER modeling

#2, #4 due Fri Sep 29


homework 2
ER-to-relational mapping and normalization

#2, #5 due Fri Sep 29


(you must hand in something to get credit - either the new solution if you redo a problem or the original solution if you don't - but you don't need to hand in both new and original solutions for the same problem)
project specifications peer review
due Fri Sep 29

Wed Materials:

Fri Reading:

Materials:

Additional Reading:

  • Elmasri and Navathe, section 8.5.7-8.5.8
exam 1 (take home)
due Wed 10/4 in class

review information
 

Week 6: 10/2-10/6

Topics: SQL: queries, data modification

 

Mon Materials:  

Wed Reading:

Materials:

Additional Reading:

  • Elmasri and Navathe, section 8.6
  project conceptual model
due Wed Oct 18

Fri Materials:  

Week 7: 10/9-10/13

Topics: security and controlling access; views

 

Mon fall break
(no class)

Wed Materials: homework 3
SQL

due Wed Oct 18

Fri Reading:

Materials:

Additional Reading:

  • Elmasri and Navathe, section 8.8

Week 8: 10/16-10/20

Topics: controlling access: stored routines


Mon Reading:

Materials:


Wed Materials:   project conceptual model peer review
due Mon Oct 23

Fri Materials:  

Week 9: 10/23-10/27

Topics: data integrity: assertions, triggers, transactions; DB applications

 

Mon Reading:   project database design
due Fri Nov 3

Wed Reading:  

Fri    

Week 10: 10/30-11/3

Topics:

 

Mon    

Wed    

Fri   exam 2 (take home)
due Wed 11/8 in class
 

Week 11: 11/6-11/10

Topics:

 

Mon    

Wed      

Fri      

Week 12: 11/13-11/17

Topics:

   

Mon     project implementation

Wed    

Fri    

Week 13: 11/20-11/24

Topics:

 

Mon    

Wed Thanksgiving break
(no class)

Fri

Week 14: 11/27-12/1

Topics:

 

Mon    

Wed    

Fri    

Week 15: 12/4-12/8

Topics:

 

Mon    

Wed    

Fri   final exam (take home)
due Tue 12/12 at 11:30am
 

Reading Period: 12/9-12/11

 

Sat    

Sun    

Mon    

Exams: 12/12-12/15

 

Tue   end-of-semester deadline
no work accepted after 12/12 11:30am

Wed      

Thu      

Fri      

Valid HTML 4.01!