Sep 24, 2022  
2020-2021 SGPP Catalog and Handbook 
    
2020-2021 SGPP Catalog and Handbook [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

IT303 Data and Database Management Systems (3 cr.)


This course provides an overview of methods used to analyze, capture, process, and manage data resources. Database structures and models are examined. Design and normalization of data, database management systems, relational models, and query interfaces are also studied.

Upon completion of this course, students are expected to be able to do the following:

  1. Articulate fundamental database concepts.
  2. Interpret a simple business problem to extract requirements and express them in data model.
  3. Explain the value of different types of database used to solve business problems.
  4. Communicate business requirements via industry standard diagrams.
  5. Describe relational table design and the pitfalls of poor design.
  6. Explain the fundamentals of structured query language (SQL).
  7. Evaluate a data model and propose a database structure to match.
     



Add to Portfolio (opens a new window)