What is the correct answer?


The one guideline to be followed while designing the database is

A. A database design may be ambiguous.

B. It should avoid/reduce the redundancy.

C. Unrelated data should be in the same table so that updating the data will be easy.

D. An entity should not have attributes.

Correct Answer :

B. It should avoid/reduce the redundancy.

Related Questions

The normalization was first proposed by . The statement that is executed automatically by the system as a side effect… The cost of reading and writing temporary files while evaluating a query… ____ table store information about database or about the system. Manager salary details are hidden from the employee .This is Union operator is a : DBMS helps achieve Which of the following is not a consequence of concurrent operations? Which of the following relational algebraic operations is not from set… DROP is a statement in SQL. SQL server stores index information in the _____system table As per equivalence rules for query transformation, selection operation… Which of the following constitutes a basic set of operations for manipulating… Processed data is called _____ The ______ indexes are forced to store only record IDs in the data structure… For using a specific database …………… command… Tree structures are used to store data in An outstanding functionality of SQL is its support for automatic_____… In an E-R, Y is the dominant entity and X is a subordinate entity. Then… If the closure of an attribute set is the entire relation then the attribute… The relational model is based on the concept that data is organized and… _____ is a utility to capture a continuous record of server activity and… _____ database is used to provide statistical information or summaries… Which one is true statement : ______is a special type of integrity constraint that relates two relations… Between DRAM and magnetic disk storage another form of memory, called… The metadata is created by the The fact that information in the data warehouse changes far less often… In multiple granularity of locks SIX lock is compatible with Data independence means