Insy 3304 - Study guides, Class notes & Summaries

Exam 2 INSY 3304 EXAM STUDY GUIDE WITH COMPLETE SOLUTIONS 1NF - Answer-first normal form. table format. no repeating groups SQL - Answer-Structured Query Language. The standardized relational database language for defining database objects and manipulating data. 2NF - Answer-Second Normal Form- 1NF and no partial dependencies 3NF - Answer-Third Normal Form- 2NF and no Transitive dependencies Parts of Dependencies - Answer-- Functional -Full functional - Partial -Transitive Functional...

INSY 3304 CH 3 EXAM STUDY GUIDE WITH COMPLETE SOLUTIONS If a foreign key contains either matching values or nulls, the tables that make use of such a foreign key are said to exhibit ________ integrity. - Answer-Referential The use of a(n) ________ relationship ensures that two entity sets are not placed in the same table when they should not be. - Answer-1 : 1 A relational operator that yields all rows in one table that are not found in the other table is the ________ operator. - Answer-d...