CS134-lecture-20210601

Course orientation #

Syllabus #

134Sy_Summer2021.pdf

Notes during orientation #

  • 5 assignments, 5 weekly homeworks
  • Effort may be taken into account during assignment grading
  • Assignments build upon the previous assignment
  • Midterm on June 22, and final on last day

Introduction to database management systems #

image_2021-06-02-09-30-55 image_2021-06-02-09-34-14

Files

  • persistent
  • on disk
  • easy to work with

DBMS

  • needs knowledge of software
  • needs to design database structure
  • can handle more complex situations

Imagine we have 2 different files: student_info and grade_record

image_2021-06-02-09-38-24

Notice the duplication among the 2 files. This will waste storage if using a normal file system. There may also be inconsistencies between the 2 files if only 1 is changed. DBMS can control all of these things for you.

image_2021-06-02-09-45-17 image_2021-06-02-10-04-16