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