Bissoy.com
Doctors Medicines MCQs Q&A

 Which of the following statements best describes the main reasons for normalizing relational database? I. To achieve physical data independence.  II. To remove data anomalies (insertion, update, deletion, anomalies).  III.  To save space on Disk. 

 Which of the following statements best describes the main reasons for normalizing relational database? I. To achieve physical data independence.  II. To remove data anomalies (insertion, update, deletion, anomalies).  III.  To save space on Disk.  Correct Answer (II) and (III) only 

Concept:

Normalization is the process by which we can decompose or divide any relation into more than one relation to remove anomalies in a relational database.

Explanation:

Normalization is a step by step process and each step in this is known as normal form. It is a reversible process.

Properties of normalization:

1) Remove different anomalies

2) Decomposition must be lossless

3) To save space on disk

4) Reduce data redundancy

5) Preserve necessary dependency

Various normal forms are 1Nf, 2NF, 3NF, BCNF, 4NF and 5NF.

Related Questions

The UN Secretary-General Antonio Guterres said that India’s initiatives such as ‘Save the Girl Child, Educate the Girl Child’ are emblematic of the types of actions needed to achieve Sustainable Development Goals.  Which of the following is not-in-line with the given statement? I: The UN Secretary-General is criticizing India’s initiatives such as ‘Save the Girl Child, Educate the Girl Child'. II:  India’s initiatives such as ‘Save the Girl Child, Educate the Girl Child’ are the types of actions which are bringing intricacies in achieving Sustainable Development Goals.  III: India's initiatives such as ‘Save the Girl Child, Educate the Girl Child’ are symbolic of the types of actions.  
You are the administrator of Windows 2000 Server computer. Your computer has a span volume that consists of areas on three physical hard disks on the server. The three disks support hot swapping. You regularly backup the span volume by using windows backup. One of the disk fail, you replace the disk with a new un-partitioned disk. You want to recover the span volume and disk data as soon as possible. What should you do?
Let R(a, b, c) and S(d, e, f) be two relations in which d is the foreign key of S that refers to the primary key of R Consider the following four operations in R and S I. Insert into R II. Insert into S III. Deletion from R IV. Deletion from S Which of the following can cause violation of the relational integrity constraint above?
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
Read the given statements and conclusions carefully. Assuming that the information given in the statements is true, even if it appears to be at variance with commonly known facts, decide which of the given conclusions logically follow(s) from the statements. Statements: All Matter is Space. Some Mass is Matter. Conclusions: A. All Mass is Space. B. Some Mass is Space. C. Some Space is Mass. D. All Space is Mass. E. All Matter is Mass.
The disk system consists of which of the following? i. Disk ii. Disk drive iii. Disk controller
In the following question, five statements are given followed by four conclusions I, II, III and IV. You have to consider the given statements to be true even, if they seem to be at variance with commonly known facts. Read all the conclusions and decide which of the following logically follows from the given statements disregarding the commonly known facts. Statements: Some Blue are Color. All Color are Sky. No Rocket is Sky. All Rocket are Space. No Space is Color. Conclusions: I. Some Sky being Space is a possibility. II. Some Blue are Sky. III. Some Color being Rocket is a possibility. IV. Some Blue being Rocket, Space, Sky and Color is a possibility.
You develop an enterprise application, called XYZApplication that includes a Windows Form presentation layer, middle-tier components for business logic and data access, and a Microsoft SQL Server database.
You are in the process of creating a middle-tier component that will execute the data access routines in your application. When data is passed to this component, the component will call several SQL Server stored procedures to perform database updates. All of these procedure calls run under the control of a single transaction.
The code for the middle-tier component will implement the following objects:
SqlConnection cn = new SqlConnection();
SqlTransaction tr;
If two users try to update the same data concurrently, inconsistencies such as phantom reads will occur. You must now add code to your component to specify the highest possible level of protection against such inconsistencies.
Which code segment should you use?
Which is false statement about normalizing? Normalizing is done to
Which is false statement about normalizing?
Normalizing is done to