CS 315 Modern Database Management

Professor Adler's Spring 2019 Dynamic Course Outline

This schedule is tentative and may change throughout the semester.
All work must be submitted on time! All work is due Thursdays no later than 4pm.
All lecture notes can be found on D2L.

Download Syllabus

Week Topic Readings Videos/Audios/Screenshots Homework
1: (Ending Jan 10) Introduction Chapter 1 Welcome Audio:


Videos:
  1. Introduction Video (Note: the video is from a previous semester - so the site/syllabus looks a little different than ours)

  2. Introduction to D2L for our course

  3. File-Based Systems

Due Thursday January 10 BEFORE 4pm

Click below for more details.

Go to the D2L Discussion board titled Introduction under the D2L Discussions Tab.
  1. Introduce yourselves to each other. Describe yourself. What is your background? What would you like to do after you graduate?
  2. Reply to at least TWO of your classmates' threads.
Go to the D2L Discussion board titled Interviews. Interview at least one user of database systems (programmer, DBA, etc.).
Answer the following question on the discussion board:
  1. Where does s/he work?
  2. Which DBMS does s/he use?
  3. What is the purpose of their database?
  4. What does this user perceive to be the advantages and disadvantages of DBMS?
  5. Read your classmates' interviews AND reply to at least TWO of your classmates' posts.
2: (Ending Jan 17) Database Environment / Architecture Chapters 2-3 Videos:
  1. Three Level Architecture: External, Conceptual, and Internal

  2. Relational Data Model vs. Network and Hierarchical

  3. History Of DBMS

  4. Multi-User DBMS Architectures: Teleprocessing, File-server architecture, Traditional two-tier client–server architecture

  5. Multi-User DBMS Architectures: Three-tier Client-Server Architecture

Due Thursday January 17 BEFORE 4pm

Click below for more details.

Go to the folder titled Database Environment under the D2L Assignments tab:
  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. This must be in your own words! Plagiarism will be checked and you will receive a 0 if it is detected. Show me that you understand it, not that you are copying the answer.
  4. All assignments during the semester must be done by yourself. You cannot submit the same assignment as another student.
Go to the D2L Quiz titled Database Environment and more under the D2L Quizzes tab.
  • You will have 45 minutes to complete the 10 question quiz.
  • It is open book. However, you must complete the quiz on your own without the help of anyone else.
  • Before beginning the quiz - review chapters 1-3 (Introduction, Database Environment, and Database Architecture), watch the videos, read the lectures notes, and do the assignment above, and then take the quiz.
  • Note: Quizzes will become available 1 week before the due date.
3: (Ending Jan 24) SQL Basics Beginning of Chapter 6 Screenshot: Screenshot

Video:
  1. Using SQL: Create, Insert, and Select
    NOTE: URL is now phpmyadmin in lowercase
    Your username is db_Spr19_yourusername

  2. Using SQL: Update and Delete

  3. Data Types

Due Thursday January 24 BEFORE 4pm

  1. SQL Assignment
4: (Ending Jan 31) SQL Continued End of Chapter 6 Videos:
  1. SQL: Aggregates

  2. SQL: Group By

  3. SQL: Subquery

  4. SQL: Joins

  5. SQL-LeftOuterJoin

Due Thursday January 31 BEFORE 4pm

  1. SQL Assignment

  2. D2L SQL Quiz. Note: Quizzes will be available 1 week before the due date.
5: (Ending Feb 7) Relational Model Beginning of Chapter 4 and 7 Videos:
  1. Choosing Primary Keys

  2. Composite Primary Keys

  3. Foreign Keys

  4. SQL: Primary Keys

  5. SQL: Foreign Keys - Part_1

  6. SQL: Foreign Keys - Part_2

  7. SQL: Alter

Due Thursday February 7 BEFORE 4pm

  1. SQL Relational Assignment
6: (Ending Feb 14) Views and More End of Chapter 4 and 7 Videos:
  1. SQL: Views

  2. Stored Procedures

Other Videos:
  1. Professor Iacobelli's video on Indexes

Due Thursday February 14 BEFORE 4pm

  1. SQL Assignment

  2. Views and Indexes
7: (Ending Feb 21) DBMS Lifecycle/Fact-Finding Techniques Chapters 10-11

Due Thursday February 21 BEFORE 4pm

Click below for more details.

Go to the folder titled Database System Development Lifecycle in the D2L Assignements tab. After reading the lecture notes posted this week in Desire2Learn as well as the textbook, please do the following:
  1. Choose a stage in the database system development lifecycle. In your own words, describe it and discuss why you feel it's important.
  2. Your answer should be about 2 paragraphs. Please be specific.
  3. This must be in your own words! Plagiarism will be checked and you will receive a 0 if it is detected. Show me that you understand it, not that you are copying the answer.
8: (Ending Feb 28) Midterm Exam & Choose Project Topic Review Sheet for Midterm Exam

Due Thursday February 28 BEFORE 4pm

  1. ONLINE MIDTERM DUE Please go directly to D2L to see the details of the online exam. It will be posted one week before the due date.

  2. Project: Choose topic, summary
9: (Ending Mar 7) ER Modeling Chapter 12 Videos:
ER_Diagram
ternary_ER_Diagram
Full_ER_Diagram
Another_ER_Diagram
Ternary_ER_Diagram_Another_Example
Ternary, continued

A nice tool to draw ER Diagrams:
draw.io

Cheatseet:
ER Diagram - UML Cheatsheet

Due Thursday March 7 BEFORE 4pm

  1. ER Diagram Assignment
10: (Ending Mar 14) Enhanced ER Modeling Chapter 13 Videos:
Enhanced_ER_Diagram

Due Thursday March 14 BEFORE 4pm

  1. Project: ER Diagram in UML Notation
  2. D2L: ER and Enhanced ER Quiz. Note: Quizzes will be available 1 week before the due date.
(Ending Mar 21)  Spring Break! - No Submission Due
11: (Ending Mar 28)  Normalization Chapters 14 Videos:
Reason_For_Normalization
functional_dependency
Full_and_Partial_Functional_Dependencies
transitive_dependencies
1nf
1nf_violation
2nf_violation
2nf_violation_Continued
3nf_Violation
3nf_Table
3nf_-_Primary_and_Foreign_Key

Cheatseet:
Normalization Cheatsheet

Normalization Solution:
HW- 2NF Explained
HW- 3NF Explained

Due March 28 BEFORE 4pm

  1. Normalization Assignment
12: (Ending Apr 4)  Advanced Normalization and Denormalization Chapters 15 and 19 Videos:
BCNF
Denormalization

Due Thursday April 4 BEFORE 4pm

  1. Project: Normalization and Denormalization
13: (Ending Apr 11)  Connect from a Java Program Videos:
Bulk_Import
Java: Modify ClassPath
Java: Connect to Database
Java: Insert to Database
Java: Select from Database

Due FRIDAY April 12 BEFORE 4pm

  1. Import from CSV and Interact with the DB from Java!
14: (Ending Apr 18)  Methodology for Database Design / Database Issues Chapters 16-18
Chapters 20-21

Due Thursday April 18 BEFORE 4pm

  1. D2L Quiz on Legal, Ethical, and Security Issues. Note: Quizzes will be available 1 week before the due date.
15: (Ending Apr 25)  Work on Final Project
Finals Week: (Ending May 2)  Final Projects Due