Fri May 26, 2017
|
Assignment
Assignment: Single Table Queries: House Table
|
due by 11:30am
|
Mon Jun 19, 2017
|
Discussion Topic
Discussion Ethics: Information Privacy
|
due by 11:59pm
|
Discussion Topic
Discussion: Ethics: Information Control
|
due by 11:59pm
|
Tue Jun 20, 2017
|
Assignment
In Class Practice Assignment : Update and Delete World Database
|
due by 11:59pm
|
Tue Jun 27, 2017
|
Assignment
Extra Credit Vehicle
|
due by 11:59pm
|
Fri Sep 8, 2017
|
Assignment
In Class Practice Single Table Query - Student
|
due by 11:59pm
|
Mon Sep 11, 2017
|
Discussion Topic
Discussion 1 Chapter 1
|
due by 11:59pm
|
Discussion Topic
Discussion 2 Chapter 1
|
due by 11:59pm
|
Discussion Topic
Introduce Yourself to the Class
|
due by 11:59pm
|
Wed Sep 13, 2017
|
Assignment
Assignment: Single Table Query Assignment - Agent
|
due by 11:59pm
|
Mon Sep 18, 2017
|
Discussion Topic
Discussion 1 Chapter 2
|
due by 11:59pm
|
Discussion Topic
Discussion 2 Chapter 2
|
due by 11:59pm
|
Discussion Topic
Discussion Ethics: Information Ownership
|
due by 11:59pm
|
Thu Sep 21, 2017
|
Assignment
In Class Practice: Chen Diagramming
|
due by 11:59pm
|
Fri Sep 22, 2017
|
Quiz
Quiz Chapter 1
|
due by 11:59pm
|
Assignment
Single Table Query Assignment House Table
|
due by 11:59pm
|
Mon Sep 25, 2017
|
Quiz
Data Models Quiz CIS 205
|
due by 11:59pm
|
Discussion Topic
Discussion 1 Chapter 3
|
due by 11:59pm
|
Discussion Topic
Discussion 2 Chapter 3
|
due by 11:59pm
|
Thu Sep 28, 2017
|
Assignment
In Class Practice Exercise: ER Diagram Little League Football
|
due by 11:59pm
|
Tue Oct 3, 2017
|
Assignment
Group In Class Assignment: Little League Football Commission: Schema and Meta Data
|
due by 11:59pm
|
Thu Oct 5, 2017
|
Assignment
Assignment: Moview Video Rentals
|
due by 11:59pm
|
Assignment
Database Assignment: Visio Tutorial
|
due by 11:59pm
|
Discussion Topic
Discussion 1 Chapter 4
|
due by 11:59pm
|
Discussion Topic
Discussion 2 Chapter 4
|
due by 11:59pm
|
Quiz
ERD / Metadata Quiz CIS 205
|
due by 11:59pm
|
Quiz
Relational Data modleing Quiz CIS 205
|
due by 11:59pm
|
Assignment
Single Table Query Warehouse Inventory
|
due by 11:59pm
|
Tue Oct 10, 2017
|
Quiz
Advance Data Modeling Quiz CIS 205
|
due by 11:59pm
|
Discussion Topic
Discussion 1 Week 5
|
due by 11:59pm
|
Discussion Topic
Discussion 2 Chapter 5
|
due by 11:59pm
|
Assignment
Practice Assignmen: Normalization Practice Exercise
|
due by 11:59pm
|
Assignment
Schema and Metadata Movie Rental
|
due by 11:59pm
|
Fri Oct 13, 2017
|
Assignment
Assignment Normalization
|
due by 11:59pm
|
Discussion Topic
Discussion Multi-Tier Topology
|
due by 11:59pm
|
Tue Oct 17, 2017
|
Discussion Topic
Discussion 2 Normalization
|
due by 11:59pm
|
Fri Oct 20, 2017
|
Discussion Topic
Discussion 1: Relational Algebra
|
due by 11:59pm
|
Discussion Topic
Discussion 2: Relational Algebra
|
due by 11:59pm
|
Tue Oct 24, 2017
|
Assignment
Assignment SQL Database: Tiny College Single Table Queries
|
due by 11:59pm
|
Assignment
Assignment: ER Modeling and Metadata Employee Department Branch
|
due by 11:59pm
|
Assignment
Relational Algebra
|
due by 11:59pm
|
Thu Oct 26, 2017
|
Quiz
Normilization Quiz CIS 205:
|
due by 11:59pm
|
Fri Oct 27, 2017
|
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
|
Quiz
Weekly Quiz Chapter 6 CIS 205: Relational Algebra
|
due by 11:59pm
|
Thu Nov 2, 2017
|
Assignment
In Class Practice: Create Table Assignment: Football Commision
|
due by 11:59pm
|
Fri Nov 3, 2017
|
Assignment
SQL DDL Create Tables Assignment: Movie Rental Database
|
due by 11:59pm
|
Fri Nov 10, 2017
|
Assignment
In Class Practice Assignment 1: Multi-Table SQL Script - Sailor Reservation Database
|
due by 11:59pm
|
Assignment
Practice Exercise: Additional Practice Problem - Trip Expenses
|
due by 11:59pm
|
Wed Nov 15, 2017
|
Assignment
In Class Pracice: Insert Data Into Little League Football Database
|
due by 11:59pm
|
Thu Nov 16, 2017
|
Assignment
Homework Assignment: INSERT INTO Online Movie Database
|
due by 11:59pm
|
Fri Nov 17, 2017
|
Assignment
In Class Practice: Agregating and Grouping Data using the Branch Department Worker Database
|
due by 11:59pm
|
Sat Nov 18, 2017
|
Assignment
Assignment Join Table Queries: World Excecise
|
due by 11:59pm
|
Wed Nov 22, 2017
|
Assignment
In Class Practice: Alter Table Statements
|
due by 11:59pm
|
Thu Nov 30, 2017
|
Assignment
Assignment Customer Order: Select Aggregation
|
due by 11:59pm
|
Assignment
Practice Assignment : Advanced Sailor Queries
|
due by 11:59pm
|
Assignment
Project Topic - Description and Group Member Submissions
|
due by 11:59pm
|
Assignment
Update and Delete Assignment: Movie Rentals
|
due by 11:59pm
|
Fri Dec 1, 2017
|
Assignment
In Class Practice: Procedures and Triggers
|
due by 11:59pm
|
Mon Dec 4, 2017
|
Discussion Topic
Discussion: Ethics: Information Security:
|
due by 11:59pm
|
Quiz
DML Quiz
|
due by 11:59pm
|
Thu Dec 7, 2017
|
Assignment
Alter Table Homework Assignment
|
due by 11:59pm
|
Fri Dec 8, 2017
|
Assignment
Assignment: - Customer Order - Warehouse Shipping
|
due by 11:59pm
|
Tue Dec 12, 2017
|
Assignment
Extra Credit: Data Warehouse Essay
|
due by 11:59pm
|
Assignment
No SQL Essay
|
due by 11:59pm
|
Thu Dec 14, 2017
|
Assignment
Extra Credit Assignment: Student Course Registration
|
due by 11:59pm
|
Assignment
Extra Credit: Art Gallery Database
|
due by 11:59pm
|
Assignment
Extra Credit: Single Table Query Customer
|
due by 11:59pm
|
Assignment
ExtraCredit: Big Data Research Essay
|
due by 11:59pm
|
Assignment
Final Project
|
due by 11:59pm
|
|
Assignment
Final Project Submission Link
|
|
Assignment
In Class Practice: Join Emails
|
|