Database Design and SQL for DB2

Database Design and SQL for DB2

• 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

<div>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.</div>