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.

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.

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Big Data

Section: Chapter Questions

Problem 2SAT

See similar textbooks

Similar questions

Suppose that a stock exchange (market) uses a relational database to store data on stocks and the brokers who own them. Assume that numerous sales of stocks may take place concurrently between different pairs of brokers. (a) Describe the properties that transactions must have. (b) Discuss the extent to which a database management system alone can ensure that the stock market’s database remains in a consistent state. Illustrate your answer using the sale of some stock. (c) What are the benefits to the stock market of using a database management system to support concurrent transactions?
"2.1,2.2,2.3, and 2.4 are answered" Introduction The given problem is related to the normalization process of a database table where the requirement is to identify the normal forms of the given sample table and decompose the table. The normalization is a process to break the table into smaller tables to that: a) There is no redundancy b) Table is free from insertion, update and delete anomaly. c) Data in the tables can be handled easily **As per Bartleby guidelines, as the required number of sub-parts to be answered is not mentioned and it is needed to solve first 3 sub-parts. Kindly find the solution to half assignment(first 4 sub-parts). 2.1 Normal form of given table The given table is in unnormalized form i.e. it is not even in the first normal form of the database normalization. Explanation: a) For a single Invoice number, there are many products added to the table. b) There is no direct primary key that can be used to store the data uniquely. c) The given table…
Suppose that you have been asked to create an information system for a manufac-turing plant that produces nuts and bolts of many shapes, sizes, and functions. What questions would you ask, and how would the answers affect the database design? a. What do you envision the SDLC to be? b. What do you envision the DBLC to be?
Question 23. The database interface of a library allows searching only for a single attribute (such as Titleor Author ) in each query. Your friend decided to extend it’s functionality and wrote an algorithm that allowssearching for books that satisfy multiple predicates over single attributes in conjunction. He tells you the algorithmreuses the already implemented query functionality and works by intersecting the results ( book id’s ) of queriesover single attributes.Which of the following assumptions on your friend’s algorithm are plausible?a) Its worst-case run-time necessarily increases exponentially with respect to the number of attributes in thequery.b) Its worst-case run-time depends on the length of the longest result of the single-attribute queries.c) It might be implemented using an join.d) It might be implemented using sorting.
Computer Science Q.2. Suppose an employee of a bank transfers Rs 800 from X's account to Y's account. This small transaction contains several low-level tasks: Hint: use read and write operation pseudo code/Procedure Q.4: Explain the acid properties in the database with the help of a suitable diagram? Explain in detail and show all steps neat n clean
Create a relational database design for the following data model
Unlike a database, which stores data, an information system makes use of it. Is there any impact on database design as a result of this relationship?
The benefits of a hierarchical database over a relational database are many. Positive or negative, discuss the following remark.
The difference between a database and an information system is that a database records information while an information system utilizes it. Is there any effect on database design with this relationship?