Question

What justification can you give for normalizing a database if the database will be updated only by the people who can be trusted not to introduce inconsistencies in the data?
a. lack of redundancy may save the space and may improve update time.

b. ability to store dangling tuples.

c. both a. and b.

d. neither a. nor b.

Answer 1

Answer: C) Both a and b

Explanation:

 The main benefit of normalizing the database as it reduced the redundant data and due the lack of the redundant data, it saves lots of space in the database.

It also improve the update time in the database so it is easy to handle the database security in the system.

It is also has ability to store the dangling tuples so it can easily store all the information of the customer without introduce any inconsistencies in the database system.

Therefore, Option (C) is correct.