Identify examples of Uniqueness constraints * For clearer image, here is link to
ID: 3886561 • Letter: I
Question
Identify examples of Uniqueness constraints
* For clearer image, here is link to photo... http://blogs.sas.com/content/sgf/files/2013/06/metatables.jpg
LONG case number LONGTEXT Investigation Child AdultOpeningProperties Opening PK investigation id LONG PK child id LONG PKadultopeningproperties id LONG PK opening id LONG -OFK1 opening id LONG LONG LONGTEXT LONGTEXT DATETIME birthdate DATETIME sex ethnicity CHAR(10) FK1 case id FK1 opening id LONG adult id list CHAR(10) FK2 adult id adult id list LONGTEXT FH- child id list LONGTEXT open date DATETIME close date DATETIME egbily CHAR(3) 0child id list marital staus CHAR(10) CHAR(10) CHAR(10) date of investigation verification decision chkbox 1 INTEGER verification decision chkbox 2 INTEGER verification decision_chkbox 3 INTEGER verification_decision chkbox 4 INTEGER PCG status Adult allegation verified CHAR(10) LONG PK adlt id ONG FK1 child id LONG LONG spell_start date DATETIME spell_end date DATETIME spell start reason CHAR(10) spell _end reason CHAR(10) DATETIME CHAR(10) birth_country CHAR(10) ethnicity CHAR(10) Ris PK riskassessment id LONG LONG LONGTEXT LONGTEXT FK1 opening id adult id (list) child id (ist) date of assessment DATETIME PK placement id INTEGER INTEGER INTEGER INTEGER FK1 spell id LONG Overriding condition 1 INTEGER Overriding_ condition 2 INTEGER placement start date DATETIME placement end date DATETIME CHAR(10) postal code TEXT(10)Explanation / Answer
Unique constraints - It provides the uniqueness in value of column attribute. both the unique and primary key provides it.
Table Name Primary Key Unique Constraint (Attribute) case case_id Opening opening_id case_id Investigation investigation_id opening_id RiskAssessment riskassessment_id opening_id Child child_id AdultOpeningProperities adultopeningproperities_id Spell spell_id child_id Adult adult_id Placement placement_id spell_id