CS 281 -- Database Systems

General Information:

• Syllabus

  
  

  
  

  Lecture Notes:

• Chapter 1 ......................(02/02/2025)
• Chapter 4 ......................(02/05/2025)
• DreamHome Rental Database ......(03/18/2025)
• Chapter 2 ......................(02/18/2025)
• Chapter 3 ......................(02/26/2025)
• Chapter 5 ......................(03/06/2025)
• Review for Midterm (Chps 1~5) ..(03/17/2025)
• Chapter 6 ......................(03/26/2025)
• Chapter 7 ......................(04/30/2025)




Labs:




Homework Assignments:

HW1:

• Homework #1 (Chp.4) ................... Due 02/26/2025

HW2:

• Homework #2 (Chps.1~3) .. ............. Due 03/12/2025

HW3:

• Homework #3 (Chp.5) .. ................ Due 03/21/2025

HW4:

• Homework #4 (Chp.6) .. ................ Due 04/30/2025

HW5:

• Homework #5 (Chp.7) .. ................ Due 05/21/2025




Exam Schedule:

• Midterm Exam (Chapters 1~5) .......... 03/24/2025 (Mon. 10:00am-11:40am, Rm:A1/C09)
• Review for Midterm (Chps 1~5)
• Final Exam (Chapters 1~7) ............ 05/21/2025 (Wed. 10:30am-12:30pm, Rm:A1/C09)
• Review for Final (Chps 6~7)




Grade Reports:

       Grade Report -- Summary





Other Links:

• Demo for Using MySQL Server on the Computers in C09
• Sakila Sample Database for Download
• Online SQL Editor (Programiz)
• SQL Online Editor/Compiler (W3Schools)
• Online SQL Editor (myCompiler)