1. For each table, clearly identify the primary key and any/all foreign key(s). If a table does not have a foreign key, write None. If a key is a composite key, be sure to separate its components with +

2. Do the tables exhibit entity integrity? Answer yes or no and then explain your answer.

3. Do the tables exhibit referential integrity? Answer yes or no and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key.

4. Identify the vehicle tables candidate key(s).

5. For the type table, identify a superkey and a secondary key.

6. If you were to create a conceptual model for the database tables, it would have 2 relationships. One these relationships can be described as:

A 1-M relationship exists between type and vehicle. A type identifies the body configuration (sedan, truck, or SUV) of one or more vehicles. Each vehicle has one and only one type.

What is the other relationship? When providing your answer, be sure to identify in a similar fashion, including the type and direction of relationship and the entities involved.

vehicle essembly plant id type code model 2019004 2019005 201900G 2019007 2019008 2019009 2019010 2019011 502 501 50: 501 502 503 1 Volt 1 Cruz 2 colorado 1 Cruz 1 Volt 2 Silverado 1 Camaro 1 Corvette colot Blue White Black Silver Red Black 1.5 liter 4 cylinder 192855X2580M 14 liter 4 ylinder 98683Y640LNS432 2.5 Bter 4 cylinder 8929405786718220 .4 iter 4 cylinder 34644213 10210234! 1.5 liter 4 cylinder 2553N3260047avu 6.0 liter 8 cylinder 55205987440133 7EF 3S liter 6 cylinder 307759A998 6S 5.2 liter 8cyinde' :58551 1N8406027 ta Red S04 Blaak assembly_plant ld lety 501 Marlesboro hane state ares code TN KY MO GA 502 Lexington 503 Cape Gilliam 504 Dalton G15 123-3131 568 234-7809 454 322.5781 Andrew Gallbghes Marla Pistonia Mark Mallam 901 442-2371 type lar 1 Sedari 2 Truek