Spring 2022 (01/28/2022 - 05/24/2022)

The semester has 29 class meetings including the final exam. Clicking on a class day below, you should find the class module for the day including lecture notes, assignments, and others. The instructor releases the content for a class generally on the Monday before the class. However, the instructor often makes update to the module content after the initial release. You should check this page often for up-to-date content.

In case you encounter a problem when viewing class content, such as, a broken link, please report it to the instructor immediately.

Topics: data vs. information; concept of database; type of databases; importance of database design; database vs. files main component and main functions

Course Objectives

to understand broadly database concepts and database management software
to understand the database development process

Lecture Notes

Course Overview Database Basics

Reading

Sections 1.1 - 1.8

Topics: data vs. information; concept of database; type of databases; importance of database design; database vs. files main component and main functions

Course Objectives

to understand broadly database concepts and database management software
to understand the database development process

Lecture Notes

Course Overview Database Basics

Reading

Sections 1.1 - 1.8

Notice: Conversion Day - Classes follow Friday schedule

Topics: data model; data modeling; entities and relationship; entity-relationship model

Course Objectives

to understand broadly database concepts and database management software
to understand the database development process

Lecture Notes

Data Model and Data Modeling E-R model

Reading

Chapters 2

Topics: identify entity relationship components; define and refine relationships between entities; create conceptual model using E-R diagrams

Course Objectives

to understand the relational model and relational database management system
to be able to access an application's data requirements using conceptual modeling tools like E-R diagrams

Lecture Notes

Conceptual Design via E-R Modeling Constraints in E-R Modeling Design Considerations in E-R Modeling

Individual Assignment

Creating E-R diagrams -- Q1 and Q2 (Due: end-of-day, Monday, February 14)
Creating E-R diagrams -- Q3 (Due: end-of-day, Thursday, February 17)

Group Programming Project

Phase 1. Creating E-R Model (Due: end-of-day, Thursday, February 24)

Reading

Chapter 4

Topics: identify entity relationship components; define and refine relationships between entities; create conceptual model using E-R diagrams

Course Objectives

to understand the relational model and relational database management system
to be able to access an application's data requirements using conceptual modeling tools like E-R diagrams

Lecture Notes

Conceptual Design via E-R Modeling Constraints in E-R Modeling Design Considerations in E-R Modeling

Individual Assignment

Creating E-R diagrams -- Q1 and Q2 (Due: end-of-day, Monday, February 14)
Creating E-R diagrams -- Q3 (Due: end-of-day, Thursday, February 17)

Group Programming Project

Phase 1. Creating E-R Model (Due: end-of-day, Thursday, February 24)

Reading

Chapter 4

Topics: attributes, schemas, tuples, domains, relation instance, keys of relations; database schema; defining a relation schema in SQL convert E-R model to relational database schema; convert entity sets to relations; convert relationships to relations; convert ISA hierarchies to relations

Course Objectives

to understand the database development process
to understand the relational model and relational database management system
to be able to access an application's data requirements using conceptual modeling tools like E-R diagrams

Lecture Notes

Basics of Relational Database Models Converting E-R Model to Relational Database Models

Individual Assignment

Relational Model (Q4) (Due: 11:59pm, Thursday, Feburary 24, 2022)
E-R Diagram to Relational Schemas (Q5) (Due: 11:59pm, Tuesday, March 1, 2022)

Reading

Chapter 3

Topics: attributes, schemas, tuples, domains, relation instance, keys of relations; database schema; defining a relation schema in SQL convert E-R model to relational database schema; convert entity sets to relations; convert relationships to relations; convert ISA hierarchies to relations

Course Objectives

to understand the database development process
to understand the relational model and relational database management system
to be able to access an application's data requirements using conceptual modeling tools like E-R diagrams

Lecture Notes

Basics of Relational Database Models Converting E-R Model to Relational Database Models

Individual Assignment

Relational Model (Q4) (Due: 11:59pm, Thursday, Feburary 24, 2022)
E-R Diagram to Relational Schemas (Q5) (Due: 11:59pm, Tuesday, March 1, 2022)

Reading

Chapter 3

