91.6k views
4 votes
Normalized relations are, of course, the result of ________ database design.

A) Physical
B) Logical
C) Conceptual
D) Conventional

User Sibu
by
8.4k points

1 Answer

4 votes

Final answer:

A) Physical Normalized relations originate from the logical phase of database design, which focuses on data organization to reduce redundancy and improve data integrity without the consideration of the physical storage.

Step-by-step explanation:

Normalized relations are the result of logical database design. When a database is designed, different levels of abstraction are considered. Initially, there is the conceptual design, which is a high-level description of what data will be stored without getting into the details of how.

The logical design phase follows, wherein the data model is defined to a greater level of detail but without concerning itself with how the data will be physically stored on disk, that's the physical design stage. Relationships between data are laid out in a manner that reduces redundancy and improves data integrity.

The normalization process is a part of this logical phase, where data is organized in tables and relations according to rules that help in minimizing duplication and preventing data anomalies.

Normalization is the process of structuring a database to remove redundant data and reduce data inconsistencies. It helps to eliminate update, insertion, and deletion anomalies by ensuring that each piece of data is stored in only one place and using relationships between tables to link related data.

User Mastef
by
7.6k points