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, 4, and 5. (4) Database Design. Chapters 7 and 8, 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 11, 12, and 13. Indexing and hashing, query processing and query optimization. (6) Transaction Management Chapters 14 and 15, and if time permitting Chapter 16 as well. Transactions and concurrency control. The notion of transactions, ACID properties of transactions, concurrent schedules, serializability, locking protocols...
View Full Document
- Fall '11