CS 415 Design of Database Systems

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(Course number may be different, but the structure is the same for you)

  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 TWO users of database systems (programmer, DBA, etc.).

Answer the following question on the discussion board FOR EACH INTERVIEW separately:
  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


DBMS Lifecycle/Fact-Finding Techniques		 End of Chapter 4 and 7;

Chapters 10-11		 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, DBMS Lifecycle, and More
7: (Ending Feb 21) Midterm Exam & Choose Project Topic Review Sheet for Midterm Exam

Due Thursday February 21 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
8: (Ending Feb 28) 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 Feb 28 BEFORE 4pm

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

Due Thursday March 7 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.
10: (Ending Mar 14)  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

Due March 14 BEFORE 4pm

  1. Normalization Assignment
(Ending Mar 21)  Spring Break! - No Submission Due
11: (Ending Mar 28)  Advanced Normalization and Denormalization Chapters 15 and 19 Videos:
BCNF
Denormalization

Due Thursday March 28 BEFORE 4pm

  1. Project: Normalization and Denormalization
12: (Ending Apr 4)  Methodology for Database Design / Database Issues Chapters 16-18
Chapters 20-21

Due Thursday April 4 BEFORE 4pm

  1. Database Design HW
  2. D2L Quiz on Legal, Ethical, and Security Issues. Note: Quizzes will be available 1 week before the due date.
13: (Ending Apr 11)  Distributed Database Systems

Connect from Web Application		 Chapter 24-25.4 Videos: Optional Videos for those interested in using localhost first:

Due FRIDAY April 12 BEFORE 4pm

  1. Import from CSV and Interact with the DB from a Web Application!
  2. D2L Quiz on Distributed Systems. Note: Quizzes will be available 1 week before the due date.
14: (Ending Apr 18)  NoSQL DB Videos: Useful Websites: Cheatsheet:

Due Thursday April 18 BEFORE 4pm

  1. NoSQL Database HW
  2. D2L Quiz on NoSQL. 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

Due Thursday May 2 BEFORE 4p.m.

  1. Final Projects