ISOM pwpt ch 7 continued again

ISOM pwpt ch 7 continued again - Integrity Constraints...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
2/17/11 17-1 Integrity Constraints Foreign Key: an attribute in one relation whose value is either required to match the value of the primary key for some row in another relation or the value is null Referential Integrity if a Table A contains a foreign key that matches the primary key of the Table B then values of this foreign key either must match the value of the primary key for
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2/17/11 27-2 Integrity Constraints Referential Integrity example: EMPLOYEES DEPARTMENTS SSN Name Age Dno DepNo DepName 111 Joe 30 1 1 Sales 222 Bob 34 1 2 333 Sue 29 2 444 Pam 24 1
Background image of page 2
2/17/11 37-3 Integrity Constraints Referential Integrity example: EMPLOYEES DEPARTMENTS SSN Name Age Dno DepNo DepName 111 Joe 30 1 1 Sales 222 Bob 34 2 333 Sue 29 2 444 Pam 24 1
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2/17/11 47-4 Integrity Constraints Referential Integrity example: EMPLOYEES DEPARTMENTS SSN Name Age Dno DepNo DepName 111 Joe 30 1 1 Sales 222 Bob 34 3 2 333 Sue 29 2 444 Pam 24 1
Background image of page 4
Click to edit Master subtitle style 2/17/11 57-5 Relational Database Model END
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/16/2011 for the course ISOM 247 taught by Professor Jukic during the Spring '08 term at Loyola Chicago.

Page1 / 10

ISOM pwpt ch 7 continued again - Integrity Constraints...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online