CS 440

Major Prerequisites

Completion of CS 230.

Honors

This course offers a section for students in the honors program.

Learning Outcomes

Upon successful completion of this course, students will be able to…

  • Explain the design and theory of relational databases.

  • Utilize the entity-relationship model to diagram and iterate database schemas.

  • Employ the relational model with normalization up to 3NF, relational algebra, and relational calculus.

  • Write data definition and data manipulation queries using Structured Query Language.

  • Create and examine databases using industry-standard technologies, including:

    • Oracle Database with Java for desktop applications.

    • MySQL with PHP for web servers.

    • MongoDB with NodeJS for web applications, using the so-called NoSQL model and JSON data.

  • Write stored programs including functions, procedures, and triggers using Oracle PL/SQL.

  • Recognize database file organization, access methods, indexing, and physical design.

Full syllabus is available upon request.

Textbook

The recommended text is Fundamentals of Database Systems 7th Edition by Elmasri and Navathe (ISBN 9780133970777) for out-of-class reading and study. The older editions are acceptable.

Avatar
Mr. Reaser
Teaching Instructor

Lane Department at West Virginia University.