ITSE 1346 - DATABASE THEORY AND DESIGN

Introduction to the analysis and utilization of data requirements and organization into normalized tables using the four normal forms of database design.

Lab fees apply

Upon completion, students will be able to:

  • Organize data into normalized tables by applying the four normal forms of database design
  • Create Entity-Relationship models and diagrams to graphically represent their database design
  • Design database tables with One-to-Many and Many-to-Many relationships
  • Create tables using the SQL "create" and "insert" statements
  • Retrieve data from tables using SQL "select" statement
  • Maintain data in tables using the SQL "update" and "delete" statements
  • Implement stored procedures, triggers, and constraints using SQL statements

Grade Basis: L
Credit Hours: 3
Lecture hours: 32.0
Lab hours: 32.0