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: |
Due Thursday January 20 BEFORE 4pm Click below for more details.
Go to the D2L Discussion board titled Introduction under the D2L Discussions Tab.
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:
|
2: (Ending Jan 27) | Database Environment / Architecture | Chapters 2-3 | Videos:
|
Due Thursday January 27 BEFORE 4pm Click below for more details.
Go to the folder titled Database Environment under the D2L Assignments tab:
Go to the D2L Quiz titled Database Environment and more under the D2L Quizzes tab.
|
3: (Ending Feb 3) | SQL Basics | Beginning of Chapter 6 |
Videos:
|
Due Thursday February 3 BEFORE 4pm Click below for more details.
|
4: (Ending Feb 10) | SQL Continued | End of Chapter 6 | Videos: | Due Thursday February 10 BEFORE 4pm
|
5: (Ending Feb 17) | Relational Model | Beginning of Chapter 4 and 7 | Videos:
|
Due Thursday February 17 BEFORE 4pm |
6: (Ending Feb 24) | Views and More | End of Chapter 4 and 7 | Videos:
Other Videos: |
Due Thursday February 24 BEFORE 4pm |
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:
|
|
8: (Ending Mar 10) | Midterm Exam & Choose Project Topic | Review Sheet for Midterm Exam | Due Thursday March 10 BEFORE 4pm
|
|
(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 |
10: (Ending Mar 31) | Enhanced ER Modeling | Chapter 13 | Videos:
Enhanced_ER_Diagram |
Due Thursday March 31 BEFORE 4pm
|
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 |
12: (Ending Apr 14) | Advanced Normalization and Denormalization | Chapters 15 and 19 | Videos:
BCNF Denormalization |
Due Thursday April 14 BEFORE 4pm |
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 |
|
14: (Ending Apr 28) | Methodology for Database Design / Database Issues | Chapters 16-18 Chapters 20-21 |
Due Thursday April 28 BEFORE 4pm
|
|
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 |