CS581 Advanced Database Design

The course covers advanced topics in database design. It revisits 3rd normal form and Boyce-Codd NF, and tackles 4th and 5th normal forms; data models and the SQL query languages along with its variants such as Oracle SQL and procedural version PL/SQL will also be presented. Other topics covered include the physical level, indexing, transaction management, concurrency control, recovery procedures (roll-backs).