DBMS Indexing
Budget: $10 – $30 USD
implement the index file structure:
Header of master file:
Emp ID First Name Last Name Gender Date of Birth Weight in Kgs. Salary SSN City State
EmpID : Employee ID (No Duplicate)
First Name: (No Duplicate)
Last Name:
Gender: M/F
Date of Birth: MM/DD/YY
Weight in Kilograms:
Salary:
SSN (Social Security Number): 999-99-9999 (No Duplicate)
City:
State:
Header of master file:
Emp ID First Name Last Name Gender Date of Birth Weight in Kgs. Salary SSN City State
EmpID : Employee ID (No Duplicate)
First Name: (No Duplicate)
Last Name:
Gender: M/F
Date of Birth: MM/DD/YY
Weight in Kilograms:
Salary:
SSN (Social Security Number): 999-99-9999 (No Duplicate)
City:
State: