Chapter 4: SQL Background Basic Structure Set Operations Aggregate Functions Null Values Nested Subqueries Derived Relations Views Modification of the Database Joined Relations

Chapter 15: Transactions Transaction Concept Transaction State Implementation of Atomicity and Durability Concurrent Executions Serializability Recoverability Implementation of Isolation Transaction Definition in SQL

ELECTRONIC NOSE SYSTEMS Odorant molecules Chemical Information CIM Coated Sensor Raw electrical signal Sensor processor Processed electrical signal Signal processor Denoised Electrical signal

Chapter 7: Relational Database Design First Normal Form Pitfalls in Relational Database Design Functional Dependencies Decomposition Boyce-Codd Normal Form Third Normal Form Multivalued Dependencies and Fourth Normal Form

Chapter 2: Entity-Relationship Model Basic Concepts Constraints Keys Design Issues E-R Diagram Weak Entity Sets Extended E-R Features Design of an E-R Database Schema Reduction of an E-R Schema to Tables

Biodegradable Solid Polymers Spring 2003 Issued Day 1 5 points/problem(20 points total) 1. The chemical structure of a new degradable polymer, poly(ethylene glycol)-b-polylysine-b- poly (D, L-lactide), is shown below a. Based on chemical structure al

1. An early study in the development of peptide-presenting biomaterials showed that polymer surfaces bearing RGD peptides at a density equivalent to -10 peptides per each cell was sufficient to promote cell attachment, spreading and subsequent cell growth. In contrast, when whole

Biodegradable Solid Polymers Spring 2003 Issued Day 1 Day 3 1. The chemical structure of a new degradable polymer, poly (ethylene glycol)-b-polylysine-b- poly (D, L-lactide)

1. Re-derive the equation for equilibrium swelling of a polyelectrolyte gel where the polymer chains contain a basic ionizable group that becomes positively charged with decreasing pH

1. Re-derive the equation for equilibrium swelling of a polyelectrolyte gel where the polymer chains contain a basic ionizable group that becomes positively charged with decreasing pH