Assignment No. 02 CS614- Data Warehousing solution

                                              Assignment No. 02  CS614
                                                Data Warehousing  solution
                                                          Fall 2011

Question 1:   [10 marks]

Suppose you are given the following schema [1].

Part 1. Write SQL code to create the following tables.
sol:
  in order to write the code use the SQL commands .

Part2. Write SQL code for the query to select only female patients.

sol:

write the sql commands to select the female patient .

Question 2:   [10 marks]

Write the summary of the given research paper [1].

References:

[1]. A Data Warehouse Implementation Using the Star Schema