SENG 565

Major Prerequisites

Enrollment in LCSEE’s online MSSE program.

Completion of SENG 550.

Learning Outcomes

This course is currently listed as a special topics course with the code SENG 591b. The tentative permanent course code is SENG 565.

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

  • Design relational databases using entity-relationship (ER) diagrams.

  • Design relational databases using relational model (RM) schemas.

  • Translate ER diagrams to RM schemas.

  • Create relational database schemas by writing data definition language (DDL) queries in Structured Query Language (SQL).

  • Solve nontrivial problems using databases by writing data manipulation language (DML) queries in Structured Query Language (SQL).

  • Create applications using these industry-standard software stacks:

    • Oracle Database (relational model) with Java code and JDBC driver.

    • MySQL (relational model) with PHP code and MySQLi driver.

    • MongoDB (“NoSQL” model) with Node.js code and official driver.

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.