Question: Tahla Mama. TDing Table Name: TYPE begin{tabular}{|l|l|} hline Type_Code & Type_Description hline 1 & Pick-up truck, .5 ton hline 2 & Single axle

 Tahla Mama. TDing Table Name: TYPE \begin{tabular}{|l|l|} \hline Type_Code & Type_Description
\\ \hline 1 & Pick-up truck, .5 ton \\ \hline 2 &
Single axle dump truck \\ \hline 3 & Panel truck \\ \hline

Tahla Mama. TDing Table Name: TYPE \begin{tabular}{|l|l|} \hline Type_Code & Type_Description \\ \hline 1 & Pick-up truck, .5 ton \\ \hline 2 & Single axle dump truck \\ \hline 3 & Panel truck \\ \hline 4 & Double axle, 16 wheels \\ \hline \end{tabular} 1. Are these two tables (Truck and Type) violating any referential integrity if they are linked together (Yes/No)? Explain your answer in writing, make sure you mention which table is the parent table and which table is the child table, and which table has the foreign key? 2. What is the foreign key of the table TYPE (if any)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!