Foundation Db2 and Python: Access Db2 with Module-Based API Examples Using Python

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2021

W. D. AshleyFoundation Db2 and Pythonhttps://doi.org/10.1007/978-1-4842-6942-8_6

6. Business Rules and Constraints

W. David Ashley¹  

(1)

Austin, TX, USA

 

Creating business rules and constraints on your SQL tables is actually a part of the database design phase. We treat it as a separate topic as these rules can be added later instead of creating them at the same time as the tables. This is really a good thing as none of us can think of everything during the design phase.

There are two kinds of business rules and constraints – those that perform referential integrity of the tables and those that apply actual business rules. These two kinds of constraints are ...