CS 474: Database Design and Application
James Madison University, Spring 2019 Semester

Course Syllabus Detailed Schedule PDBM Textbook

About the Course


Chris Mayfield, Ph.D.

This database design course is for advanced undergraduates in computer science. Database systems are essential to nearly every business today. The goal of this course is to give you hands-on experience with fundamental data management techniques. We will focus mainly on the relational model and the use of SQL, a declarative programming language for writing queries. You will gain practical experience designing and programming data-driven applications that may directly impact the real world.

We will also study relational algebra, design theory and normalization, embedding SQL in host languages like Java and PHP, the basics of 3-tier web development, and issues in query optimization and transaction processing. The knowledge and skills you acquire in CS 474 will open the door to solving interesting and challenging problems—not to mention summer internships and networking opportunities.

Unless otherwise noted, the materials on this website are freely available under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.