CSC239-01 Database Systems Test #1 BUSINESS & COMPUTER SCIENCE DEPARTMENT DATABASE SYSTEMS Spring 2018 Page 3 . Using two relational database tables, PROJECT and MANAGER, eliminate the redundancies discovered in Problem through the appropriate link. 4. Make sure you use good naming conventions and connect the two tables D. From the word bank below, fill in the word into the left most column that best represents the definition on the same row or the table. (2 point each = 14 points) Primary Key Secondary Key Foreign Key Candidate Key Super Key Entity Integrity Referential Integrity An attribute (or combination of attributes) that uniquely identifies each entity in a table A minimal superkey. A superkey that does not contain a subset of atributes that is itself a superkey A candidate key selected to uniquely identify all other attribute values in any given row. Cannot contain null entries. An attribute (or combination of attributes) used strictly for data retrieval purposes An attribute (or combination of attributes) in one table whose values must match the primary key in another table or whose value must be null. Purpose Example Integrity Type Requirement Guarantees that each Each car has a unique VIN entity will have a (Vehicle Identification Number) to All entries are unique. No null entries in a primary unique identity. key insure its proper identification. Foreign key must Makes it possible for A customer may not (yet) have an have either a an attribute NOT to assigned sales representative entry or a matching have a corresponding (number), but it will be impossible entry attribute, but it wil to have an invalid sales he reprentaive (mumber an invalid entry