You have created a database for employee management. The database has a table named Employees. The table has the following attributes:

Name

Address

Contact Number

Designation

You want to store the salary information for each employee. The database should also store salary history. How will you design the database so that you can query the last increment given to a particular employee?

Question

You have created a database for employee management. The database has a table named Employees. The table has the following attributes:

Name
Address
Contact Number
Designation

You want to store the salary information for each employee. The database should also store salary history. How will you design the database so that you can query the last increment given to a particular employee?

Accepted Answer

B. Create a new table that includes the EmployeeID, EmployeeSalary, and DateOfIncrement

Answer

A. Create a new table that includes the EmployeeSalary and DateOfIncrement columns.

Answer

C. Add the EmployeeSalary and DateOfIncrement columns to the Employees table.

Answer

D. Create a new table that includes the EmployeeSalary and DateOfIncrement columns.

You have created a database for employee management. The database has a table named Employees. The table has the following attributes: - Name - Address - Contact Number - Designation You want to…

Question

Options

How the community answered

Community Discussion