IT420 Course Schedule

 

Lectures:

 

 

Date

Topic (click on link for slides)

Remarks

1

January 11, 2006

Data modeling with Entity-Relationship model

 

2

January 13, 2006

Finish Entity-Relationship Model

Read Chapter 5

3

January 18, 2006

The relational model

First part of Chapter 3

4

January 20, 2006

Mapping ER diagrams to relational model

Read Chapter 6

5

January 25, 2006

SQL DDL + DML

Read Chapters 7 and 2

6

January 27, 2006

More SQL

Lab 2 is due today.

7

February 1, 2006

Normalization

Read Chapter 3

8

February 3, 2006

Normalization

Read Chapter 4

9

February 8, 2006

more SQL

Chapter 2, Chapter 7

10

February 10, 2006

SQL sub-queries, joins

 

11

February 15, 2006

SQL views

Chapter 7

12

February 17, 2006

SQL triggers, stored procedures

Chapter 7

13

February 22, 2006

6 week exam review

 

14

February 24, 2006

More SQL triggers, stored procedures

Chapter 7, Chapter 11

15

March 1, 2006

PHP - files

 

16

March 3, 2006

MySQL

 

17

March 8, 2006

MySQL - PHP connectivity

createVp5FundTables.txt

18

March 10, 2006

PHP - Write reusable code

 

19

March 22, 2006

Authentication

 

20

March 24, 2006

Authentication - part2

Read Chapter 9

21

March 29, 2006

DB administration, Transactions

Chapter 9, Chapter 11

22

March 31, 2006

Transactions part 2

 

23

April 5, 2006

IT420_12WeekReview.ppt

 

24

April 12, 2006

DB Security , Recovery

 

25

April 14, 2006

Storage and index structures

Chapter 8 Overview of Storage and Indexing

in Ramakrishnan&Gehrke: Database Management Systems

26

April 19, 2006

Index Structures

 

27

April 21, 2006

Intro to XML

Chapter 13

28

 

Data warehousing and decision support Guest speaker

 

29

April 26, 2006

Ethics EthicsQuestions.doc

 

30

April 28, 2006

Wrap-up, review

 

 

 

Labs:

 

 

Date

Topic

Remarks

Solutions

1

January 10, 2006

Introduction to DB, Intro to Access

Access Tutorial

 

2

January 17, 2006

ER Modeling

Lab 1 Due Today.

Lab 2 (ER Modeling lab) due on January 27.

Lab2_ERModeling_Solutions

3

January 24, 2006

Database design: ER to relational model

Lab 3 (ER To Relational model) due on January 31.

 

4

January 31, 2006

SQL

 

 

Lab 4 (SQL) due on February 7, 2006.

InstructionsForDatabaseConnection.doc

 

Lab4_SQL_Solutions

5

February 7, 2006

Normal forms lab

Lab5_1NF.sql

 

6

February 14, 2006

6 week exam

 

 

7

February 21, 2006

SQL Views LAB

sqlserver_arena.sql

Lab7_SQLViews_Solutions

8

February 28, 2006

PHP slides PHP Lab Intro

vp5order_start.html

Lab8_PHPintro_Solutions

9

March 7, 2006

PHP files, MySQL

 

Lab9_PHPfiles_MySQL_Solutions

10

March 21, 2006

Lab_PHP_MySQL_connection.doc

SampleDatabaseApplication_songs.doc

Lab10_PHP_MYSQL_Connection_Solutions

11

March 28, 2006

Project2 part1 - Authentication Lab11_SQLQueries.doc

 

Lab11_SQL_Queries_Solutions

12

April 4, 2006

Locks, Transactions

MarciaTables.sql

 

13

April 11, 2006

Project 2 part 2

 

 

14

April 18, 2006

Project 2 part 3

nclcaDB.sql sampleHTML.html

 

15

 

Online processing, XML lab, Web services