Topics: defining relations in SQL; relational algebra; set operations on relations; projection; selection; cartesian product; natural joins; theta-joins; combining operations to form queries

Course Objectives

to be able to access an application's data requirements using conceptual modeling tools like E-R diagrams
to be able to design database schemas (or a logical model) based on the conceptual model
to be able to realize the database schemas (or the logical model) using a relational database management system (RDBMS) by writing SQL commands to create tables and indices
to be able to insert, update, delete, and query data from the database using SQL statements in the RDBMS

Lecture Notes

Declaring Relations in SQL Modifiying Relations in SQL Relational Algebra on Sets Relational Algebra on Bags Simple Queries in Relational Algebra and in SQL Products and Joins in Relational Algebra and in SQL

Individual Assignment

Test Linux hosts and DBMS access (Due: end-of-day, Tuesday, March 1)
Handling Weak Entity -- Q6 (Due: end-of-day, Thursday, March 3)
Handling ISA relationship -- Q7 (Due: end-of-day, Thursday, March 3)
Declaring Relations in SQL -- Q8 (Due: end-of-day, Tuesday, March 8)
Modifying Relations in SQL -- Q9 (Due: end-of-day, Tuesday, March 10)
Relational Algebra on Sets -- Q10 (Due: end-of-day, Tuesday, March 17)
Relational Algebra on Sets -- Q11 (Due: end-of-day, Tuesday, March 22)

Group Programming Project

Phase 2. Improving E-R Model in Group (Due: end-of-day, Thursday, March 3)
Phase 3. Designing and Implementing Relational Database Schema (Due: end-of-day, Thursday, March 30)

Reading

Sections 7.1 (SQL data types), 8.1 and 8.2 (Relation declaration), 8.3 (Altering Structures of Relation), 8.4 (Modifying Relations), Sections 3.4 (Relational Algebra)
MariaDB Commands

Topics: defining relations in SQL; relational algebra; set operations on relations; projection; selection; cartesian product; natural joins; theta-joins; combining operations to form queries

Course Objectives

to be able to access an application's data requirements using conceptual modeling tools like E-R diagrams
to be able to design database schemas (or a logical model) based on the conceptual model
to be able to realize the database schemas (or the logical model) using a relational database management system (RDBMS) by writing SQL commands to create tables and indices
to be able to insert, update, delete, and query data from the database using SQL statements in the RDBMS

Lecture Notes

Declaring Relations in SQL Modifiying Relations in SQL Relational Algebra on Sets Relational Algebra on Bags Simple Queries in Relational Algebra and in SQL Products and Joins in Relational Algebra and in SQL

Individual Assignment

Test Linux hosts and DBMS access (Due: end-of-day, Tuesday, March 1)
Handling Weak Entity -- Q6 (Due: end-of-day, Thursday, March 3)
Handling ISA relationship -- Q7 (Due: end-of-day, Thursday, March 3)
Declaring Relations in SQL -- Q8 (Due: end-of-day, Tuesday, March 8)
Modifying Relations in SQL -- Q9 (Due: end-of-day, Tuesday, March 10)
Relational Algebra on Sets -- Q10 (Due: end-of-day, Tuesday, March 17)
Relational Algebra on Sets -- Q11 (Due: end-of-day, Tuesday, March 22)

Group Programming Project

Phase 2. Improving E-R Model in Group (Due: end-of-day, Thursday, March 3)
Phase 3. Designing and Implementing Relational Database Schema (Due: end-of-day, Thursday, March 30)

Reading

Sections 7.1 (SQL data types), 8.1 and 8.2 (Relation declaration), 8.3 (Altering Structures of Relation), 8.4 (Modifying Relations), Sections 3.4 (Relational Algebra)
MariaDB Commands

Topics: defining relations in SQL; relational algebra; set operations on relations; projection; selection; cartesian product; natural joins; theta-joins; combining operations to form queries

Course Objectives

to be able to access an application's data requirements using conceptual modeling tools like E-R diagrams
to be able to design database schemas (or a logical model) based on the conceptual model
to be able to realize the database schemas (or the logical model) using a relational database management system (RDBMS) by writing SQL commands to create tables and indices
to be able to insert, update, delete, and query data from the database using SQL statements in the RDBMS

