COMP 115 – SCHEDULE

LECTURES

ASSIGNMENTS

EVALUATION

Lecture

Subject

Date

A1

A2

A3

A4

A5

A6

A7

A8

A9

Quizzes

10%

01

Introduction

Sep 4

Assignments

50%

02

Data Modeling

Sep 9

A1

4%

Rows & tables

03

The Relational Model of Data

Sep 11

A2

4%

Relational Algebra

04

Relational Algebra

Sep 16

A3

4%

Schema design

05

Schema Design

Sep 18

A4

7%

RA queries

06

Schema Design

Sep 23

A5

8%

SQL queries

07

SQL Basics

Sep 25

A6

7%

RA with iterators

08

SQL Select 1

Sep 30

A7

4%

Query optimization

09

SQL Select 2

Oct 2

A8

8%

Client programming

10

Storage and Indexing

Oct 7

A9

4%

Transactions

11

B-trees

Oct 9

Exams

40%

12

Indexes

Oct 15

E1

20%

Lectures 01-12

13

Review for Exam 1

Oct 16

E2

20%

Lectures 14-24

Exam

Exam 1

Oct 21

14

Query processing

Oct 23

15

Query processing

Oct 28

16

Query optimization

Oct 30

17

Query optimization

Nov 4

18

Writing DB Applications

Nov 6

No class

Nov 11

19

Stored Procedures

Nov 13

20

Transactions

Nov 18

21

Concurrency Control

Nov 20

22

Concurrency Control

Nov 25

No class

Nov 27

23

Crash Recovery

Dec 2

24

NoSQL Systems

Dec 4

25

Review for Exam 2

Dec 9

Exam 2

Dec 12

7-9PM

Relational model & SQL

Monday

Implementation

Tuesday

Wednesday