CSCI 4/5560: Database Management Systems
Sect.
001
|
Lecture
|
M W
|
12:40pm
2:05pm
|
KOM
452
|
Tentative Schedule
|
|
Date |
Lecture
Topic |
Homework
& Projects |
|
Week
1 |
Aug.
23 |
Chapter 1: syllabus, main characteristics of database approach, database, DBMS |
|
|
Aug.
25 |
Chapter 2: advantages of database approach, Data model,
database schema, database state, relational model (relation, relation
schema/state) |
|
|
|
Week 2 |
Aug. 30 |
Relational Model: Super key,
key, constraints
(key, entity integrity, referential integrity), insert/update/delete operations |
Homework 1 assigned |
|
Sep. 1 |
Relational Algebra: constraint violation (CASCADE, SET DEFAULT, SET NULL),
SELECT, PROJECT, RENAME, |
||
|
Week
3 |
Sep.
6 |
Labor Day. No
Class. |
|
|
Sep.
8 |
Relational
Algebra: UNION, INTERSECT, DIFFERENCE, Union
Compatibility, CARTESIAN PRODUCT, INNER/OUTER JOIN (Example) |
Homework
2 assigned |
|
|
Week 4 |
Sep. 13 |
Relational Algebra: Homework1, Aggregate Functions, DIVISION, |
|
|
Sep. 15 |
Relational Algebra: Aggregate
functions, Exercise |
Video: HowToAccessMSSQL |
|
|
Week
5 |
Sep.
20 |
SQL: went over homework, Data type, CREATE |
|
|
Sep.
22 |
First Exam (Week 1 Week 4): |
||
|
Week 6 |
Sep. 27 |
SQL: Went over 1st
exam. DDL (create, drop, alter) example; COMPANY Schema |
|
|
Sep. 29 |
SQL: DML(Insert, Update, Delete), SELECT,
FROM, Where clause (IN, BETWEEN
AND
, IS, LIKE, AND, OR, ALL, SOME/ANY,
EXISTS), three-valued logic |
Homework 3 assigned |
|
|
Week
7 |
Oct.
4 |
SQL:
IS, LIKE, ALL, SOME/ANY, EXISTS. GROUP BY,
HAVING, Order by, UNION, INTERSECT, MINUS |
|
|
Oct.
6 |
SQL:
Inner/Outer Join, Division, Examples |
||
|
Week 8 |
Oct. 11 |
Fall Break No class |
|
|
Oct. 13 |
SQL: Exercise on SQL query |
Homework 4 assigned |
|
|
Week
9 |
Oct.
18 |
SQL Programming: SQL
Injection Vulnerability |
|
|
Oct.
20 |
SQL
Programming: JDBC (Example),
LINQ (Example), MySQL and PHP Document, Entity Type and its attributes |
Homework
5 assigned |
|
|
Week 10 |
Oct. 25 |
Entity-Relationship
Model: HW4 solution,
Relationship, Weak Entity Type, cardinality constraint and participation
constraint, ER design guidance |
|
|
Oct. 27 |
Second Exam (Week 5 Week 9) |
||
|
Week
11 |
Nov.
1 |
Entity-Relationship
Model: Go over 2nd exam |
|
|
Nov.
3 |
Enhanced ER Model: super/sub-class,
generalization/specialization, disjointness/completeness
constraints, Union/Category |
Homework
6 assigned |
|
|
Week 12 |
Nov. 8 |
||
|
Nov. 10 |
MS
SQL: variable
declaration and assignment, IF, WHILE (example), CASE, CURSOR
(example 1, 2, 3) |
|
|
|
Week
13 |
Nov.
15 |
MS
SQL: Stored Procedure (Examples: 1, 2, 3) and functions (Example) |
|
|
Nov.
17 |
Homework
7 assigned |
||
|
Week 14 |
Nov. 22 |
MS SQL: |
|
|
Nov. 24 |
Thanksgiving Holidays No class |
|
|
|
Week
15 |
Nov.
29 |
Third Exam (Week 10 Week 15) |
|
|
Dec.
1 |
Go over 3rd
exam |
|
|
|
Week 16 |
Dec. 6 |
Final Exam: 12:30 2:30 |
|
Class Resources
|
Please
take your time to go through the syllabus carefully and with patience. |
|
|
All
class examples, assignments, and source codes are available in this
directory. |