Question: 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2. Do

1. For each table, identify the primary key and the foreign key(s). If a table does not have a

foreign key, write None.

2. Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer. 1. For each table, identify the primary key and

\begin{tabular}{|l|l|l|l|} \hline customer-id & customer-name & customer-street & customer-city \\ \hline \hline 192837465 & Johnson & 12 Alma St. & Palo Alto \\ 019283746 & Smith & 4 North St. & Rye \\ 677899011 & Hayes & 3 Main St. & Harrison \\ 182736091 & Turner & 123 Putnam Ave. & Stamford \\ 321123123 & Jones & 100 Main St. & Harrison \\ 336669999 & Lindsay & 175 Park Ave. & Pittsfield \\ 019283746 & Smith & 72 North St. & Rye \\ \hline \end{tabular} (a) The customer table \begin{tabular}{|c|c|} \hline customer-id & account-number \\ \hline \hline 192837465 & A101 \\ 192837465 & A201 \\ 019283746 & A215 \\ 677899011 & A102 \\ 182736091 & A305 \\ 321123123 & A217 \\ 336669999 & A222 \\ 019283746 & A201 \\ \hline \end{tabular} (c) The depositor table \begin{tabular}{|c|c|} \hline account-number & balance \\ \hline \hline A-101 & 500 \\ A-215 & 700 \\ A-102 & 400 \\ A-305 & 350 \\ A-201 & 900 \\ A-217 & 750 \\ A-222 & 700 \\ \hline \end{tabular} (b) The account table

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 General Management Questions!

Use the database shown above to answer Problems 1- For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2- Do the tables exhibit entity...

database tables need help woth questions 1,2,3,4,7,9 Figure P3.1 The CH03_Storeco Database Tables Dhes Storeco Details 1. For each table, identify the primary key and the foreign key(s). If a table...

Use the database shown in Figure 1 to answer Problems 1-5. 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2. Do the tables...

The zip file for chapter 3 that you have downloaded will contain this database . 1. 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write...

Database Management, guaranteed thumbs up! 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None . 2. Do the tables exhibit entity...

Complete all problems, thank you P 3 . 1 THE CH 0 3 _ STORECO DATABASE TABLES Table name: EMPLOYEE Database name: Ch 0 3 _ StoreCo Table name: STORE Table name: REGION 1 . For each table, identify...

1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2. Do the tables exhibit entity integrity? Answer yes or no, and then explain...

Use the database shown in Figure 1 to answer Problems 1-5. 1. For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. 2. Do the tables...

1. What does the recent economic history of Brazil tell you about the relationship between price inflation and exchange rates? What other factors might determine exchange rates for the Brazilian...

The carbohydrate digitoxose contains 48.64% carbon and 8.16% hydrogen. The addition of 18.0 g of this compound to 100. g of water gives a solution that has a freezing point of -2.2C. a. What is the...

Lilly Company has been depreciating equipment for 1 0 years with an estimated total useful life of 2 5 years. Lilly has revised the estimated life to be only 1 7 years, with 7 years remaining in the...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...