Analyzing Integrity Control

Control That Forces
Name
Institutional Affiliation
What kind of integrity control is this in the database? For SQL. For example: where you discussed the control that forces the correct format of a phone number to be entered.
Data Integrity Controls
Broadly speaking there is physical integrity and logical integrity, which are the two types of data integrity. Physical integrity is necessary to protect get whole data and ensure accuracy Logical integrity ensures that data remains unchanged and the data is protected from human errors and malicious actors. Logical integrity is divided into entity integrity, referential integrity, domain integrity, and user-defined integrity. There are other data integrity controls such as
Entity integrity
Entity integrity provides primary key values and is essential as the primary keys are unique identifiers for each table in a database. Entity integrity is part of effective database construction where no key primary values are null (Rankins et al., 2015).
Input Controls
Input Controls determine the type of information that can be entered and authorization. Input controls are necessary for other several security and integrity of the data. Transactions should be properly authorized and there is an emphasis on data authenticity, accuracy, timeliness, and completeness. There are also field combinat...