Lecture notes




Day

Date

Subject

Pre-reading

Lecture Notes

M

8/27

Introduction to databases

Chapter 1

notes #1

W

8/29

Database applications examples

Sections 11.4.1-2

notes #2

F

8/31

Database environment

Chapter 2

notes #3

M

9/3

Labor Day (NO CLASS)

 

 

W

9/5

Database architectures and Web applications

Chapter 3

notes #4

F

9/7

Relational database model

Chapter 4

notes #5

M

9/10

Entity-relationship (ERD’s) modeling

Chapter 12

notes #6

W

9/12

ERD’s examples

Appendix C

 

F

9/14

Database system lifecycle

Chapter 10

notes #7

M

9/17

Rosh Hashanah (NO CLASS)

 

 

W

9/19

Conceptual data modeling

Chapter 16

notes #8

F

9/21

Conceptual data modeling examples

 

 

M

9/24

Normalization

Chapter 14

notes #9

W

9/26

Yom Kippur (NO CLASS)

 

 

F

9/28

Normalization examples

 

 

M

10/1

Logical data modeling

Chapter 17

notes #10

W

10/3

Logical data modeling examples

 

 

F

10/5

Physical database design

Chapter 18

notes #11

M

10/8

Physical database design examples

 

 

W

10/10

Example of database system design

Appendix A, B

 

F

10/12

Review

 

 

M

10/15

SQL queries

Chapter 6

notes #12

W

10/17

FIRST MIDTERM

 

 

F

10/19

SQL queries examples

 

sales database

M

10/22

SQL queries

 

 

W

10/24

SQL queries examples

 

 

F

10/26

SQL commands

Chapter 7

notes #13

M

10/29

SQL commands examples

 

 

W

10/31

Advanced SQL queries

 

notes #14
peer review form

F

11/2

Query By Example

Chapter 9

 

M

11/5

Database security

Chapter 20

notes #15

W

11/7

Transaction management

Chapter 22

notes #16

F

11/9

Review

 

 

M

11/12

SECOND MIDTERM

 

 

W

11/14

Professional, legal, and ethical concerns

Chapter 21

notes #17

F

11/16

Web database development

Chapter 30

notes #18

M

11/19

Web database development with PHP & MySQL - language

 

 

W

11/21

Thanksgiving (NO CLASS)

 

 

F

11/23

Thanksgiving (NO CLASS)

 

 

M

11/26

Web database development with PHP & MySQL - forms

 

 

W

11/28

Web database development with PHP & MySQL - queries

 

 

F

11/30

Distributed databases

Chapter 24

 

M

12/3

Data warehousing concepts

Chapter 32

notes #19

W

12/5

OLAP

Chapter 34

 

F

12/7

Advanced topics in databases: the future

 

notes #20

W

12/12

10:30am – 12:30pm

FINAL PROJECT PRESENTATIONS

 

 

 

 

 

 

 

 

[Home] [Syllabus] [Lecture notes] [Presentations] [Schedule] [Assignments] [Project] [Turn-in area] [Message board] [Communication] [Links] [Tests] [Grades]