Generated on Tue Oct 25 10:19:18 2022

CS 482: Database Management Systems I (JSON)

Catalog description: Database design and implementation; models of database management systems; privacy, security, protection, recovery.

Prerequisites: At least a C- in C S 272 and C S 278.    (Catalog Link)

Credits: 3 (3)

Coordinator: Parth Nagarkar

Textbook: Database System Concepts. 6th ed., Silberschatz, Korth, Sudarshan. McGraw-Hill, ISBN-10: 0073523321 ISBN-13: 978-0073523323
    (also: online reading)

BS degree role: required

Course Learning Objectives

  1. Utilize the basic concepts of relational database model
  2. Utilize database query languages (e.g. SQL)
  3. Identify data integrity and security requirements
  4. Analyze, capture, and model user requirements for building database systems using conceptual models
  5. Design and normalize relational schemas
  6. Apply application development methods to implement a database system

Course Practicum Requirements

  1. Write SQL queries in an RDBMS (such as MySQL)
  2. Connect to a database using a programming language
  3. Manipulate data in a database using a programming language
  4. Implement an interface using a programming language to manipulate data in a database

Course Topics

  1. Relational Model
  2. SQL
  3. Relational Algebra
  4. Entity-Relationship Model
  5. Database Design

Course Improvement Decisions

(Course improvement decisions or recommendations from past assessments)

  1. SP19: include slide and explicit content on pros and cons of the two normal forms

ABET Outcome Coverage

(Provide Mapping to ABET Student Outcomes)

  1. An ability to apply knowledge of computing and mathematics appropriate to the discipline (Knowledge Application)
  2. An ability to analyze a problem, and identify and define the computing requirements appropriate to its solution (Problem Analysis)
  3. An ability to design, implement, and evaluate a computer-based system, process, component, or program to meet desired needs (Design & Implementation)
  4. An ability to use current techniques, skills, and tools necessary for computing practice (Techniques & Tools)
  5. An ability to apply mathematical foundations, algorithmic principles, and computer science theory in the modeling and design of computer-based systems in a way that demonstrates comprehension of the tradeoffs involved in design choices (CS Knowledge Application)
  6. An ability to apply design and development principles in the construction of software systems of varying complexity (Complexity & Scale)

Other Notes

(Any important notes or issues to consider)

  1. none