Database Systems

Home Syllabus Schedule Resources Extensions Contact

Course Outline:

 

Date:

In-class Activities Planned:

Readings/Material Covered:

Outside Assignments:

Due Date:

Week 1

 

 

•  Lecture on database systems and database models.

•  Discussion on outside class group project

 

RC: Chapter 1 & 2

Homework from textbook RC assigned in the class.

For week 2

Week 2

 

 

•  Lecture on Entity Relationship Modeling and Normalization of database tables.

•  Case study: Online retail store database.

•  Finalizing outside class projects and groups.

 

 

RC: Chapter 3 & 4

Homework from textbook RC assigned in the class.

 

Completed proposal of outside class project.

For week 3

Week 3

 

•  Quiz 1

•  Lecture on SQL.

•  Introduction to Microsoft SQL Server.

 

 

 

Homework from textbook RC assigned in the class.

For week 4

Week 4

 

 

•  Lecture on advanced SQL.

•  Implementing databases and writing queries using SQL Server.

 

RC: Chapter 5

 

Homework from textbook RC assigned in the class

Project checkpoint 1

For week 5

Week 5

 

 

•  Review for mid-term examination.

•  Mid-term examination

 

RC: Chapter 6 & 7

Homework from textbook RC assigned in the class

For week 6

Week 6

 

 

•  Lecture on advanced database concepts like Transaction and Concurrency Control.

•  Practicing SQL queries.

RC: Chapter 8 & 9

Homework from textbook RC assigned in the class

 

For week 7

Week 7

 

 

•  Quiz 2

•  Lecture on distributed database management systems

•  Practicing advanced SQL queries.

RC: Chapter 10

Homework from textbook RC assigned in the class

 

project checkpoint 2

For week 8

Week 8

 

 

•  Lecture on Client Server computing and data warehousing

•  Practicing advanced SQL queries.

 

RC: Chapter 12 & 13

Homework from textbook RC assigned in the class

For week 9

Week 9

 

 

•  Lecture on web database development and database administration

•  Practicing advanced SQL queries.

RC: Chapter 15 & 16

Homework from textbook RC assigned in the class

project checkpoint 3

 

For week 10

Week 10

 

•  Student Presentations

 

 

Review for final exam

For week 11

Week 11

•  Final Examination

 

 

 

 
Home        Courses        Interaction        Resources        Grades        Contact