This preview shows page 1. Sign up to view the full content.
Unformatted text preview: manipulation, relational data integrity, are discussed. We will cover relational algebra in this part. (3) The SQL language. Chapters 3 and 4. (4) Database Design. Chapters 6 and 7, and my lecture notes on logical design of relational databases. We will discuss E-R modeling method for database design. The functional dependency based normalization approach to relational databases design is discussed in detail. This includes the notion of normal forms, the algorithms to perform decomposition to 3NF, to BCNF, etc. (5) Storage and Query Processing Chapters 12, 13, 14. Indexing and hashing, query processing and query optimization. (6) Transaction Management Chapter 15, 16, and if time permitting Chapter 17 as well. Transactions and concurrency control. The notion of transactions, ACID properties of transactions, concurrent schedules, serializability, locking protocols...
View Full Document
This note was uploaded on 01/25/2010 for the course CSC 4402 taught by Professor Staff during the Fall '08 term at LSU.
- Fall '08