CS325: Database Management Systems

• Syllabus
• Homework
• Help

Course Summary:

The goal of this course is to explore the fundamentals of Database Management Systems including: benefits of a database management system, data modeling, entitity-relationship modeling, relational modeling, relational algebra, relational calculus, SQL (DDL and DML), database manipulation in a high level language (Java), OO to relational mapping, disk i/o, hashing, r-trees, and query performance. Students complete a large project that demonstrates proficiency in modern database technology.

Syllabus

Read the Department's Statement on Academic Integrity > here <

Online References

• How to use Oracle's DBA Studio use this to verify that the CS325 database is running on your machine.
• How to connect to Oracle using SQL*Plus - a simple command line interface for running SQL statements against your database.
• More SQL*Plus - more advanced SQL*Plus exercises
• Student Database - a sample database with 50K students and 500K grades
• How to backup your Oracle database - a quick guide to the export/import utility.
• Learning more about Oracle - a guide to Oracle's extensive online documentation.

Introduction (Kifer 1)

• Class Notes

Entity-Relationship Model (Kifer 4.1-4.4)

• Class Notes

Relational Model (Kifer 4.5)

• Class Notes

Relational Algebra (Kifer 5.1)

• Class Notes

SQL (Kifer 5.2-5.3, 8)

• Class Notes (SQL, SQL*PLUS)
• ORACLE SQL*PLUS Datafile
• SQL file to build ACCOUNT table
• Console Application to select/insert/update/delete
• Dao pattern that improves on Console Application
• Object Relational Mapping (ORMLite) improves on Dao pattern using annotations
• Object Relational Mapping (Hibernate) improves on Dao pattern Read more [here]

Normalization (Kifer 6)

• Class Notes

Disk and RAID (Tannenbaum 6, Kifer 9.1)

• Class Notes

Indices, Hashing, B-Trees (Kifer 9.4-9.8)

• Class Notes

Query Processing (Kifer 10)

• Large employee/salary tables from source: [Oracle DMP][300K employees.sql][3M salaries.sql]
• How to import/export oracle dump files

Transaction Processing (Kifer 13)

Department of Computer Science @ Stonehill College