DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Data warehouse architecture
|
|
|
Logical design
|
|
|
Physical design
|
|
|
Conceptual design
|
Detailed explanation-1: -The first step shown is requirements collection and analysis. During this step, the database designers interview prospective database users to understand and document their data requirements.
Detailed explanation-2: -High-level conceptual data models provide concepts for presenting data in ways that are close to the way people perceive data. A typical example is the entity relationship model, which uses main concepts like entities, attributes and relationships.
Detailed explanation-3: -High-level design (HLD) explains the architecture that would be used to develop a system. The architecture diagram provides an overview of an entire system, identifying the main components that would be developed for the product and their interfaces.
Detailed explanation-4: -Conceptual design is an early phase of the design process, in which the broad outlines of function and form of something are articulated. It includes the design of interactions, experiences, processes, and strategies.