| Mon Sep 11, 2023 |
Discussion Topic Introduce Yourself to the Class |
due by 11:59pm |
| Assignment Practice Exercise- Sample Database Tutorial Basic SELECT Statement |
due by 11:59pm |
| Assignment Practice Exercise- Sample Database Tutorial Basic SELECT Statement with AND Operator |
due by 11:59pm |
| Assignment Practice Exercise- Sample Database Tutorial Basic SELECT Statement with OR Operator |
due by 11:59pm |
| Assignment Practice Exercise- Single Table Query - Student |
due by 11:59pm |
| Mon Sep 18, 2023 |
Discussion Topic Discussion 1 Chapter 1 |
due by 11:59pm |
| Discussion Topic Discussion 2 Chapter 1 |
due by 11:59pm |
| Quiz Quiz Chapter 1 |
due by 11:59pm |
| Assignment Assignment: Single Table Queries: House Table |
due by 11:59pm |
| Mon Sep 25, 2023 |
Quiz Data Models Quiz CIS 205 |
due by 11:59pm |
| Discussion Topic Discussion Assignment 1 Chapter 2 |
due by 11:59pm |
| Discussion Topic Discussion Assignment 2 Chapter 2 |
due by 11:59pm |
| Discussion Topic Discussion Assignment Ethics: Information Ownership |
due by 11:59pm |
| Discussion Topic Discussion Assignment: What is Information? |
due by 11:59pm |
| Assignment Homework Assignment: Single Table Query - Phone Database |
due by 11:59pm |
| Assignment Practice Exercise: Chen Diagramming |
due by 11:59pm |
| Assignment Practice Exercise: Crows Foot Diagramming |
due by 11:59pm |
| Mon Oct 2, 2023 |
Discussion Topic Discussion Assignment 1: Chapter 3 |
due by 11:59pm |
| Discussion Topic Discussion Assignment 2: Chapter 3 |
due by 11:59pm |
| Discussion Topic Discussion Assignment: Unstructured Data |
due by 11:59pm |
| Quiz Relational Data modeling Quiz CIS 205 |
due by 11:59pm |
| Assignment Homework Assignment: Create an ER Diagram for the Animal Pet Rescue Database |
due by 11:59pm |
| Assignment Practice Exercise: ER Diagramming - Pizza Delivery Shop |
due by 11:59pm |
| Mon Oct 9, 2023 |
Discussion Topic Discussion 1 Chapter 4 |
due by 11:59pm |
| Discussion Topic Discussion 2 Chapter 4 |
due by 11:59pm |
| Discussion Topic Discussion Assignments: Data Engineer |
due by 11:59pm |
| Quiz ERD / Metadata Quiz |
due by 11:59pm |
| Assignment Homework Assignment: Translation to Relational Schema and Creating Metadata for the Homework Assignment: Translate the ER Diagram for the Animal Pet Rescue Database |
due by 11:59pm |
| Mon Oct 16, 2023 |
Quiz Advance Data Modeling Quiz CIS 205 |
due by 11:59pm |
| Discussion Topic Discussion - Interpretation of the Generalization and Specialization Hierarchy |
due by 11:59pm |
| Discussion Topic Discussion - What is a surrogate primary key, and when would you use one? |
due by 11:59pm |
| Assignment Assignment: Extended ER Diagram |
due by 11:59pm |
| Assignment Practice Exercise: Extended ER Diagram Example |
due by 11:59pm |
| Mon Oct 23, 2023 |
Quiz Normalization Quiz for CIS 205 |
due by 11:59pm |
| Discussion Topic Discussion - Multi-Tier Topology |
due by 11:59pm |
| Discussion Topic Discussion - Normalization |
due by 11:59pm |
| Discussion Topic Discussion Assignment: Normalization vs. Denormalization |
due by 11:59pm |
| Assignment Homework Assignment Normalization (Course and Grades) |
due by 11:59pm |
| Assignment Practice Exercise: First Normalization Form Example |
due by 11:59pm |
| Assignment Practice Exercise: Second Normalization Form Example |
due by 11:59pm |
| Mon Oct 30, 2023 |
Discussion Topic Discussion Assignment 2: Relational Algebra |
due by 11:59pm |
| Discussion Topic Discussion Assignment 1: Relational Algebra |
due by 11:59pm |
| Quiz Weekly Quiz CIS 205: Relational Algebra |
due by 11:59pm |
| Assignment Homework Assignment - Multiple Table Query : Student Course Registration |
due by 11:59pm |
| Assignment Practice Exercise - Create Database Tables Assignments: Student Majors Database |
due by 11:59pm |
| Assignment Practice Exercise : Relational Algebra Results |
due by 11:59pm |
| Assignment Practice Exercise: Multi-Table SQL Script - Sailor Reservation Database |
due by 11:59pm |
| Mon Nov 6, 2023 |
Discussion Topic Discussion 1: Numeric Digits as a Character Data Type |
due by 11:59pm |
| Discussion Topic Discussion 2: Cartesian Product) verus the JOIN ON Operation |
due by 11:59pm |
| Assignment Homework Assignment: Create Tables for Homework Assignment: Animal Pet Rescue Database |
due by 11:59pm |
| Assignment Practice Exercise: CREATE TABLE Statements for Pizza Delivery Shop Database |
due by 11:59pm |
| Mon Nov 13, 2023 |
Discussion Topic Discussion Ethics: Information Privacy |
due by 11:59pm |
| Discussion Topic Discussion: Ethics: Information Control |
due by 11:59pm |
| Assignment Homework Assignment: Insert Data Into for the Homework Assignment: Animal Pet Rescue Database |
due by 11:59pm |
| Assignment Practice Exercise: INSERT INTO statements for the Pizza Delivery Shop Database |
due by 11:59pm |
| Mon Nov 20, 2023 |
Assignment Practice Exercise- Sample Database Tutorial using the LIKE Operator |
due by 11:59pm |
| Assignment Homework Assignment: Trip Expenses |
due by 11:59pm |
| Assignment Practice Exercise- Sample Database Tutorial using the BETWEEN and IN Clauses |
due by 11:59pm |
| Assignment Practice Exercise- Sample Database Tutorial using the GROUP BY Clause |
due by 11:59pm |
| Assignment Practice Exercise- Sample Database Tutorial using the GROUP BY with a HAVING Clause |
due by 11:59pm |
| Assignment Practice Exercise- Sample Database Tutorial using the ORDER BY Clause |
due by 11:59pm |
| Assignment Practice Exercise- Sample Database Tutorial Aggregate Functions |
due by 11:59pm |
| Mon Nov 27, 2023 |
Assignment Alter Table Homework Assignment: Animal Pet Rescue Database |
due by 11:59pm |
| Assignment Homework Assignment: DELETE Statements for the Homework Assignment: Animal Pet Rescue Database |
due by 11:59pm |
| Assignment Homework Assignment: DELETE Statements for the Homework Assignment: Animal Pet Rescue Database |
due by 11:59pm |
| Assignment Practice Exercise- Sample Database Tutorial using the ALTER TABLE Statement |
due by 11:59pm |
| Assignment Practice Exercise- Sample Database Tutorial using the DELETE Statement and ON CASCADE DELETE Statement |
due by 11:59pm |
| Assignment Practice Exercise- Sample Database Tutorial using the UPDATE Statement |
due by 11:59pm |
| Mon Dec 4, 2023 |
Discussion Topic Discussion Assignment: Online Analytical Processing (OLAP) |
due by 11:59pm |
| Assignment Homework Assignment: Student Course Registration Unions and Sub Queries |
due by 11:59pm |
| Assignment Practice Assignment : Advanced Sailor Queries Sub Queries / Inner Queries |
due by 11:59pm |
| Mon Dec 11, 2023 |
Discussion Topic Discussion Assignment Ethics: Information Security |
due by 11:59pm |
| Discussion Topic Discussion Assignment: Data Warehousing, Data Mining, NoSQL and Big Data |
due by 11:59pm |
| Assignment Assignment: Data Control Language (DCL) - Write CREATE USER Statements for the Animal Pet Rescue Database |
due by 11:59pm |
| Assignment Assignment: SQL Transaction using the Homework Database: for the Animal Pet Rescue Database |
due by 11:59pm |
| Assignment Extra Credit - Practice Assignment - Sample Database Tutorial Creating Stored Procedures |
due by 11:59pm |
| Assignment Extra Credit - Practice Assignment - Sample Database Tutorial Creating and Roll Back Transaction in SQL |
due by 11:59pm |
| Assignment Extra Credit - Practice Assignment - Sample Database Tutorial Creating Committed Transaction in SQL |
due by 11:59pm |
| Assignment Extra Credit - Practice Assignment - Sample Database Tutorial Introducing Stored Procedures with Parameters |
due by 11:59pm |
| Assignment Extra Credit Homework Assignment: Stored Procedure Statements for the Homework Database: Animal Pet Rescue Database |
due by 11:59pm |
| Assignment Extra Credit Homework Assignment: Stored Trigger Statements for the Homework Database Assignment: for the Animal Pet Rescue Database |
due by 11:59pm |
| Assignment Extra Credit Practice Assignment - Sample Database Tutorial Creating Read Locks on Tables in SQL |
due by 11:59pm |
| Assignment Extra Credit Practice Assignment - Sample Database Tutorial Creating Stored Procedures with Selection Sequences |
due by 11:59pm |
| Assignment Extra Credit Practice Assignment - Sample Database Tutorial Creating Stored Trigger |
due by 11:59pm |
| Assignment Homework Assignment: MySQL VIEWS - Homework Assignment: for the Animal Pet Rescue Database |
due by 11:59pm |
| Assignment Practice Assignment - Sample Database Tutorial using SQL Views |
due by 11:59pm |
| Assignment Practice Exercise- Sample Database Tutorial using the SQL Data Control Language (DCL) CREATE USER Statement |
due by 11:59pm |