CS 315 Modern Database Management

Professor Thursday's Spring 2022 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 20) Introduction Chapter 1 Welcome Audio:

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

Due Thursday January 20 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 Jan 27) 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 27 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 Feb 3) SQL Basics Beginning of Chapter 6 Videos:
  1. Introduction to SQL
  2. Running MAMP/phpMyAdmin [MAC] [WINDOWS]
  3. SQL: Create, Insert, and Select
  4. SQL: Update and Delete
  5. Data Types

Due Thursday February 3 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 Feb 10) 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 February 10 BEFORE 4pm

  1. SQL Assignment
  2. D2L SQL Quiz. Note: Quizzes will be available 48 hours (2 days) before the due date.
5: (Ending Feb 17) 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
  8. SQL: auto_increment

Due Thursday February 17 BEFORE 4pm

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

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

Due Thursday March 3 BEFORE 4pm

Click below for more details.

Go to the folder titled Database System Development Lifecycle in the D2L Assignments 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 Mar 10) Midterm Exam & Choose Project Topic Review Sheet for Midterm Exam

Due Thursday March 10 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
(Ending Mar 17)  Spring Break - No Homework
9: (Ending Mar 24) 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 24 BEFORE 4pm

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

Due Thursday March 31 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 Apr 7)  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 April 7 BEFORE 4pm

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

Due Thursday April 14 BEFORE 4pm

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

Due Thursday April 21 BEFORE 4pm

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

Due Thursday April 28 BEFORE 4pm

  1. Database Design HW
  2. D2L Quiz on Legal, Ethical, and Security Issues. Note: Quizzes will be available 48 hours (2 days) before the due date.
  3. Please complete the Online Instructor Course Evaluations
15: (Ending May 5)  Work on Final Project
Final Project: (Due Tuesday May 10)  Final Projects Due Videos:
Professor Kimmel's Sample Final Project

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

Due Tuesday May 10 BEFORE 4p.m

  1. Final Projects