Day

Date

Subject

Pre-reading

M

8/27

Introduction to databases

Chapter 1

W

8/29

Database applications examples

Sections 11.4.1-2

F

8/31

Database environment

Chapter 2

M

9/3

Labor Day (NO CLASS)

W

9/5

Database architectures and Web applications

Chapter 3

F

9/7

Relational database model

Chapter 4

M

9/10

Entity-relationship (ERD’s) modeling

Chapter 12

W

9/12

ERD’s examples

Appendix C

F

9/14

Database system lifecycle

Chapter 10

M

9/17

Rosh Hashanah (NO CLASS)

W

9/19

Conceptual data modeling

Chapter 16

F

9/21

Conceptual data modeling examples

M

9/24

Normalization

Chapter 14

W

9/26

Yom Kippur (NO CLASS)

F

9/28

Normalization examples

M

10/1

Logical data modeling

Chapter 17

W

10/3

Logical data modeling examples

F

10/5

Physical database design

Chapter 18

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

W

10/17

FIRST MIDTERM

F

10/19

SQL queries examples

M

10/22

SQL queries examples

W

10/24

SQL queries examples

F

10/26

SQL commands

Chapter 7

M

10/29

SQL commands examples

W

10/31

Advanced SQL Queries

F

11/2

Query-By-Example

Chapter 9

M

11/5

Database security

Chapter 20

W

11/7

Transaction management

Chapter 22

F

11/9

Review

M

11/12

SECOND MIDTERM

W

11/14

Professional, legal, and ethical concerns

Chapter 21

F

11/16

Web database development

Chapter 30

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

W

12/5

OLAP

Chapter 34

F

12/7

Advanced topics in databases: the future

W

12/12

10:30am – 12:30pm

FINAL PROJECT PRESENTATIONS