Tentative schedule
(revised regularly - requires Refresh/Reload on the browser)

No.

Day

Date

Topics

Reading List

Chapters

1

Tue

8/25

Database, DB architecture, Data redundancy, database, tables, rows, columns, DBMS

Database architecture, Schema structure, Logical schema representation,  Database: advantages & disadv; Sample databases: Company, Henry books, Premiere products

2

Thu

8/27

E-R Diagram, Relational model: set theory, 2-D tables, primary key, Query languages: template, algebra, calculus, English

 Relational algebra (WinRDBI): union, intersect, difference, Asg1+

3

Tue

9/1

Relational algebra operations: select, project, product,  njoin, division: shopping database

Relational calculus: tuple and domain

4

Thu

9/3

Relational algebra and calculus queries

SQL: DDL statements: create, drop, alter; table creation, data types, schema, syntax structure

5

Tue

9/8

-Asg1, SQL: DML statements: insert, update, delete, select

SQL retrieval queries: update queries, Asg2+

6

Thu

9/10

SQL multi-table queries, join

Additional SQL queries, Views, indexes, Integrity constraints, system catalog

7

Tue

9/15

-Asg2, Examples for view definition, index, trigger

8

Thu

9/17

Functional dependence, primary key, Normal forms 1NF and 2NF

Normalization: 3NF, Asg4, Asg3+

Mid-term exam (5:00 - 6:30pm)

9

Tue

9/22

Multivalued dependence, 4NF

Normalization process, ER schema, Asg4+

10

Thu

9/24

-Asg3, DB design methodology, keys, relationships

Embedded SQL: host language program, cursor, Asg5

11

Tue

9/29

Java interface to SQL, Asg5+

12

Thu

10/1

-Asg4, DBMS functions: support queries, catalog service, Concurrent update, recovery,

13

Tue

10/6

File structures: blocking factor, spanned vs unspanned, ordered vs unordered, hashed files. Dynamic and extendible hashed files

Indexing structures: Single level vs Multi Level, Dense vs Nondense, index types (primary, clustering, secondary), reduced average disk access through index, B_Tree   and B+_Tree structures

14

Thu

10/8

Data warehouse, data mining, web interface to DBMS

Fri

10/9

Final exam (5:00 - 6:30pm)