Maintain a Database Security (Inference Detection Algorithm) Consider a database containing personnel information, including names, addresses, and salaries of employees. Individually, the name, addres

Maintain a Database Security (Inference Detection Algorithm)

Consider a database containing personnel information, including names, addresses, and salaries of employees. Individually, the name, address, and salary information is available to a subordinate role, such as Clerk, but the association of names and salaries is restricted to a superior role, such as Administrator.

With this information, how could you construct your database and tables? Design your database and draw a database schema first.

Suppose that administrators wants to add a new attribute, employee start date, which is not sensitive. Where would it be? Consider not comprimising the relationship between employee and salary. Draw your new schema.