Assume that these are the only permissible values for a finite list of vehicle t
ID: 3722508 • Letter: A
Question
Assume that these are the only permissible values for a finite list of vehicle types (VEH_TYPE). This is knows as a what? ________________________________
In order to avoid nulls in the EMPLOYEE table, _______________________ can be used
Given the null values in VEH_ID on EMPLOYEE, do the two tables exhibit referential integrity? _________ (yes/no) Do they exhibit entity integrity? _________ (yes/no)
Table Name: FLEET Table Name: EMPLOYEE VEH ID VEH TYPE EMP CODE L NAME VEH ID 10 20 30 40 50 60 70 80 90 Davolio Grubb Leverling Penn Buchanan Smith King Callahan Dodsworth 1 Truck-FLOATER Truck Truck Truck Truck Van Line ServiceTruck 4 3 4 6Explanation / Answer
Assume that these are the only permissible values for a finite list of vehicle types (VEH_TYPE). This is knows as a what? CHECK constraint
In order to avoid nulls in the EMPLOYEE table, NOT NULL constraint can be used Given the null values in VEH_ID on EMPLOYEE,
Do the two tables exhibit referential integrity? Yes (foreign key to a related table)
Do they exhibit entity integrity? No (For exhibit entity integrity, each table has a primary key that uniquely identifies each entity and there are not nulls in them.)