Data Integrity

-
Data Integrity falls into
1. Entity Integrity
2. Domain Integrity
3. Referential integrity
4. User defined integrity
Entity Integrity: Defines row as unique instance of an entity for a particular table
Domain Integrity: Is the validity of entries for a given column enforced by
i. restricting Type
ii. format
iii. Range of possible
E.g.: CHECK constraints, UNIQUE constraints, and DEFAULT constraints
Referential Integrity: Preserves defined relationships between tables when altered or deleted. E.g.: Check, Foreign key
User defined Integrity: Business rules can be enforced using triggers and stored procedures.

Reference:http://odetocode.com/Articles/79.aspx

Comments

Post a Comment

Popular posts from this blog

SharePoint 2019 New Features

-
  SharePoint 2019 Majorly brought modern experience available in Online Communication sites: Communication sites are a place to share news, showcase a story, or broadcast a message to other people Create fast sites Fast site creation in SharePoint Server 2019 allows users create new sites in a few seconds ·        OneDrive personal site [SPSPERS#10] ·        Team site (modern only) [STS#3] ·        Communication site [SITEPAGEPUBLISHING#0] Modern Experience SharePoint Server 2019 contains the modern experiences for lists and libraries in Team sites. 1.      Lists and Libraries 2.      Modern WebPart 3.      Site Page 4.      Modern Search Experience 5.      Team Sites Integration with Power Apps, Power BI and Power Automate From the SharePoint home page, you can create sites in different web applications Sync files with the new OneDrive sync app Improved Hybrid Experience    
Read more

Move the list items from one list to another list using PowerShell - SharePoint 2010

-
Using below script one can move items from one list to another(including CreatedBy/ModifiedBy which are configured in a list(source,target,item age). #*************************************************************************** # Moves list/library items from one location to another location for archiving. Remove-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue $srcListSiteUrl = http://testsite $ConfigListName = "ArchivalConfiguration" $IDFieldName = "OldItemID"  $date = Get-Date -format y $ldate = Get-Date $LogDate = $date -replace " ", "_" $path = "C:\Jobs\ArchivalLog\" If(!(test-path $path)) {     New-Item -ItemType Directory -Force -Path $path } $Logfile = "$($path)\$($LogDate).log" Add-content $Logfile -value "******************************************************************************" Add-cont
Read more

Email Validation for SharePoint list column

-
Image
Please use the below formula in [Column validation] of the list column edit section. Please replace the [Email] with your column name. Formula: --------------------------------------------------------------------- =AND(     ISERROR(FIND(" ", [Email],1)),     IF(ISERROR(FIND("@", [Email],2)),         FALSE,         AND(             ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),             IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),                 FALSE,                 FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])             )         )     ) ) ------------------------------------------------------------------------  
Read more