DBA 130 - Database Theory

5 CR

Develops in-depth understanding of database concepts and terminology, emphasizing the relational databases model. Understanding the role of Structured Query Language (SQL), data modeling and normalization of database tables.

Prerequisite(s): BUSIT 103 with a C or better. Placement by assessment into ENGL 101, or completion of ENGL 092 or ENGL 093 with a C or better.

Course Outcomes

Define common database terminology such as entities, attributes and relationships.
Write SQL statements to manipulate data (Data Manipulation Language subset of SQL)
Use normalization to design Database tables
Evaluate the normalization level of an existing table
Create and use Entity-Relationship (E-R) modeling concepts
Make good design decisions with respect to entity organization, data types, and database-specific issues
Research hiring requirements for careers in Database Programming and related fields, identifying personal skills, gaps in the student’s background, and pathways to obtain missing skills.

Find out when this course is offered