1. The following are two tables with data for a Customer-Order database. Answer the following questions based on these two tables.

1. Explain entity integrity. Do the tables exhibit entity integrity?

Answer:

2. Explain referential integrity. Do the tables exhibit referential integrity?

Answer:

\begin{tabular}{|c|c|r|r|} \hline & & & ORDER \\ \hline CustomerlD CustomerName & & & \\ \hline 1 Contemporary Casuals & 1001 & 10/21/21 & 1 \\ \hline 2 Value Furniture & 1002 & 10/21/21 & 8 \\ \hline 3 Home Furnisings & 1003 & 10/21/21 & 10 \\ \hline 4 Eastern Furniture & 1004 & 10/22/21 & 5 \\ \hline 5 Impressions & 1005 & 10/22/21 & 3 \\ \hline 6 Furniture Gallery & 1006 & 10/24/21 & 2 \\ \hline 7 Period Furniture & 1007 & 10/24/21 & 11 \\ \hline 8 California Classics & 1008 & 10/27/21 & 12 \\ \hline 9 M and H Casual Furniture & 1009 & 11/5/21 & 4 \\ \hline 10 Seminole Interiors & 1010 & 11/5/21 & 18 \\ \hline 11 American Euro Lifestyles & & & \\ \hline 12 Battle Creek Furniture & & & \\ \hline \end{tabular}