CS 338: Computer Applications in Business: Databases

Fall 2013

Textbook

Fundamentals of Database Systems, the Sixth or Fifth Edition by R. Elmasri and S. Navathe, Pearson, 2011.

• Text is recommended, not required.
• Many used copies are available.
• Some copies are on reserve in the DC library (call number 1516)

Course Notes

0. Course introduction
1. Introduction to the database management
2. Relational Data Model
3. Constraints and Updates
4. Introduction to SQL
5. Relational algebra
6. Advanced SQL: Aggregate, Group, and Nested Queries
7. Advanced SQL: Updates
8. Advanced SQL: Null Values
9. Views and view management
10. Conceptual modeling: Entity-Relationship (ER) modelling
11. Conceptual modeling: Extended Entity-Relationship (EER) modelling
12. Logical modeling: ER-to-relational mapping
13. Dependencies
14. DBMS Architecture
15. Transactions & transaction support in SQL
16. Concurrency & Recovery
17. Query Processing
18. Database security and privacy

The course notes are complementary to the textbook; they are not meant to replace the textbook. You are expected to know both the material in the textbook for the assigned sections, and the material in the course notes.