360 Database and Data Modeling

  MySQL Manual

All dates, lecture topics, assignments, in-class exercises are subject to 
reasonable change at the discretion of your instructor.  Any changes will be announced.

Day  01 02 03 04 05 06 07 08 09 10   11
bullet


Week

Day

Topic

Assignments(Kroenke 5th/Fehily 3rd)

1

 

1

bullet

Introduction  

bullet

DB Models

K: Chap. 1

HW 1

2

bullet

Development  

bullet

Crow's Foot

bullet

ER Model

 

2

 

3

Simple Tables

K: Chap. 2

HW 2

4

Relations and Keys

 

    Database Courseware  

3

 

5

Constraints

K: Chap. 3

HW 3

6

Normalization

K: Chap. 5

F: Chap. 2, pgs 45-50

4

 

7

Relationships

K: Chap. 4

F: Chap. 2, pgs 33-44, Chap. 11

HW 4

8

Many-to-Many, WHERE clause

K: Chap. 4

5

 

9

Review

K: Chap. 3

10

Midterm

 

6

 

11

Relational Algebra, Subqueries

F: Chaps. 3, 4, 8, 9, 11, 10

Handout

HW 5

12

Two-Table Joins

F: Chap. 7 K: Chap. 3

7

 

13

bullet

Multi-Table Joins  

bullet

SQLzoo

K: Chap. 3

HW 6

14

bullet

Advanced Attributes  

bullet

MySQL JDBC Driver

bullet

JDBC Drivers

bulletJDBC Tutorial
bulletJDBC Resources

K: Chap. 4

8

 

15

Subtypes and Supertypes

K: Chap. 4

HW 7

16

Functions

F: Chap. 5

9

 

17

Advanced SQL Queries

F: Chap. 6

18

Advanced Database Design

K: Chap. 6

10

 

19

Review

 

20

Final Part I: Practicum

 

11

 

Finals Week

Final Part II
2/29/12(W) 12:30-2:30PM

 

top