Identify examples of Integrity constraints * For clearer image, here is link to
ID: 3886555 • Letter: I
Question
Identify examples of Integrity 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
Here are the integrity constraints present in the provided schema:
1. Primary Key:
2. Foreign Key:
Table Primary Key Case case_id Opening opening_id Investigation investigation_id Child child_id AdultOpeningProperties adultopeningproperties_id Spell spell_id Adult adult_id RiskAssessment riskassessment_id Placement placement_id