Scott Johnson Headshot

Scott Johnson

Senior Lecturer

Department of Computer Science
Golisano College of Computing and Information Sciences

585-475-4931
Office Location

Scott Johnson

Senior Lecturer

Department of Computer Science
Golisano College of Computing and Information Sciences

Education

BS, MS, Rochester Institute of Technology

585-475-4931

Currently Teaching

CSCI-320
3 Credits
This course provides a broad introduction to the principles and practice of modern data management, with an emphasis on the relational database model. Topics in relational database systems include data modeling; the relational model; relational algebra; Structured Query Language (SQL); and data quality, transactions, integrity and security. Students will also learn approaches to building relational database application programs. Additional topics include object-oriented and object-relational databases; semi-structured databases (such as XML); and information retrieval. A database project is required.
CSCI-344
3 Credits
This course is a study of the syntax and semantics of a diverse set of high-level programming languages. The languages chosen are compared and contrasted in order to demonstrate general principles of programming language design and implementation. The course emphasizes the concepts underpinning modern languages rather than the mastery of particular language details. Programming projects will be required.
CSCI-421
3 Credits
This course provides a broad introduction to database management systems including data modeling, the relational model, and SQL. Database system implementation issues are covered next, where the focus is on data structures and algorithms used to implement database management systems. Topics include physical data organization, indexing and hashing, query processing and optimization, database recovery techniques, transaction management, concurrency control, and database performance evaluation. A programming project will be required.

In the News

  • October 11, 2022

    students sitting at a table and writing on a dry-erase board.

    RIT faculty prepare to teach large classes in SHED using scaled-up classroom

    A room in Slaughter Hall seats 150 students and is meant to simulate the learning spaces in the Student Hall for Exploration and Development (SHED) that will hold classes next fall. The Slaughter classroom, dubbed the “betaSHED,” combines three rooms to give professors and students a preview of the large-scale learning environment.