CSCI 410: Database Management Systems


Message Board


Lecture Notes

Week

Date

Slides (handouts)

Readings

1M Aug 28 Lec1
CM 1, 2, 3.1-3.4
EM 1, 2
1W Aug 30
2M Sep 4*(Labor day) Lec2
CM 3.6, 4
EM 3
2W Sep 6
3M Sep 11
3W Sep 13
4M

Sep 18

Lec3

CM 5, 6
EM 4, 14, 15
4W

Sep 20

5M

Sep 25

5W

Sep 27

Lec4

Left outer: https://www.tutorialspoint.com/sql/sql-left-joins.htm
Right outer: https://www.w3schools.com/sql/sql_join_right.asp
Full outer: https://www.w3schools.com/sql/sql_join_full.asp
CM 7, 8, 9, EM 6, 7.1
6M Oct 2@(Exam 1)
6W

Oct 4

7M Oct 9 Lec5
7W Oct 11
8M Oct 16*(Fall break)
8W Oct 18 Lec6 CM 14
9M Oct 23
Lec 7
Case study
EM 9
EM 12
9W Oct 25
10M Oct 30

Lec 8

CM 10
EM 19
10W Nov 1@(Exam 2)
11M

Nov 6

11W Nov 8
12M

Nov 13

Lec 9

CM 13
EM 27
12W

Nov 15

13M Nov 20
13W Nov 22*(Thanksgiving)
Lec 10
CM Appendix G
EM 20, 21, 22
14M Nov 27
14W Nov 29
Lec 11
CM 15, EM 23
15M Dec 4
15W Dec 6

Lec 12

 
16

December

Final exam

 
 
EM: Fundamentals of Database Systems, 7th Ed. (Elmasri)
CM: Database Systems: Design, Implementation, and Management 11th Ed. (Coronel & Morris)

Assignments (Please submit your assignments to csci410.001@gmail.com with corresponding Assignment # in the subject line. Please name your files with Firstname_Lastname.):


Lessons (If you commit the same error already documented here, penalty will double):

Project 1:

Home work 1:

Project 2:

Home work 2:

Project 3:

Lab works 1 & 2:

Project 4:

Project 5:

Home work 3:

Home work 4:


Materials

Database instructions

Editor vi instructions