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

Course Syllabus Detailed Schedule Apps4VA JMU

About the Course

This "first course in database systems" is for advanced undergraduates in computer science. Databases are essential to nearly every business today, and the goal of this course is to give you hands-on experience with fundamental data management techniques. We will focus 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. Topics outside the scope of this course include database server administration, semistructured data management, NoSQL and big data, and object-oriented databases.

From the Instructor

Welcome to CS 474

This spring you will have the opportunity to participate in Apps4VA, an ongoing initiative sponsored by CIT and VDOE. The goal is to improve K-12 education in Virginia by leveraging data on public school students and their progress toward college and career readiness. Students like you, professional software developers, and the general public are creating "apps" that explore new ways of using K-12 education data to aid in better decision making and intervention strategies. I hope this course will be a rewarding experience that you will remember for years to come!

Dr. Mayfield's home page (contact info and office hours)

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