Question: Step 1 : Tables ( 2 0 p t s . Two additional tables need to be added to the database as follows: ( 1
Step : Tables Two additional tables need to be added to the database as follows:
a Create a "Job Title" table Include 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:
A Level Knowledge Worker, ;
B Level Knowledge Worker, ;
C Service Manager, ;
D Operations Manager, ;
E VP Service, ;
F VP Operations, ;
G CFO, ;
CIO,;
I, CEO,
b Import the "State" table import the State sheet from the Excel project file. Be sure to set "State Code" as the primary key.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
