question archive Consider a database containing personnel information, including names, addresses, and salaries of employees
Consider a database containing personnel information, including names, addresses, and salaries of employees
Subject:Computer SciencePrice: Bought3
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.
