ADVANCE DATABASE NORMALIZATION

Question 1

A database design technique that organizes tables in a manner that reduces redundancy and dependency of data

Answer 1

Normalization

Question 2

divides larger tables into smaller tables and links them using relationships

Answer 2

Normalization

Question 3

This rule is all about disallowing multivalued attributes

Answer 3

Eliminate Repeating Data

Question 4

refers to situations where the primary key for a table is a composite primary key, which means ‘a key composed of multiple columns’

Answer 4

Eliminate Partial Dependencies

Question 5

a column in the table refers to a non-key column instead of referring to the primary key of a table

Answer 5

Eliminate Transitive Dependencies

Question 6

Problems that can occur in poorly planned, unnormalized databases where all the data is stored in one table (a flat- file database)

Answer 6

Anomaly

Question 7

must include only atomic values and that the value of any attribute in a row must be a single value from the domain of that attribute

Answer 7

First Normal Forms (1NF)

Question 8

• Each attribute name must be unique
• Each attribute value must be single
• Each row must be unique

Answer 8

Rules of 1NF

Question 9

What is ACID?

Answer 9

ACID (atomicity, consistency, isolation, and durability)

Question 10

a relation is in 2NF, if it satisfies the following conditions:

Answer 10

E.F. Codd

Question 11

• The table should be in the First Normal Form
• There should be no Partial Dependency

Answer 11

Second Normal Form (2NF)

Question 12

The attributes which are used to form a candidate key are called l

Answer 12

Prime Attributes

Question 13

The attributes which do not form a candidate key are called

Answer 13

Non-Prime Attributes

Question 14

A concept that specifies the relationship between two sets of attributes where one attribute determines the value of another attribute

Answer 14

Functional Dependency

Question 15

• A specific type of dependency that happens in tables with a composite primary key (a primary key made up of two or more columns).
• a non-prime attribute can be determined by the part of the candidate key in a relation, it is known as a partial dependency

Answer 15

Partial Dependency

Question 16

• It should be in the Second Normal Form
• It should not have Transitive Dependency
• All transitive dependencies are removed to place in another table

Answer 16

Third Normal Form (3NF)

Question 17

A functional dependency is said to be transitive if it is indirectly formed by two functional dependencies.

Answer 17

Transitive Dependency