SKIP TO PAGE CONTENT

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. 32 lecture hours + 32 laboratory hours

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