Assignment 7.docx INFO321 American Public University INFO321 Part I Purpose of inte

Document Content and Description Below

Assignment 7.docx INFO321 American Public University INFO321 Part I Purpose of integrity constraints Integrity constraints are the rules put in place to ensure the accuracy of the database. It... is through integrity constraints processes that databases uphold their integrity. Therefore, it is through integrity constraints rules that database systems could be marked as secure. In fact, these rules protect the database against tempering or loss of piece or entire data. There are several integrity constraints that can be found on a logical data model, namely: required model, multiplicity, entity integrity, referential integrity, and general constraint. Required data refers to attributes that always require a value. An attribute cannot have a null value associated with it. For example, a store s database that holds customer information must always have a customer Name associated to hold a value to be ab. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [Show More]

Last updated: 1 year ago

Preview 1 out of 3 pages