Slides: Introduction to Databases & Database Environment/Architecture

---

Video: Introduction to Databases

Video: Three-Level Architecture

Video: Data Models

Video: Advantages, Disadvantages & Examples of DBMS

(Due on Thursday 9/3/2026 by 11:59 p.m.)

• Homework #1
  1. In your own words, describe the Three-Level Architecture: External, Conceptual, and Internal.
  
  
  2. What is the difference between the relational, hierarchical and network approaches to database management systems.
  3. Complete the homework in your own words. DO NOT copy answers from other students or from the internet. plagiarism is NOT tolerated. All your work should be unique and done by yourself.
  4. Submit your answers as a PDF file to Homework #1 Dropbox on D2L. Any other formats will not be graded.

Slides: SQL Basics

---

Video: Login to phpMyAdmin

Video: Create & Insert Statements

Video: Select Statements

Video: Distinct Values

Video: Update & Delete Statements

Video: Ordering Results

Video: Pattern Matching

---

Login Information:

1. Go to phpMyAdmin
2. Enter your phpMyAdmin username and password.
3. Your phpMyAdmin username your NEIU username, No spaces. For example, if your NEIU username is "jsmith", your phpMyAdmin username is "jsmith".
4. Your initial phpMyAdmin password is your NEIU ID# followed by "_CS315_", followed by the first 3 characters of your NEIU username, No spaces. For example, if your NEIU ID# is "123456" and NEIU username is "jsmith", your phpMyAdmin username is "123456_CS315_jsm".
5. Click on Go and you are logged in now.

(Due on Thursday 9/10/2026 by 11:59 p.m.)

• Homework #2

Slides: SQL Continued

---

Video: Functions

Video: Aggregates

Video: GROUP BY

Video: Subqueries

Video: Inner Join

Video: Outer Join

Video: DATE

(Due on Thursday 9/17/2026 by 11:59 p.m.)

• Homework #3

SQL Practice

SQL Practice

Slides: Relational Model

---

Video: Primary Keys

Video: Composite Keys

Video: Foreign Keys

Video: Primary Key Example

Video: Foreign Key Example

(Due on Thursday 10/8/2026 by 11:59 p.m.)

• Homework #4

(Due on Thursday 10/8/2026 by 11:59 p.m.)

• Final Project Topic

(Due on Friday 10/2/2026 AT 11:59 p.m.)

• Quiz #1

  The quiz will be available on Thursday 10/1/2026 at 7:00 am and is due on Friday 10/2/2026 at 11:59 pm.
  

Slides: Views

---

Video: Auto Increment & Not Null

Video: Alter Tables

Video: Default Values

Video: Unique Values

Video: Views, Part I

Video: Views, Part II

(Due on Thursday 10/15/2026 by 11:59 p.m.)

• Homework #5

Slides: DBMS Lifecycle/Fact-Finding Techniques

Slides: ER Modeling

---

Video: Entity Relationship Modeling, Part I

Video: Entity Relationship Modeling, Part II

Video: Entity Relationship Modeling, Part III

(Due on Thursday 10/23/2026 by 11:59 p.m.)

• Homework #6

(Due on Thursday 10/29/2026 by 11:59 p.m.)

• Project ER Diagram

Slides: Enhanced ER Modeling

(Due on Friday 10/30/2026 AT 11:59 p.m.)

• Midterm

  The midterm will be available on Thursday 10/29/2026 at 7:00 am and is due on Friday 10/30/2026 at 11:59 pm.
  

Slides: Normalization

(Due on Thursday 11/12/2026 by 11:59 p.m.)

• Homework #7

(Due on Thursday 12/3/2026 by 11:59 p.m.)

• Database Implementation & Java Program of Final Project

Slides: Methodology for Database Design / Database Issues

(Due on Thursday 12/3/2026 by 11:59 p.m.)

• Database Implementation & Java Program of Final Project

Work on Final Project

(Due on Thursday 12/3/2026 by 11:59 p.m.)

• Database Implementation & Java Program of Final Project

(Due on Tuesday 11/24/2026 AT 11:59 p.m.)

• Quiz #2

  The quiz will be available on Monday 11/23/2026 at 7:00 am and is due on Tuesday 11/24/2026 at 11:59 pm.
  

Work on Final Project

(Due on Thursday 12/3/2026 by 11:59 p.m.)

• Database Implementation & Java Program of Final Project