CMPS341
-
Introduction to Database Systems
-
Spring 1998
General Course Information
Instructor:
Erdogan Dogdu
Spring 1998 Syllabus
Teaching Assistant:
Wei Liu
, Olin 504, liu@ces.cwru.edu
Phone: x5895, Office Hours: M-T-Th: 11:00-12:00 noon
If you are sitting in the class, add your name and e-mail address to the mailing list of this class for future announcements by sending an e-mail to TA at
liu@ces.cwru.edu
Lecture Slides
(
ppt:Powerpoint, ps:postcript
)
Introduction
ps
Relational Model
ps
Database Design: Entity-Relationship (ER) Model
ps
(
Solutions for exercises in Ch.14
)
Relational Algebra
ps
(
Solutions for exercises in Ch.8
)
Relational Calculus
ps
SQL
ps
(
Solutions for exercises in Ch.9
)
Security, Views, and SQL
ps
(
Solutions for exercises in Ch.10
)
Query-by-Example (QBE)
ps
(
Solutions for exercises in Ch.11
)
Storing Data: Disks and Files
ps
(
Solutions for exercises in Ch.3
)
File Organizations and Indexes
ps
(
Solutions for exercises in Ch.4
)
Tree-Structured Indexes
ps
(
Solutions for exercises in Ch.5
)
Hash-Based Indexes
ps
(
Solutions for exercises in Ch.6
)
Query Evaluation, Implementation
ps
and
ps
(
Solutions for exercises in Ch.12
)
Query Optimization
ps
(
Solutions for exercises in Ch.13
)
Schema Refinement and Normalization
ps
(
Solutions for exercises in Ch.15
)
Concurrency Control
ps
(
Solutions
for exercises in Ch.17
)
Miscellaneous
E-R Summary
[
ps
]
RA to TRC Translation Rules
[
ps
]
RA to DRC Translation Rules
[
ps
]
Oracle SQL*Plus Intro
[
ps
] and [
Screens
] [
ps
]
RA Examples
[
ps
]
Assignments, Quiz, Final
Assignment 1
-- due February 10 [
E-R solution (ppt)
] [
SQL solution
]
[doc]
[
ps
]
Assignment 2
-- due February 23 [
Solutions
][
ps
]
Quiz 1 Q&A
-- Feb 19 [
ps
]
Midterm Q&A
[
ps
]
Assignment 3
-- due Mar 31 -- Solutions [
doc
][
ps
]
Quiz 2 Q&A
-- Apr 16 [
ps
]
Assignment 4 with solutions (doc)
-- due Apr 21 [
ps
]
Final Q&A
-- May 1
Project
Project
-- due May 1 --
[doc]
[
ps
]
Progress Report
-- due Apr 10
Final Report
-- due May 5
Check Your Course Progress
Check your grades
-
Grade scale
What Do You Think?
Feedback
Erdogan Dogdu,
dogdu@ces.cwru.edu
Last Updated: Apr 29, 1998