CS 320 - Databases and Information Management Systems

5.0 Credits
Exploration and practice with relational and non-relational databases, including cloud databases. Students will learn practical techniques for designing solutions for managing persistent data. Completion of CS 248 and CS 301 with a grade of 2.5 or higher or instructor permission.
Prerequisite Admission in the Computer Science Bachelors of Science program is required to take this course.
Course-level Learning Objectives (CLOs)
Upon successful completion of this course, students will be able to:

Design a relational database using the concepts from relational database design theory and organization.
Write concise and efficient queries.
Describe the principle of transactions.
Compare and contrast SQL, NoSQL, and NewSQL database design and development, including pros and cons of each.
Evaluate database programming tools to manage large datasets (e.g., Pig, Hive).
Compare and contrast techniques for storing persistent data, including cloud technologies and serverless programming.
Troubleshoot and normalize data including adding appropriate rules to assure data integrity.
Integrate a robust database into a software solution, such as a mobile app or website.

Course Typically Offered
Winter