Apr 27, 2024  
College Catalog 2020-2021 
    
College Catalog 2020-2021 [ARCHIVED CATALOG]

CSI 130 - Database Design


5 Credits
This is an introductory course for the student with little or no experience designing and building relational databases. The students learn the basics of relational database theory and rules of normalization, and how to incorporate business requirements into the design for a database. They also learn to use a program or language such as Structured Query Language (SQL) to create basic database objects and to manipulate data.

Course Outcomes
  1. Explain the structure of tables and the function of keys in a relational database.
  2. Manipulate data using SQL query.
  3. Constructor SQL queries to update, filter, compound, calculate, and order data or select groups of data.
  4. Produce queries to retrieve information from the databases and evaluate the results.
  5. Retrieve data from multiple tables.