MIS 3400: Principles of Database System Management

- Blackboard problem? Please contact CSUB help desk at 654-2307 or Helpdesk@csub.edu

Name: Yong Choi, PhD
Office: BDC 103
Office Phone: 654 - 6691
Email Address: ychoi2@csub.edu
Venue: BDC 163

Office Hours:
 - Tuesday (3:30pm - 5:30pm)
 - Thursday (3:30am - 5:30pm)
 - Or by an appointment

Course information:
 - Syllabus
 - Announcement
 - Group Information
 - Peer Evaluation

Other Information:
 - Blackboard Submission Guideline
 - Group Big Data Assignment Instruction

 - How to Enroll into Blackboard
 - Downlaod MS Office for PC & Apple

Important Link:
 -
The Department of Justice SDLC Document
 
- Data Modling Tool: Lucidchart.com & Lucidchart.com tutorial
 - Textbook Video Lecture (all chapters)
 - Final Exam Project  
new!

Course Schedule

 Wk

Class Materials

Assignment

Tuesday Thursday

 1

Aug 29: Introduction to Class

Aug 31: Background of IS

2 Sep 5:
DB Development:
DB 1 Lecture & DB 2 Lecture

Online: Ch 1-The Database Environment and Development Process (Textbook Video Lecture)
Sep 7 (online):
Microsoft Access 2013 Tutorial Must do!
Microsoft Access 2016 Tutorial
Must do!

DB files: Restaurant 1 (Order), Restaurant 2, and Restaurant3 
Import Excel file PPT: i
mport Excel file 
Additional files: CSUB Logo, NewRest HTML, and Loan XML
DB examples: Composite PK, PK as FK, FineFood DB, Referential Integrity, and BillingAddress
Practice files: Excel (Course, Instructor
, and Membership) and DB (
Roadrunner database)
 
3 Sep 12: DB Development:  
DB 3 Lecture
 
Sep 14: DB Development:  
DB 4 Lecture
 
4 Sep 19: DB Modeling (ERD)
DB Modeling Part 1 Lecture
 - ERD Video and ERD using CASE Tool
 - First Group Meeting
Sep 21: Access Database Test
5 Sep 26: Data Modeling
Data Modeling Part I Lecture con't
 - Business rules with model & Requirements Discovery
Sep 28: Data Modeling (ERD)
Data Modeling Part II Lecture Note

Online: Ch 2-Modeling Data in Organization (Textbook Video Lecture)
Group Big Data Assignment 1
 - Due: Oct 4 (Wed, 11:59pm)
 - Chapter 1 of the Big Data textbook
6 Oct 3: Data Modeling (ERD)
 - Data Modeling Part II Lecture Note con't
 - Data Modeling Practice
Oct 5: Data Modeling Practice
Amamzon Aurora RDS
 
- Amazon Web Services & Online tutorials with AWS
 
7 Oct 10:Data Modeling Practice
Super/Sub Type Entity
Group Assignment (based on progress!)
Online: Ch 3-The Enhanced E-R Model (Textbook Video Lecture)
Oct 12: Online
ERD Tutorial One, ERD Tutorial Two, and Crow's Feet Are Best
Database Modling Tool: Lucidchart.com & Lucidchart.com tutorial
ERD Practice
Group Big Data Assignment 2
 - Due: Oct 11 (Wed, 11:59pm)
 - Chapter 3 of the Big Data textbook
8 Oct 17: Data Modeling Test Oct 19: Data Model Test Review & Transformation
ERD to Relational DB
9 Oct 24: Transformation
ERD to Relational Model Practice
Online: Ch 4-Logical Database Design and the Relational Model
Oct 26:
Data Modeling Test Review
ERD to Relational Model Practice (con't)
Reverse Engineering: 1, 2, and 3
Group Big Data Assignment 3
 - Due: Oct 25 (Wed, 11:59pm)
- Chapter 4 of the Big Data textbook
10 Oct 31: Business Rule & ERD to Relational Model Test
Online: Ch 5-Physical Database Design and Performance (Textbook Video Lecture)
Nov 2:
ERD to Relation Model Test Review
Normalization Lecture Note
Normalization Practice one &
Practice Two
 

11

Nov 7: Normalization
Normalization Practice one & Practice Two (con't)
Textbook Normalization Exercise Questions
Nov 9: Online
SQL Online: W3schools.com

Online: Ch 6-Introduction to SQL (Textbook Video Lecture)

Group Big Data Assignment 4
 - Due: Nov 8 (Wed, 11:59pm)
 - Chapter 5 of the Big Data textbook

12

Nov 14:
Reverse Engineering & Normalization Test
Online: Ch 7-Advanced SQL (Textbook Video Lecture)
Nov 16: Structured Query Language (SQL)
Restaurant 3 SQL
SQL Lecture Part 1 and SQL DB file for the lecture
 
13 Nov 21 (online):
SQL Online: W3schools.com, SQLCourse.com, and SQLCourse2.com
 

14

Nov 28/30: Structured Query Language
SQL Lecture Part 2 and  Example of matching field SQL
Online: Ch 8-Database Application Development

Group Big Data Assignment 5
 -
Due: Nov 29 (Wed, 11:59pm)
 - Chapter 6 of the Big Data textbook

15

Dec 5: SQL Test (open book and note)

Dec 7: Online: Ch 9-Data Warehousing