Completion of CS 230.
This course is cross-listed for credit in the honors program.
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.
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.