Question: Step 1 : Tables ( 2 0 p t s . Two additional tables need to be added to the database as follows: ( 1

Step 1: Tables (20pts. Two additional tables need to be added to the database as follows:
(1a) Create a "Job Title" table - Include 4 fields, Job Classification Code (text), Job Title (text), Minimum Salary (currency), and Maximum Salary (currency); be sure to set a primary key. Data records should be entered as follows for job classification code, job title, minimum salary, and maximum salary, respectively:
1A, Level 1 Knowledge Worker, 16500,28000;
2B, Level 2 Knowledge Worker, 20500,37500;
3C, Service Manager, 27000,57000;
4D, Operations Manager, 32000,62000;
5E, VP Service, 57000,84000 ;
6F, VP Operations, 65000,122000;
7G, CFO, 74455,302000;
8H,CIO,95000,525000;
9I, CEO, 110000,695000.
(1b) Import the "State" table - import the State sheet from the Excel project file. Be sure to set "State Code" as the primary key.
 Step 1: Tables (20pts. Two additional tables need to be added

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!