Explain referential integrity. Do the tables exhibit referential integrity?

 

Answer here:

Referential integrity means: ____

Table	Referential Integrity (Yes/No)
STUDENT
ADVISOR
DEPARTMENT

STUDENT StudentID SFirstName SLastName SEmail Andrews B01234765 Matthew B01234766 Lisa Brisbon B01234767 Douglas Fischer B01234768 Terry Hwang B01234769 Tzu Lai B01234770 Chip B01234771 James. Marino Thompson B01234772 Johnson Ariel B01234773 Robin Garcia B01234774 Charles Arles B01234775 Jeffery B01234775 Miguel ADVISOR Pearson Sears AdviseriD AFirstName ALastName 346723 Linda Baker Valdez 346724 Richard 346725 Mike 346726 Susan 346727 Shuaifu 346728 Tim Casey Taing Lin Myers Matthew.Andrews@ourcampus.edu Lisa.Brisbon@ourcampus.edu Douglas.Fischer@ourcampus.edu Terry.Hwang@ourcampus.edu Tzu.Lai@ourcampus.edu Chip.Marino@ourcampus.edu James.Thompson@ourcampus.edu JohnsonAriel@ourcampus.edu Robin.Garcia@ourcampus.edu JAA@ourcampus.edu Jpearson@ourcampus.edu msears@ourcampus.edu =Y AEmail Linda.Baker@ourcampus.edu Richard.Valdez@ourcampus.edu Mike.Casey@ourcampus.edu Susan.Taing@ourcampus.edu SF.Lin@ourcampus.edu Tim.Myers@ourcampus.edu AdviserID 346723 346724 346725 346726 346727 346728 346723 346724 346725 346726 346727 346728 ADept 1 2 2 3 3 4, DEPARTMENT DeptID DeptName Accounting 1 2 3 Management Management Information Systems College DeptExt Business 1234 Business 2234 Business 3234