Lecture Notes

Declaring Relations in SQL Modifiying Relations in SQL Relational Algebra on Sets Relational Algebra on Bags Simple Queries in Relational Algebra and in SQL Products and Joins in Relational Algebra and in SQL

Individual Assignment

Test Linux hosts and DBMS access (Due: end-of-day, Tuesday, March 1)
Handling Weak Entity -- Q6 (Due: end-of-day, Thursday, March 3)
Handling ISA relationship -- Q7 (Due: end-of-day, Thursday, March 3)
Declaring Relations in SQL -- Q8 (Due: end-of-day, Tuesday, March 8)
Modifying Relations in SQL -- Q9 (Due: end-of-day, Tuesday, March 10)
Relational Algebra on Sets -- Q10 (Due: end-of-day, Tuesday, March 17)
Relational Algebra on Sets -- Q11 (Due: end-of-day, Tuesday, March 22)

Group Programming Project

Phase 2. Improving E-R Model in Group (Due: end-of-day, Thursday, March 3)
Phase 3. Designing and Implementing Relational Database Schema (Due: end-of-day, Thursday, March 30)

Reading

Sections 7.1 (SQL data types), 8.1 and 8.2 (Relation declaration), 8.3 (Altering Structures of Relation), 8.4 (Modifying Relations), Sections 3.4 (Relational Algebra)
MariaDB Commands

Topics: defining relations in SQL; relational algebra; set operations on relations; projection; selection; cartesian product; natural joins; theta-joins; combining operations to form queries

Course Objectives

to be able to access an application's data requirements using conceptual modeling tools like E-R diagrams
to be able to design database schemas (or a logical model) based on the conceptual model
to be able to realize the database schemas (or the logical model) using a relational database management system (RDBMS) by writing SQL commands to create tables and indices
to be able to insert, update, delete, and query data from the database using SQL statements in the RDBMS

Lecture Notes

Declaring Relations in SQL Modifiying Relations in SQL Relational Algebra on Sets Relational Algebra on Bags Simple Queries in Relational Algebra and in SQL Products and Joins in Relational Algebra and in SQL

Individual Assignment

Test Linux hosts and DBMS access (Due: end-of-day, Tuesday, March 1)
Handling Weak Entity -- Q6 (Due: end-of-day, Thursday, March 3)
Handling ISA relationship -- Q7 (Due: end-of-day, Thursday, March 3)
Declaring Relations in SQL -- Q8 (Due: end-of-day, Tuesday, March 8)
Modifying Relations in SQL -- Q9 (Due: end-of-day, Tuesday, March 10)
Relational Algebra on Sets -- Q10 (Due: end-of-day, Tuesday, March 17)
Relational Algebra on Sets -- Q11 (Due: end-of-day, Tuesday, March 22)

Group Programming Project

Phase 2. Improving E-R Model in Group (Due: end-of-day, Thursday, March 3)
Phase 3. Designing and Implementing Relational Database Schema (Due: end-of-day, Thursday, March 30)

Reading

Sections 7.1 (SQL data types), 8.1 and 8.2 (Relation declaration), 8.3 (Altering Structures of Relation), 8.4 (Modifying Relations), Sections 3.4 (Relational Algebra)
MariaDB Commands

Topics: defining relations in SQL; relational algebra; set operations on relations; projection; selection; cartesian product; natural joins; theta-joins; combining operations to form queries

Course Objectives

to be able to access an application's data requirements using conceptual modeling tools like E-R diagrams
to be able to design database schemas (or a logical model) based on the conceptual model
to be able to realize the database schemas (or the logical model) using a relational database management system (RDBMS) by writing SQL commands to create tables and indices
to be able to insert, update, delete, and query data from the database using SQL statements in the RDBMS

Lecture Notes

Declaring Relations in SQL Modifiying Relations in SQL Relational Algebra on Sets Relational Algebra on Bags Simple Queries in Relational Algebra and in SQL Products and Joins in Relational Algebra and in SQL

Individual Assignment

