This chapter introduces the fundamental principles of relational database design. A thorough database design throughout the development process is critical to successful database functionality and performance.
This chapter explains how to add data to a database using either Zen applications or SQL statements. It also explains how to drop (delete) rows, indexes, columns, or tables from your database or drop an entire database when you no longer need it.
This chapter explains how to modify table definitions, column attributes, and data. You can perform these tasks by entering SQL statements using an interactive application.
This chapter discusses defining relationships among tables, administering database security, and controlling concurrency with transactions. It also discusses atomicity in Zen databases.