Question: 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

Use the database shown in Figure 1 to answer

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 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. Describe the type(s) of relationship(s) between STORE and REGION. 5. Describe the type(s) of relationship(s) between EMPLOYEE and STORE. Smith Table name: EMPLOYEE EMP_CODE EMP_TITLE EMP_LNAME 1 Mr Williamson 2 Ms. Ratula 3 Ms. Greenboro 4 Mrs. Rumperstro 5 Mr 6 Mr. Renselaer 7 Mr Ogallo 8 Ms. Johnsson 9 Mr Eindsmar 10 Mrs. Jones 11 Mr Broderick 12 Mr Washington 13 Mr Smith 14 Ms. Smith 15 Mr Olenko 16 Mr Archialo 17 Ms. Grimaldo 18 Mr Rosenberg 19 Mr. Rosten 20 Mr. Mckee 21 MS Baumann Database name: Ch03_StoreCo EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE John w 21-May-64 3 Nancy 09-Feb-69 2 Lottie R 02-Oct-61 4 Jennie S 01-Jun-71 5 Robert L 23-Nov-59 3 Cary 25-Dec-65 1 Roberto s 31-Jul-62 Elizabeth 1 10-Sep-68 1 Jack w 19-Apr-55 2 Rose R 06-Mar-66 4 Tom 21-Oct-72 3 Alan 08-Sep-74 2 Peter N 25-Aug-64 3 Sherry H 25-May-66 4 Howard U 24-May-64 5 Barry 03-Sep-60 5 Jeanine K 12-Nov-70 4 Andrew D 24-Jan-71 4 Peter F 03-Oct-68 4 Robert S 06-Mar-70 1 Jennifer 11-Dec-74 3 > ZIYOL EMP_CODE 8 Table name: STORE STORE CODE STORE_NAME 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point STORE_YTD_SALES REGION_CODE 1003455.76 2 1421987 39 2 986783 22 1 944568.56 2 2930098 45 1 12 7 3 15 Table name: REGION REGION_CODE REGION_DESCRIPT 1 East 2 West

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 in Figure 1 to answer Problems 15. 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...

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...

MIS 560 Database Management Systems-Assignment Use the database shown in Figure P3.17 to answer Problems 17-23. 17. For each table, identify the primary key and the foreign key(s). If a table does...

MIS 560 Database Management Systems- Assignment Use the database shown in Figure P3.17 to answer Problems 17-23. 17. For each table, identify the primary key and the foreign key{s). If a table does...

Table name: TRUCK Primary key: TRUCK NUM Foreign key: BASE_CODE, TYPE_CODE Database name: Ch03_TransCo Table name: BASE Primary key: BASE_CODE Foraian kexv nono Table name: TYPE Primary key:...

Ch03_StoreCo Use the database shown in Figure P3.1 to answer Problems 1-9. 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....

Table name: EMPLOYEE Database name: Ch03_StoreCo EMP CODE EMP TITLE BMP LNAME EMP_FNAME EMP_INTIAL EMP DOB STORE CODE 1 Nr. Wiliamson John W 21-May-84 2 MS. Ratula Nancy 09-Feb-89 3 Ns. Greenboro...

11. Social media marketing has been the focus of many companies. According to a marketing survey, 62% of adults use some form of social networking. Random samples of 100 adults are selected. 130....

How does the stem-and-leaf plot show the distribution of these data? O A. The lengths of the rows are similar to the widths of bars in a histogram; longer rows of data correspond to higher frequer O...

Before reissuing a company s prior - year review report, an accountant becomes aware of information that may have a material effect on the prior year s financial statements. Which of the following...

What is an example of constructive feedback? provide reference