Test Linux hosts and DBMS access (Due: end-of-day, Tuesday, March 1)
Handling Weak Entity -- Q6 (Due: end-of-day, Thursday, March 3)
Handling ISA relationship -- Q7 (Due: end-of-day, Thursday, March 3)
Declaring Relations in SQL -- Q8 (Due: end-of-day, Tuesday, March 8)
Modifying Relations in SQL -- Q9 (Due: end-of-day, Tuesday, March 10)
Relational Algebra on Sets -- Q10 (Due: end-of-day, Tuesday, March 17)
Relational Algebra on Sets -- Q11 (Due: end-of-day, Tuesday, March 22)

Group Programming Project

Phase 2. Improving E-R Model in Group (Due: end-of-day, Thursday, March 3)
Phase 3. Designing and Implementing Relational Database Schema (Due: end-of-day, Thursday, March 30)

Reading

Sections 7.1 (SQL data types), 8.1 and 8.2 (Relation declaration), 8.3 (Altering Structures of Relation), 8.4 (Modifying Relations), Sections 3.4 (Relational Algebra)
MariaDB Commands

Topics: defining relations in SQL; relational algebra; set operations on relations; projection; selection; cartesian product; natural joins; theta-joins; combining operations to form queries

Course Objectives

to be able to access an application's data requirements using conceptual modeling tools like E-R diagrams
to be able to design database schemas (or a logical model) based on the conceptual model
to be able to realize the database schemas (or the logical model) using a relational database management system (RDBMS) by writing SQL commands to create tables and indices
to be able to insert, update, delete, and query data from the database using SQL statements in the RDBMS

Lecture Notes

Declaring Relations in SQL Modifiying Relations in SQL Relational Algebra on Sets Relational Algebra on Bags Simple Queries in Relational Algebra and in SQL Products and Joins in Relational Algebra and in SQL

Individual Assignment

Test Linux hosts and DBMS access (Due: end-of-day, Tuesday, March 1)
Handling Weak Entity -- Q6 (Due: end-of-day, Thursday, March 3)
Handling ISA relationship -- Q7 (Due: end-of-day, Thursday, March 3)
Declaring Relations in SQL -- Q8 (Due: end-of-day, Tuesday, March 8)
Modifying Relations in SQL -- Q9 (Due: end-of-day, Tuesday, March 10)
Relational Algebra on Sets -- Q10 (Due: end-of-day, Tuesday, March 17)
Relational Algebra on Sets -- Q11 (Due: end-of-day, Tuesday, March 22)

Group Programming Project

Phase 2. Improving E-R Model in Group (Due: end-of-day, Thursday, March 3)
Phase 3. Designing and Implementing Relational Database Schema (Due: end-of-day, Thursday, March 30)

Reading

Sections 7.1 (SQL data types), 8.1 and 8.2 (Relation declaration), 8.3 (Altering Structures of Relation), 8.4 (Modifying Relations), Sections 3.4 (Relational Algebra)
MariaDB Commands

Topics: Q & A for Midterm Exam.

Lecture Notes

Midterm Review Mock Midterm Exam

Reading

all chapters or sections discussed

Topics: The instructor will hold a midterm exam in class

Topics: Recap for data modeling, E-R modeling, relational models, relational databases, relational algebra and SQL

Course Objectives

to understand broadly database concepts and database management software
to understand the database development process
to understand the relational model and relational database management system
to be able to access an application's data requirements using conceptual modeling tools like E-R diagrams
to be able to design database schemas (or a logical model) based on the conceptual model
to be able to realize the database schemas (or the logical model) using a relational database management system (RDBMS) by writing SQL commands to create tables and indices
to be able to insert, update, delete, and query data from the database using SQL statements in the RDBMS

Lecture Notes

Midterm Recap

Topics: concept and role of normalization; normal forms (1NF, 2NF, 3NF, BCNF, and 4NF) transformation; model evaluation using normalization; denormalization vs. normalization; using data-modeling checklist

Lecture Notes

Anomaly and Functional Dependency Normalization and Normal Forms

Individual Assignment

