CS 440

Major Prerequisites

Completion of CS 230.

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 and operate on databases using 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.

    • Microsoft Access, using XML 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

There is no assigned textbook. The instructor will cover many examples and concepts from Fundamentals of Database Systems 7th Edition by Elmasri and Navathe (ISBN 978-0-13-397077-7) but it is not required. The older editions are comparable.

Avatar
Mr. Reaser
Teaching Instructor

Teaching Instructor at West Virginia University.