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
-
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...
-
An experiment was performed to compare the fracture toughness of high-purity 18 Ni maraging steel with commercial-purity steel of the same type (Corrosion Science, 1971: 723-736). For m = 32...
-
Who in a firm should be responsible for industry analysis? Assume that the firm does not have a strategic planning department.
-
What is the default filename that make will process if no other is given?
-
Completed-Contract Method) Monat Construction Company, Inc., entered into a firm fixed price contract with Hyatt Clinic on July 1, 2010, to construct a four-story office building. At that time, Monat...
-
The population in January 2 0 0 3 was estimated to be about 6 . 3 0 billion people. Assume that the population will continue to grow exponentially at the rate of about 1 . 3 % per year. Then the...
-
On July 10 2022 you purchase a 10000 par T note that matures in five years the coupon rate is 8 percent the last coupon payment was may 1 2022 and the next payment is November 1 2022 settlement will...
-
Here is the pre-adjustment trial balance of Tsepo Ltd as at 31 March 20x4: This additional information relates to the trial balance: 1. The plant and machinery were bought on 1 April 20x0. A machine...
-
Badam Gussain, Vice-President (Accounts) of Sach International Corporation, Singapore was taken aback when he reviewed the financial performance of the company. He noticed that the sales for the...
-
Look at Table 12.1 and Figure 12.7 in the text. When were T-bill rates at their highest over the period from 1926 through 2007? Why do you think they were so high during this period? What...
-
What is the output of the following? A. 5 B. 6 C. 7 D. The code does not compile. E. The code compiles but throws an exception at runtime. F. The code compiles but enters an infinite loop at runtime....
-
How many sheets of 5/8 plywood wall and floor and roof sheeting are required for a two-story house (18 high exterior walls) with a footprint of 50 feet across the north elevation, 30 feet across the...
-
Why are market pay lines important for consideration in pay?
-
DC has unused FTC carryover from 2017 in the separate category for GC income as the result of income generated by a foreign branch. The income was foreign source general category income. In 2018 the...
-
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...
-
Prove that the angular momentum operator \(L_{z}\) generates rotations around the \(z\)-axis.
-
Show that for real numbers \(\alpha, \beta\), and \(\delta\) the matrices form a group under matrix multiplication. Show that the matrices \(G\) with \(\alpha=\beta=0\) form an invariant subgroup of...
-
Show that the quotient group of the 4-group \(\mathrm{D}_{2}\) defined in Problem 2.9 is \(\mathrm{C}_{2}\).
Study smarter with the SolutionInn App