Question: Please only answer which is correct a b c d ( no explanation ) This method of decomposition focuses on _ _ _ while preserving
Please only answer which is correct a b c d no explanation
This method of decomposition focuses on while preserving dependencies.
a Lossless Decomposition
b Loss Decomposition
c Less Decomposition
d Lossfull Decomposition
Which of the following is not part of ERD?
a Entities
b Attributes
c Relationships
d Processes
An entity in an ER diagram represents
a An attribute
b A relationship
c A realworld object or concept
d A data type
Cardinality in an ER diagram defines
a The number of attributes in an entity
b The maximum number of occurrences of one entity related to another
c The data type of an attribute
d The primary key of an entity
Normalization is the process of:
a Adding redundancy to a database
b Removing redundancy and improving data integrity
c Increasing data access time
d Creating indexes on tables
First Normal Form NF states that:
a Every attribute must be atomic
b A table must have a composite primary key
c All nonkey attributes must be fully dependent on the primary key
d There are no repeating groups
Second Normal Form NF is achieved when:
a A table is in NF and has no partial dependencies
b A table has a single attribute primary key
c All attributes are dependent on the primary key
d There are no repeating groups
A functional dependency:
a Shows the relationship between entities
b Shows the relationship between attributes
c Defines the cardinality of a relationship
d Determines the primary key
A composite key is
a A single attribute that uniquely identifies a row
b A combination of multiple attributes that uniquely identifies a row
c A nonkey attribute
d A foreign key
The process of identifying entities and relationships in a realworld environment is known as:
a Database design
b Data modeling
c Normalization
d Data mining
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
