CS614 Data Warehousing GDB No. 01 Solution and Discussion Fall 2014

[Vuhelper]

CS614 Data Warehousing GDB No. 01 Solution and Discussion Fall 2014 Due Date 5th August


The topic will be as follows:

Consider the following table structure:

ProductID (Primary key, Integer, Not NULL)

ProductName (String, Not NULL)

ManufacturingDate (Date, Not NULL)

ExpiryDate (Date, Not NULL)

Category (Integer, Not NULL, Refers to Category column in Category table)

UnitPrice (Float, Not NULL)

Question: Suppose we want to create index (primary) on this table. Identify the indexing technique, you think is best to consider in this case. Justify your answer with valid reasons.


Note: Try to provide precise, to the point answer and avoid irrelevant details.