Description
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.
At the conclusion of the course a student 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.