Syllabus

Here is the complete syllabus. --Click here.--

Long Distance Students

Zoom link for classes and online office hours:

Join Zoom Meeting
https://us02web.zoom.us/j/6514910904?pwd=RWkzdWo4M01NWFpnVGIzdlJkdnNLZz09

Meeting ID: 651 491 0904
Passcode: 2021

Office Hours

• Thomas Schwarz TR 15:10 - 16:00 and by appointment.
• Online office hours: Friday, 7:30 pm - 8:30 pm via zoom

Examinations

• --> Midterm Preparation (click here) <--
• --> Midterm Preparation Solution (click here) <--

• --> First Midterm (click here) <--
• --> Midterm Solution <--

• --> Final (click here) <--

Contents

Homeworks

Homework 1

• HW1 Click here
• article Click here
• Python script Click here

Homework 2

• HW2 Click here

Homework 3

• HW3 Click here
• Presentation Intro to SQL Workbench(mp4) -- Click here --
• zip file -- zip file --
• hw3 Solution Click here

Homework 4

• HW4 Due Feb. 10, 2023 Click here
• HW4 Solution Click here

Homework 5

• HW5 Due Feb. 17, 2023: Click here
• HW5 Solution Click here

Homework 6

• HW6 Due Feb. 24, 2023: Click here
• HW6 Solution Click here

Homework 7

• HW7 Due March 3, 2023: Click here
• Database AIRLINES.sql (run in MySql workbench as a script
• HW7 Solution Click here

Homework 8

• HW8 Due April 1, 2023: Click here

Makeup Homework

Replaces the worst scoring homework among homework assignments 1-7.

• MUH Due April 7, 2023: Click here

Homework 9

• HW9 Due April 14, 2023: Click here

Homework 10

• HW10 Due April 21, 2023: Click here

Homework 11

• HW11 Due April 28, 2023: Click here

Last Homework and Final Prep

This homework prepares you for the final. If you submit it, it will replace the worst homework score so far. You need to install a new database, given by the following two scripts.

• HR --- Schema Definition ---
• HRdata --- Schema Data ---
• HW11 Due May 8, 2023: Click here ---
• HW11 solutions --- Click here ---

Recordings

• January 17
• January 24
• January 26
• January 31
• February 2
• February 7
• February 9
• February 14
• February 16
• February 21
• February 23
• February 28
• March 2
• March 7
• March 21
• March 23
• March 28
• March 30
• April 12
• April 14
• April 19
• April 21
• April 23
• April 25
• April 27
• May 2
• May 4

Week 1

Preparation: Install MySQL and MySQL Workbench

• Presentation [keynote] Click here
• Presentation [pdf] Click here

Module 1: Introduction

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --

Module 2: Relational Model of Data

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation Intro to SQL Workbench(mp4) -- Click here --

Week 2

Module 3: Simple Description of Relational Databases, MySQL Data Definition Language

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation (pptx) -- Click here --

Module 4: MySQL Select Statements

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation (pptx) -- Click here --
• employees.sql download here

The normal way to install a database from a script is to use MySQLWorkbench, go to File -> Run SQL Script and then select the file. I have had difficulties with this. If you have the same difficulties, the safest workaround is to copy and paste the text of employees.sql into a query window and execute it in the Workbench. You can also open up the database in a terminal, type

mysql -u root -p

and then say at the prompt

source employees.sql

Module 5: Design Theory for Relational Databases

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --

Module 6: High Level Database Models

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation (pptx) -- Click here --

Module 7: Algebraic Query Languages

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation (pptx) -- Click here --

Module 8: SQL

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation (pptx) -- Click here --

Module 9: Constraints, Triggers, Views, Indices

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation on Triggers -- Click here --
• View Presentation (keynote) -- Click here --
• View Presentation (pdf) -- Click here --

Module 10: Stored Procedures and Functions

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --

Module 11: Connecting with Databases Programmatically

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Example program -- Click here --

Module 12: Database Implementation Topics

• Presentation -- Click here --
• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation (pptx) -- Click here --
• MySQL Review (keynote) -- Click here --
• MySQL Review (pdf) -- Click here --

Module 13: Distributed Relational Databases

• Presentation -- Click here --
• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --

Tuesday, April 25

Overview of NoSQL Databases

• Presentation -- Click here --
• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation (pptx) -- Click here --

Wednesday, April 29

MongoDB 1

• Presentation -- Click here --
• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation (pptx) -- Click here --

Friday, May 1

MongoDB 2

Finals Materials

Run these scripts in order in MySQLWorkbench. You can also copy them into an SQL query.

• final.sql script --- click here to download ---
• finaldata.sql script --- click here to download ---
• final.pdf Text of final, made available May 9, 2023 shortly before 8pm --- click here to download

Finis