Question

In a STAR schema to track the shipments for a distribution company, the following dimension tables are found: (1) time, (2) customer ship-to, (3) ship-from, (4) product, (5) type of deal, and (6) mode of shipment. Review these dimensions and list the possible attributes for each of the dimension tables. Also, designate a primary key for each table. Assume you are in the insurance business. Find two examples of Type 2 slowly changing dimensions in that business. As an analyst on the project, write the specifications for applying the Type 2 changes to the data warehouse with regard to the two examples.

Answer 1

Answer:

Steps in designing Star Schema:

Identify a business process for analysis(like sales).

Identify measures or facts (sales dollar).

Identify dimensions for facts(product dimension, location dimension, time dimension, organization dimension).

List the columns that describe each dimension.

Answer 2

Explanation:

Answer:

Resources are classified as exhaustible resources and Inexhaustible resources. They are the resources that take many years to be renewed and are called non renewable resources. They are usually found underground. They are the resources that can be renewed and are called renewable resources.

Explanation:

$\huge{\fcolorbox{pink}{Yesssssssss}{YES}}$