CS 315 Modern Database Management

Professor Adler's Fall 2020 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 Aug 27) Introduction Chapter 1 Welcome Audio:

Videos:
  1. Introduction Video
  2. Introduction to D2L for our course
  3. File-Based Systems

Due Thursday August 27 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 this person work?
  2. Which DBMS does the interviewee use?
  3. What is the purpose of their database?
  4. What does this user perceive to be the advantages and disadvantages of their DBMS?
  5. Any additional question you would like to ask? Provide your question and the response.
  6. Read your classmates' interviews AND reply to at least TWO of your classmates' posts.
2: (Ending Sep 3) 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 September 3 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 48 hours (2 days) before the due date.
3: (Ending Sep 10) SQL Basics Beginning of Chapter 6 Videos:
  1. Running MAMP/phpMyAdmin [Mac] [WINDOWS]
  2. SQL: Create, Insert, and Select
  3. SQL: Update and Delete
  4. Data Types

Due Thursday September 10 BEFORE 4pm

Click below for more details.

  1. Install MAMP
  2. SQL Assignment
  3. All assignments must always be your own and done independently or you will receive a 0. If you provide your answers to another student you will also receive a 0.
4: (Ending Sep 17) 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 September 17 BEFORE 4pm

  1. SQL Assignment
  2. D2L SQL Quiz. Note: Quizzes will be available 48 hours (2 days) before the due date.
5: (Ending Sep 24) 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 September 24 BEFORE 4pm

  1. SQL Relational Assignment
6: (Ending Oct 1) 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 October 1 BEFORE 4pm

  1. SQL Assignment
  2. Views and Indexes
7: (Ending Oct 8) DBMS Lifecycle/Fact-Finding Techniques Chapters 10-11

Due Thursday October 8 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 Oct 15) Midterm Exam & Choose Project Topic Review Sheet for Midterm Exam

Due Thursday October 15 BEFORE 4pm

  1. ONLINE MIDTERM DUE Please go directly to D2L to see the details of the online exam. It will be posted 24 hours before the due date.
  2. Project: Choose topic, summary
9: (Ending Oct 22) 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 October 22 BEFORE 4pm

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

Due Thursday October 29 BEFORE 4pm

  1. Project: ER Diagram in UML Notation
  2. D2L: ER and Enhanced ER Quiz. Note: Quizzes will be available 48 hours (2 days) before the due date.
11: (Ending Nov 5)  Normalization Chapter 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 Thursday November 5 BEFORE 4pm

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

Due Thursday November 12 BEFORE 4pm

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

Due Thursday November 19 BEFORE 4pm

  1. Import from CSV and Interact with the DB from Java!
14: (Ending Nov 26)  Thanksgiving! - No Submission Due-Work on Final Project
15: (Ending Dec 3)  Methodology for Database Design / Database Issues Chapters 16-18
Chapters 20-21

Due Thursday December 3 BEFORE 4pm

  1. D2L Quiz on Legal, Ethical, and Security Issues. Note: Quizzes will be available 48 hours (2 days) before the due date.
  2. Please complete the Online Instructor Course Evaluations
Finals Week: (Ending Dec 10)  Final Projects Due Videos:
Professor Kimmel's Sample Final Project

Screenshots:
Students' Sample Final Java Screenshots (8 pages)

Due Thursday December 10 BEFORE 4p.m

  1. Final Projects