Model and design databases using entity relationship (ER) diagrams
Normalize database tables
Implement physical database tables
Define referential constraints-primary and unique key indexes-and check constraints to enforce data integrity
Use simple and complex SQL statements on single and multiple tables
Thorough and updated coverage of database design and SQL for DB2 are the focus of this guide for the relational database-management system used on IBM i computer systems. Suitable for classroom instruction or self-study, this book explains the most widely used database language and the way that language is implemented on a variety of computer platforms. Topics covered include database concepts, SQL inquiries, web applications, and database security, and the material is reinforced by numerous illustrations, examples, and exercises.