Question: For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None to indicate no

For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None to indicate no FK

(P.2) Do the tables exhibit entity integrity? For each table answer yes or no and then explain your answer

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

(P.1) For each table, identify the primary key and

Table name: EMPLOYEE Database name: Ch03_Store Co EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE 21-May-64 09-Feb-69 02-Oct-61 01-Jun-71 23-Nov-59 25-Dec-65 31-Jul-62 10-Sep-68 19-Apr-55 06-Mar-66 21-Oct-72 08-Sep-74 25-Aug-64 25-May-66 24-May-64 03-Sep-60 12-Nov-70 24-Jan-71 03-Oct-68 06-Mar-70 11-Dec-74 1 Mr. 2 Ms. 3 Ms. 4 Mrs. 5 Mr. 6 Mr. 7 Mr. 8 Ms. 9 Mr. 10 Mrs. 11 Mr. 12 Mr. 13 Mr. 14 Ms. 15 Mr. 16 Mr. 17 Ms. 18 Mr. 19 Mr. 20 Mr. 21 Ms. Williamson John Ratula Nancy Greenboro Lottie Rumpersfro Jennie Smith Robert Renselaer Cary Ogallo Johnsson Eindsmar Jones 1 East 2 West Broderick Washington Smith Smith Olenko Archialo Grimaldo Rosenberg Rosten Mckee Baumann Table name: STORE STORE_CODE STORE_NAME 1 Access Junction 2 Database Corner 3 Tuple Charge 4 Attribute Alley 5 Primary Key Point Table name: REGION REGION_CODE REGION_DESCRIPT Roberto Elizabeth Jack Rose Tom Alan Peter Sherry Howard Barry Jeanine Andrew Peter Robert Jennifer W 1003455.76 1421987.39 986783.22 944568.56 2930098.45 RSLAS I W R Y

Step by Step Solution

★★★★★

3.43 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Ans Table Primary key Foreignkey Employee EMPCODE S... View full answer

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!

For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided.

For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write none in the space provided. Discuss.

War W30 Three tables Employee, Store and Region are given in Figure P3.1. Please go through these tables and answer the following questions. (Hint: Each store employs many employees, one of whom...

FIGURE P3.10 THE CH03_BENECO DATABASETABLES Use the database shown in Figure P3.10 to work Problems 10-16. Note that the database is composed of four tables that reflect these relationships: - An...

Question 6 1 pts Declare a 32-bit signed integer variable and initialize it with the smallest possible negative decimal value. smallVal WORD 65535 O smallVal DWORD 12345678h smallVal SDWORD 00000000h...

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

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

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

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

Cash MONTY WHOLESALE INC. Adjusted Trial Balance December 31, 2021 Debit Credit $12,570 Accounts receivable 20,050 Prepaid insurance 2,470 Inventory 106,670 Supplies 6,570 Land 131,070 Buildings...

(LO3, 4, 6) Exercises 4-24 Indirect cost rates and the death spiral Famous Flange Company manufactures a variety of special flanges for numerous customers. Annual capacity-related (manufacturing...

Page No. Date (6) On 30 september 2014, Razor's closing inventory was counted and valved at its cast of Tas I million inventory which had cost demaged Some item T2s 210,000 Gad been in a flood Con is...

12 SC 301 student is comparing between two stocks to invest in: Stock A and Stock B. owing are the stock returns (in dollars) in the last 10 months (sample). Monthly Returns Stock A Stock B 585 960...

Economic Order Quantity Self- Quiz Problem P=$5 D=20,000 O=$10 I=10% H= $.75 The hospital has only $90,000 budgeted for the product. What is the new price the hospital must negotiate with the vendor...

*Remember to read at least 50% of your classmates posts. 1. Use inference* to identify the possible strengths of the family. 2. Use inference* to identify the possible challenges of the family. 3....

You currently own 5 percent of the 2 million outstanding shares of Webster Mills. The company has just announced a rights offering with a subscription price of $40. One right will be issued for each...

In Exercises 105108, evaluate each expression without using a calculator. log(ln e)

National Bank pays a check on which the signature of the drawer, Dee, is forged. The forger is Dee's brother, Rick. The bank tries to recover the loss from Dee and Rick. Will the bank be successful?...

Explain the OLE-DB model based on its two types of objects

Explain why database design is important.

Using the same procedures and concepts employed in Problem 1, how would you create an information system for the Tiny College example in Chapter 4?

In the transmission of digital information, the probability that a bit has high, moderate, or low distortion is 0.01, 0.04, and 0.95, respectively. Suppose that three bits are transmitted and that...

Bedard Ltd. reported net income of 300,000 in 2019 and had 200,000 ordinary shares outstanding throughout the year. Also outstanding all year were 45,000 options to purchase ordinary shares at 10 per...

a. Use the data entry method in your scientific calculator to enter the five measurements. Recall the proper memories to find the sample mean and standard deviation. b. Verify that the calculator...