ADVANCE DATABASE NORMALIZATION

Question 1

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

Answer 1

NORMALIZATION

Question 2

• The purpose of Normalization is to eliminate ____
  ___ and ensure data is stored logically.

Answer 2

redundant (useless) data

Question 2

The inventor of the relational model ____ proposed the
theory of normalization

Answer 2

Edgar Frank Codd

Question 2

is the process of organizing data to
minimize redundancy in the design
of a relational database
management system (RDBMS)

Answer 2

Database
Normalization or Normalization

Question 2

This rule is all about disallowing multivalued attributes

Answer 2

Eliminate repeating
data

Question 2

Goals of Normalization

Answer 2

• ELIMINATE REDUNDANT
  DATA
• ELIMINATE INSERT, DELETE,
  AND UPDATE ANOMALIES

Question 2

Three main rules for normalizing data

Answer 2

Eliminate repeating
data
Eliminate partial
dependencies
Eliminate transitive
dependencies

Question 3

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

Answer 3

Eliminate partial
dependencies

Question 4

This refers to situations where in a column in the table refers to a non-key
column instead of referring to the primary key of a table.

Answer 4

Eliminate transitive
dependencies

Question 5

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

Answer 5

Anomaly

Question 6

Types of Anomalies:

Answer 6

Insert Delete Update

Question 7

Suppose a new faculty joins the University, and the Database Administrator inserts the faculty data into the above table. But he is not able to insert because Sid is a primary key, and can’t be NULL. So this type
of anomaly is known as an

Answer 7

insertion anomaly

Question 8

When the Database Administrator wants to delete the
student details of Sid=2 from the above table, then it will
delete the faculty and course information too which
cannot be recovered further.

Answer 8

Delete Anomaly

Question 9

DETELE ANOMALY in SQL:

Answer 9

DELETE FROM ___ WHERE __:

Question 10

When the Database Administrator wants to change
the salary of faculty F1 from 30000 to 40000 in above
table University, then the database will update salary
in more than one row due to data redundancy

Answer 10

Update Anomaly

Question 11

Update Anomaly in SQL

Answer 11

UPDATE __WHERE ____;

Question 12

evolution of
Normalization
theories

Answer 12

1st Normal Form
2nd Normal Form
3rd Normal Form
Boyce Codd NF
4th Normal Form
5th Normal Form
6th Normal Form

Question 13

states that the domain of an attribute 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 13

First Normal Forms

Question 14

pertains to the built-in atomic data types

Answer 14

Atomic Values

Question 15

ACID stands for

Answer 15

(atomicity, consistency, isolation, and durability)

Question 16

Rules of 1NF

Answer 16

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

Question 17

is unique, not null, and unchanged; can be either an attribute or combined attributes

Answer 17

primary key

Question 18

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

Answer 18

Second Normal Form (2NF)

Question 19

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

Answer 19

Prime attributes

Question 20

The attributes
which do not form a candidate key
are called

Answer 20

Non-Prime attributes

Question 21

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

Answer 21

Functional
Dependency

Question 22

is a specific type of
dependency that happens in tables with
a composite primary key

Answer 22

Partial dependency

Question 23

If a non-prime attribute can be
determined by the part of the candidate
key in a relation, it is known as a

Answer 23

partial
dependency.

Question 23

a primary key
made up of two or more columns

Answer 23

composite primary key

Question 24

• 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 24

Third Normal Form (3NF)

Question 25

a functional dependency is said to be transitive if it is directly formed by two functional dependencies (True or False)

Answer 25

FALSE - INDIRECTLY

Question 26

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

Answer 26

functional dependency