Figure this out for class activity. Use the database shown below. Note that the database is composed
Fantastic news! We've Found the answer you've been seeking!
Question:
Figure this out for class activity.
Transcribed Image Text:
Use the database shown below. Note that the database is composed of four tables that reflect these relationships: An EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEES. An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEES. Note also that the M:N relationship has been broken down into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity. Table name: EMPLOYEE EMP CODE EMP_LNAME JOB_CODE 14 Rudell Database name: Ch03_BeneCo Table name: BENEFIT EMP_CODE PLAN_CODE 2 15 2 15 McDade 1 15 3 16 Ruellardo 1 16 1 17 Smith 3 17 1 20 Smith 2 17 3 17 4 20 3 Table name: JOB JOB CODE JOB DESCRIPTION 1 Clerical 2 Technical 3 Managerial Table name: PLAN PLAN_CODE PLAN DESCRIPTION 1 Term life 2 Stock purchase 3 Long-term disability 4 Dental For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space provided. TABLE PRIMARY KEY FOREIGN KEY(S) EMPLOYEE BENEFIT JOB PLAN Use the database shown below. Note that the database is composed of four tables that reflect these relationships: An EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEES. An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEES. Note also that the M:N relationship has been broken down into two 1:M relationships for which the BENEFIT table serves as the composite or bridge entity. Table name: EMPLOYEE EMP CODE EMP_LNAME JOB_CODE 14 Rudell Database name: Ch03_BeneCo Table name: BENEFIT EMP_CODE PLAN_CODE 2 15 2 15 McDade 1 15 3 16 Ruellardo 1 16 1 17 Smith 3 17 1 20 Smith 2 17 3 17 4 20 3 Table name: JOB JOB CODE JOB DESCRIPTION 1 Clerical 2 Technical 3 Managerial Table name: PLAN PLAN_CODE PLAN DESCRIPTION 1 Term life 2 Stock purchase 3 Long-term disability 4 Dental For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space provided. TABLE PRIMARY KEY FOREIGN KEY(S) EMPLOYEE BENEFIT JOB PLAN
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
A person's metabolic rate tends to go up after eating a meal and then, after some time has passed, it returns to a resting metabolic rate. This phenomenon is known as the thermic effect of food, and...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Jason and Mary Wells, friends of yours, were married on December 30, 2020. They know you are studying taxes and have sent you an e-mail with a question concerning their filing status. Jason and Mary...
-
Because of variability in the manufacturing process, the actual yielding point of a sample of mild steel subjected to increasing stress will usually differ from the theoretical yielding point. Let p...
-
Everything else held constant, would you rather depreciate a project with straight-line depreciation or with DDB?
-
How do groups/teams communicate differently than individuals?
-
Helen Weeks has worked for Bonne Consulting Group (BCG) as the executive secretary in the administrative department for nearly 10 years. Her apparent integrity and dedication to her work has quickly...
-
Compare and contrast arbitration and judicial proceedings. Explain the evidence in arbitration vs. in judicial proceedings. Discuss how arbitration works in the railway and airline industries today.
-
Rina's Performance Pizza is a small restaurant in Denver that sells gluten-free pizzas. Rina's very tiny kitchen has barely enough room for the three ovens in which her workers bake the pizzas. Rina...
-
What is the cash flow effect on asset purchases and depreciation ? What are sunk costs ? Describe negative within-firm externalities as they pertain to cash flow versus accounting income.
-
Prepare an absorption - costing income statement. Cost of Goods Manufactured, Income Statement Orman Company produces neon-colored covers for tablets (e.g., iPads). For last year, Orman reported the...
-
Consider the second order homogeneous differential equation given by dy - 4 dy+4y=0 dx dx . Solve this differential equation using the method of separation of variables.
-
(a) A block of mass m = 4.40 kg is suspended as shown in the diagram below. Spring Scale m Assume the pulley to be frictionless and the mass of the strings to be negligible. If the system is in...
-
An electric field does 2.61 x 10 3 eV of work on an oxygen nucleus of charge 1.28 x 10 -18 C. Find the change in the nucleus' electric potential and electric potential energy in joules.
-
5. Boundary Value Problem: Consider the boundary value problem given by d y =-y dx with boundary conditions and y(0) = 1 y() = -1 . Solve this problem using the method of separation of variables.
-
Peterson wants to all-in into the sports lottery. He will invest 5,000 (his life savings) in fl Abu Dhabi Grand Prix. Use given information to calculate the expected value of his gamble. Bet on...
-
The Home Depot is the leading retailer in the home improvement industry and one of the 10largest retailers in the United States. The company included the following on its January 29, 2012, balance...
-
John Fuji (age 37) moved from California to Washington in December 2011. He lives at 468 Cameo Street, Yakima, WA 98901. John's Social Security number is 571-78-5974 and he is single. His earnings...
-
Your supervisor has asked you to research the following situation concerning Owen and Lisa Cordoncillo. Owen and Lisa are brother and sister. In May 2012, Owen and Lisa exchange business pickup...
-
Dr. Ivan I. Incisor and his wife Irene are married and file a joint return for 2012. Ivan's Social Security number is 477-34-4321 and he is 48 years old. Irene I. Incisor's Social Security number is...
-
Using the information presented in Figure 1.1, list THREE key user groups for each of the following organizations and briefly explain what each group might hope to ascertain from the publicly...
-
Can you provide a suggestion for each of the following, briefly explaining your rationale: (i) A balance which could be material owing to its magnitude? (ii) A balance which could be material owing...
-
The internationalization of financial reporting has attracted significant attention. There are many in favour and, equally, many opposed. The United States (US), for example, has continued to use US...
Study smarter with the SolutionInn App