Functional Dependencies (Q12) (Due: end-of-day, Tuesday, April 12)
Normal Form and Normalization (Q13) (Due: end-of-day, Tuesday, April 14)

Group Programming Project

Phase 4. Revising the Database Design via Database Normalization and Denormalization (Due: end-of-day, Thursday, April 26)

Reading

Chapter 6

Topics: concept and role of normalization; normal forms (1NF, 2NF, 3NF, BCNF, and 4NF) transformation; model evaluation using normalization; denormalization vs. normalization; using data-modeling checklist

Lecture Notes

Anomaly and Functional Dependency Normalization and Normal Forms

Individual Assignment

Functional Dependencies (Q12) (Due: end-of-day, Tuesday, April 12)
Normal Form and Normalization (Q13) (Due: end-of-day, Tuesday, April 14)

Group Programming Project

Phase 4. Revising the Database Design via Database Normalization and Denormalization (Due: end-of-day, Thursday, April 26)

Reading

Chapter 6

Topics: concept and role of normalization; normal forms (1NF, 2NF, 3NF, BCNF, and 4NF) transformation; model evaluation using normalization; denormalization vs. normalization; using data-modeling checklist

Lecture Notes

Anomaly and Functional Dependency Normalization and Normal Forms

Individual Assignment

Functional Dependencies (Q12) (Due: end-of-day, Tuesday, April 12)
Normal Form and Normalization (Q13) (Due: end-of-day, Tuesday, April 14)

Group Programming Project

Phase 4. Revising the Database Design via Database Normalization and Denormalization (Due: end-of-day, Thursday, April 26)

Reading

Chapter 6

Topics: concept and role of normalization; normal forms (1NF, 2NF, 3NF, BCNF, and 4NF) transformation; model evaluation using normalization; denormalization vs. normalization; using data-modeling checklist

Lecture Notes

Anomaly and Functional Dependency Normalization and Normal Forms

Individual Assignment

Functional Dependencies (Q12) (Due: end-of-day, Tuesday, April 12)
Normal Form and Normalization (Q13) (Due: end-of-day, Tuesday, April 14)

Group Programming Project

Phase 4. Revising the Database Design via Database Normalization and Denormalization (Due: end-of-day, Thursday, April 26)

Reading

Chapter 6

Topics: concept and role of normalization; normal forms (1NF, 2NF, 3NF, BCNF, and 4NF) transformation; model evaluation using normalization; denormalization vs. normalization; using data-modeling checklist

Lecture Notes

Anomaly and Functional Dependency Normalization and Normal Forms

Individual Assignment

Functional Dependencies (Q12) (Due: end-of-day, Tuesday, April 12)
Normal Form and Normalization (Q13) (Due: end-of-day, Tuesday, April 14)

Group Programming Project

Phase 4. Revising the Database Design via Database Normalization and Denormalization (Due: end-of-day, Thursday, April 26)

Reading

Chapter 6

Notice: Spring Recess - No classes scheduled

Notice: Spring Recess - No classes scheduled

Topics: selected advanced topcis (index; transaction; database connectivity)

Lecture Notes

Introduction to Database Index Introduction to Database Transaction Introduction to Database Programming Environment

Individual Assignment

Views, Index, and Transactions -- Q15 (Due: end-of-day, Tuesday, March 10)

Reading

Sections 3.8, 8-2d; 10.1; 15.1

Topics: Group project presentation and demonstration; Final review; Q & A for Final Exam

Lecture Notes

Final Review Sample Final Exam

Reading

Relevant chapters in the textbook; lecture notes; review guides and tests; project;

Topics: Group project presentation and demonstration; Final review; Q & A for Final Exam

Lecture Notes

Final Review Sample Final Exam

Reading

Relevant chapters in the textbook; lecture notes; review guides and tests; project;

Topics: Group project presentation and demonstration; Final review; Q & A for Final Exam

Lecture Notes

Final Review Sample Final Exam

Reading

Relevant chapters in the textbook; lecture notes; review guides and tests; project;

Topics: According to the College's schedule, the final exam is at Room 329 Ingersoll Externsion 8:00 - 10:00AM, Thursday, May 19, 2022.