CS348 Study Guide - Final Guide: Third Normal Form, Serializability, Database Normalization
Document Summary
Embedded sql: 2 problems to take care of - casting data values; set-oriented nature of sql, declaration types, error sqlcode, sqlstate. Cursors: fetch (multiple rows), into (single row, cursor declaration, for read only (default if insensitive or scroll), for update (default otherwise, scroll, insensitive, with hold, order by. Jdbc architecture application, driver manager, drivers, data sources. Dbms-independent at source code as well as level of the executable. Stored procedures: declaration in, out, inout parameters, call from sql, from embedded sql, from jdbc, from sqlj, sql/psm. Relationship sets (without constraints) to tables: we need to explicitly name the referenced field of employees because the field name differs from the name(s) of the referring field(s). Relationship sets (with constraints) to tables: key constraints, 2 approaches, creating a new table for the relationship set slow, adding information in the table corresponding with the key space wasted with. Problems due to redundancy: null values can address insertion and deletion anomalies in some cases.