Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Tools Data Window Help * 100% 27 * Sat 10:37 AM Q E Excel File Edit View Insert Format AutoSave OFF OFF DEU Human Resources

image text in transcribed

Tools Data Window Help * 100% 27 * Sat 10:37 AM Q E Excel File Edit View Insert Format AutoSave OFF OFF DEU Human Resources Record (1) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body v 11 & Insert v - AP A v General Wrap Tort BO Y 4 DX Delete Paste BIU + $ Merge & Center v Conditional Format Cell Formatting as Taule Styles Format v Sort & Filter Find & Select Analyze Dala Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes Na Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates D13 3 H Q R S T LI v V w FirstName Barbara Lee Lee Ps Par Chris Chris C D Last Name PositionDesc Hennessey Manager Noards Director Noordsy Analyst Pemicon Analyst Amidon Clerk Wandall Director Wancaeli Manager Start Date HealthPlar Desc 2011-12-14 Managed HMO 2013-04-23 Manand PPO 2007-11-11 Managed PPO 2012-06-05 Health Saving 2010-07-02 Health Savinex 2012-12-15 Managed PPO 2011 10 04 Managed PPO G PayGrade 40 45 30 30 20 1 1 M N 0 P Using good database design, show the required tables for the Human Resource database For ench table: State the name of the table Include all required fielcs, Indicate any primary key by a single bottom burder Indicate any foreign key by a battam double horder. Makeup any required/missine primary key 45 40 A 1 EmployeeNum 2 2173 3 4519 4519 5 BOOS 6 8005 7 8112 3 8.12 9 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 Sample Data Sheet1 + FI ---+ 100% % W 4 PODE BE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions