Discussion Continues : Topic DBMS : 04/10/2017

Normalization

Normalization: is a method of breaking down complex table structures into simple table structures by using certain rules.
Some rules:

• Each table should have an identifier.
• Each table should store data for a single type of entity.
• Columns that accept NULLS should be avoided.
• The repetation of values or columns should be avoided.

Q1. Select * from employee
What type of statement is this?
a) DML
b) DDL
c) View
d) Integrity constraint

Answer : A
DML

Q2.  If every non-key attribute is functionally depedent primary key, then the relation will be in
a) First normal form
b) Second normal form
c) Third form
d) Fourth normal form

Answer: B
Second normal form

Q....... introduced the relational database rules.
A. Atul kahate
B. James Gossling
C. EF Codd
D. Dennies Rithchie

Answer:C
 EF Codd



Q. In the ____ normal form, a composite attribute is converted to individual attributes.

A. First
B. Second
C. Third
D. Fourth

Answer:A

A relation is in first normal form if and only if the domain of each attribute contains only atomic  (indivisible) values, and the value of each attribute contains only a single value from that domain.