Sign In Sign Up Ask an AI advisor
Abbymay17
Abbymay17
15.04.2021 • 
Computers and Technology

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.
1. With this information, how could you construct your database and tables? Design your database and draw a database schema first.
2. 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.

Solved
Show answers

Ask an AI advisor a question

I want advice