Examination of the logical organization of databases: the entity-relationship model; the hierarchical, network, and relational data models and their languages. Functional dependencies and normal forms. Design, implementation, and optimization of query languages; security and integrity; concurrency control.

Main Textbook

• A First Course in Database Systems, 3rd Edition, by Jeffrey D. Ullman, Jennifer Widom\

  
  

Recommended Textbooks

• Database Systems: The Complete Book, 2nd Edition, by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom

• Database Systems Concepts, 6th Edition, by Silberschatz, Korth, Sudarshan

• Database Management Systems, 3rd Edition, by Raghu Ramakrishnan, Johannes Gehrke

  
  

Web Resources

• SQL for Web Nerds, by Philip Greenspun