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 real-world 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 (1NF) states that:
a) Every attribute must be atomic
b) A table must have a composite primary key
c) All non-key attributes must be fully dependent on the primary key
d) There are no repeating groups
Second Normal Form (2NF) is achieved when:
a) A table is in 1NF 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 non-key attribute
d) A foreign key
The process of identifying entities and relationships in a real-world 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!