Spring 2025 (01/25/2025 - 05/22/2025)

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 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

Ex1. Creating E-R diagrams (Due: Tuesday, February 11)
Ex2. Creating E-R diagrams (Due: Thursday, February 13)
Ex3. (Optional) Creating E-R diagrams (Due: Thursday, February 18)

Group Programming Project

Phase 1. Group Forming and Project Proposal (Due: Tuesday, February 11)

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

Ex1. Creating E-R diagrams (Due: Tuesday, February 11)
Ex2. Creating E-R diagrams (Due: Thursday, February 13)
Ex3. (Optional) Creating E-R diagrams (Due: Thursday, February 18)

Group Programming Project

Phase 1. Group Forming and Project Proposal (Due: Tuesday, February 11)

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 Project Presentation (Phase 1)

Individual Assignment

Ex4. Relational Model (Due: Tuesday, Feburary 18, 2025)
Ex5. E-R Model to Relational Model (Due: Thursday, February 20, 2025)
(Optional) Ex6. E-R Model to Relational Model (Handling Weak Entity) (Due: Thursday, February 27, 2025)
(Optional) Ex7. E-R Model to Relational Model (Handling ISA relationship) (Due: Thursday, February 27, 2025)

Group Programming Project

Phase 2. Creating E-R Model (Due: Tuesday, February 25, 2025)

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 Project Presentation (Phase 1)

Individual Assignment

Ex4. Relational Model (Due: Tuesday, Feburary 18, 2025)
Ex5. E-R Model to Relational Model (Due: Thursday, February 20, 2025)
(Optional) Ex6. E-R Model to Relational Model (Handling Weak Entity) (Due: Thursday, February 27, 2025)
(Optional) Ex7. E-R Model to Relational Model (Handling ISA relationship) (Due: Thursday, February 27, 2025)

Group Programming Project

Phase 2. Creating E-R Model (Due: Tuesday, February 25, 2025)

Reading

Chapter 3

Notice: Conversion day, classes follow Monday schedule

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 Project Presentation (Phase 1)

Individual Assignment

Ex4. Relational Model (Due: Tuesday, Feburary 18, 2025)
Ex5. E-R Model to Relational Model (Due: Thursday, February 20, 2025)
(Optional) Ex6. E-R Model to Relational Model (Handling Weak Entity) (Due: Thursday, February 27, 2025)
(Optional) Ex7. E-R Model to Relational Model (Handling ISA relationship) (Due: Thursday, February 27, 2025)

Group Programming Project

Phase 2. Creating E-R Model (Due: Tuesday, February 25, 2025)

Reading

Chapter 3

Topics: defining relations in SQL; working with a DBMS

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 Accessing WEB Linux Host and Maria DBMS

Individual Assignment

Ex8. Experimenting with Linux hosts and DBMS access (Due: Thursday, February 27)
Ex9. Declaring Relations in SQL (Due: Thursday, February 27)
Ex10. Modifying Relations in SQL (Due: Thursday, February 27)

Group Programming Project

Phase 3. Improving E-R Model and Designing and Implementing Relational Database Schema (Due: Tuesday, March 4)

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)

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

TBA

Group Programming Project

TBA
TBA

Reading

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

TBA

Group Programming Project

TBA
TBA

Reading

Notice: Conversion day, classes follow Wednesday schedule

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

TBA

Group Programming Project

TBA
TBA

Reading

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

TBA

Group Programming Project

TBA
TBA

Reading

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

TBA

Group Programming Project

TBA
TBA

Reading

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

TBA

Group Programming Project

TBA

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

TBA

Group Programming Project

TBA

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

TBA

Group Programming Project

TBA

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

TBA

Group Programming Project

TBA

Reading

Chapter 6

Notice: Spring Recess - No classes scheduled

Notice: Spring Recess - No classes scheduled

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

TBA

Group Programming Project

TBA

Reading

Chapter 6

Topics: ordering; eliminating duplicates; aggregate processing; grouping; subquery and table; self join and multiple-table join; database views; stored procedures via PL/SQL;

Lecture Notes

(Review) Declaring Relations in SQL
(Review) Modifiying Relations in SQL
(Review) Simple Queries in Relational Algebra and in SQL
(Review) Products and Joins in Relational Algebra and in SQL
More about Relational Database Operations - Part A
More about Relational Database Operations - Part B (subquery)
More about Relational Database Operations - Part C (Views)
More about Relational Database Operations - Part D (PSM)

Individual Assignment

TBA

Group Programming Project

TBA

Reading

Topics: ordering; eliminating duplicates; aggregate processing; grouping; subquery and table; self join and multiple-table join; database views; stored procedures via PL/SQL;

Lecture Notes

(Review) Declaring Relations in SQL
(Review) Modifiying Relations in SQL
(Review) Simple Queries in Relational Algebra and in SQL
(Review) Products and Joins in Relational Algebra and in SQL
More about Relational Database Operations - Part A
More about Relational Database Operations - Part B (subquery)
More about Relational Database Operations - Part C (Views)
More about Relational Database Operations - Part D (PSM)

Individual Assignment

TBA

Group Programming Project

TBA

Reading

Topics: ordering; eliminating duplicates; aggregate processing; grouping; subquery and table; self join and multiple-table join; database views; stored procedures via PL/SQL;

Lecture Notes

(Review) Declaring Relations in SQL
(Review) Modifiying Relations in SQL
(Review) Simple Queries in Relational Algebra and in SQL
(Review) Products and Joins in Relational Algebra and in SQL
More about Relational Database Operations - Part A
More about Relational Database Operations - Part B (subquery)
More about Relational Database Operations - Part C (Views)
More about Relational Database Operations - Part D (PSM)

Individual Assignment

TBA

Group Programming Project

TBA

Reading

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

TBA

Reading

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

Lecture Notes

Final Review
Sample Final Exam

Reading

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

Lecture Notes

Final Review
Sample Final Exam

Reading

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

Lecture Notes

Final Review
Sample Final Exam

Reading

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