Level 1 Quiz

This figure represents entities in ER Model

• Elipse

• Diamond

• Double Ellipse

• Rectangle

This figure represents Multi - Valued Attributes

• Rectangle

• Ellipse

• Diamond

• Double Ellipse

What figure represents Attributes in ER Model ?

• Ellipse

• Line

• diamond

• Double Rectangle

This figure represents weak entity

• Double Rectangle

• Double Ellipse

• Line

• Diamond

This figure represents attributes to Entities and Entity Sets with other relationship types

• Line

• Double Line

• Rectangle

• Diamond

Subset of the data warehouse that support the

requirements of a particular department or business function

• Operational Systems Databases

• Integration Layer

• Data Mart

• Data Warehouse

Data vault where data are stored in 2nd normal

form

• Data Mart

• Data Warehouse

• Integration Layer

• Operational Systems Databases

Staging area where data are cleaned up and

formatted.

• Integration Layer

• Operational Systems Databases

• Data Warehouse

• Data Mart

Data from different databases

within an organization.

• Data Mart

• Data Warehouse

• Integration Layer

• Operational Systems Databases

Which of the following not part of Common Component of Data Warehouse

• Data Mart

• Operational Systems Databases

• Data Warehouse

• Independent Data Marts