If a relation has a single-column primary key, what can be said about its 2NF status?

It is automatically in 2NF if it's in 1NF

Which of the following is NOT a requirement for a relation to be in 1NF?

The table should have at least one foreign key

What is an Enhanced Entity-Relationship (EER) model?

A detailed model that includes semantic concepts like specialization

Transitive dependency occurs when:

A non-key attribute depends on another non-key attribute

Which of the following is the FIRST normal form (1NF) concerned with?

Ensuring that no multi-valued attributes exist

Partial dependency exists when:

An attribute is dependent on only a part of a composite primary key

What is the primary goal of normalization?

To minimize data redundancy and avoid update anomalies

Which of the following is TRUE about generalization in EER?

Creating a more general entity by merging several lower-level entities

What is a superclass in the context of EER?

A higher-level entity from which subclasses inherit attributes

studbud

Database Normalization

18 termsStudBud Administration68 plays

Test your knowledge and learn about the importance of database normalization

Flashcards18 cardsFPractice quizPHost liveL

Questions 18

Answers

1
If a relation has a single-column primary key, what can be said about its 2NF status?
It cannot be in 2NF
It requires additional normalization to reach 2NF
It needs to be in 3NF first
It is automatically in 2NF if it's in 1NF
2
Normalization typically increases performance.
True
False
3
In EER, a specialization is The process of merging different entities into one
True
False
4
Normalization is mandatory for all databases.
False
True
5
Which of the following is NOT a requirement for a relation to be in 1NF?
All entries in a column must be of the same data type
There should be no repeating groups
Each column should contain atomic values
The table should have at least one foreign key
6
Normalization reduces update anomalies.
False
True
7
What is an Enhanced Entity-Relationship (EER) model?
A model that focuses on foreign key relationships between entities
A simplified version of the ER model used for small databases
A model that only includes basic entities and relationships
A detailed model that includes semantic concepts like specialization
8
In EER, disjointness constraint ensures that an entity cannot be a member of more than one subclass at the same time
True
False
9
Which form deals with transitive dependency?
1NF
2NF
3NF
BCNF
10
A relation should contain only single-column primary keys is NOT a requirement for a relation to be in 3NF
False
True
11
Transitive dependency occurs when:
A non-key attribute is dependent on a part of the primary key
A non-key attribute depends on another non-key attribute
All attributes depend on the whole primary key
A primary key depends on a non-key attribute
12
Which of the following is the FIRST normal form (1NF) concerned with?
Removing partial dependencies
Reducing functional dependencies
Removing transitive dependencies
Ensuring that no multi-valued attributes exist
13
Partial dependency exists when:
An attribute is dependent on only a part of a composite primary key
An attribute depends on the whole primary key
There is no relationship between the primary key and the non-key attributes
An attribute depends on another non-key attribute
14
What is the primary goal of normalization?
To minimize data redundancy and avoid update anomalies
To increase the size of the database
To reduce the complexity of the database
To ensure the database works with different programming languages
15
Which of the following is TRUE about generalization in EER?
It refers to defining multiple subclasses from a single parent class
Creating a more general entity by merging several lower-level entities
It reduces the number of relationships in the model
It is used to decompose a relation into multiple relations
16
How does 2NF improve database design?
Simplifies relations
Increases data
Adds redundancy
Removes partial dep.
17
Normalization ensures data integrity.
True
False
18
What is a superclass in the context of EER?
A weak entity set that cannot exist without a strong entity
A relationship between entities of the same type
A subset of the entity set that shares some distinct characteristics
A higher-level entity from which subclasses inherit attributes

Database Normalization Flashcards | StudBud