Re: ::: vuaskari.com ::: cs502 cs614 assigment

question no 1 nahi mila or ager app ko cs615 ki mily to plz mujy b send ker dana

On Tue, Nov 22, 2011 at 5:28 AM, Anila Rasheed <mc100404710@vu.edu.pk> wrote:

yar please snd me cs502 and cs614 asg solution .. aj extended day hay... :(

On Mon, Nov 21, 2011 at 9:50 PM, Rubab Rana <mc100403939@vu.edu.pk> wrote:

 Write SQL code to create the following tables.

 Solution:

CREATE TABLE PERM.JOIN7 AS

SELECT FACT_TBL*,

PAT_TBL.PAT_NAME, PAT_TBL.PAT_SEX,

DATE_TBL.MONTHYR, DATE_TBL.DATETEXT,

DATE_TBL.QUARTRYR, DATE_TBL.YEAR,

LOC_TBL.LOCNAME, LOC_TBL.OWNER,

PROV_TBL.NAME, PROV_TBL.TYPE,

DIAG_TBL.DESCRIPT, DIAG_TBL.SUBGROUP, DIAG_TBL.GROUP,

PROC_TBL.DESCRIPT, PROC_TBL.SUBGROUP, PROC_TBL.GROUP,

SERV_TBL.NAME, SERV_TBL.AFFLIAT,

FROM

PERM.FACT_TBL, PERM.PAT_TBL,

PERM.DATE_TBL, PERM.LOC_TBL,

PERM.PROV_TBL, PERM.DIAG_TBL,

PERM.PROV_TBL, PERM.SERV_TBL,

WHERE

FACT_TBL.PATIENT=PAT_TBL.PATIENT AND

FACT_TBL.DATESERV =DATE_TBL.DATESERV AND

FACT_TBL.LOCATION =LOC_TBL.LOCATION AND

FACT_TBL.ADJUSTMENT=PROV_TBL.ADJUSTMENT AND

FACT_TBL.DIAGNOS1.DIAGNOS2 =DIAG_TBL.DIAGNOS1.DIAGNOS2 AND

FACT_TBL.PROCEDURE AND

FACT_TBL.SERVEMD = SERV_TBL.AFFLIATE AND; RUN;

PROC SUMMARY DATA = Perm.JOIN7;

Class Patient Quartryr Location;

VAR Charges Adjust;

OUTPUT OUT=Perm.Sum7;

RUN;

(here is solution for part1, but not  sure it is correct or not, becoz its just my own idea.)

--
We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish you all the best. Join www.vuaskari.com,
To post to this group, send email to vuaskari_com@googlegroups.com
Visit these groups:
This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
Management: https://groups.google.com/group/vuaskari_mgt?hl=en
Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
MIS Group: http://groups.google.com/group/askari_mis?hl=en

--
MIT 3rd semester
subjects
CS502 - Fundamentals of Algorithms
CS506 - Web Design and Development
CS614 - Data Warehousing
CS615 - Software Project Management
CS619 - Final Project - CS619{{ statistical analyzer for data manipulation}}
MGT602 - Entrepreneurship

--
We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish you all the best. Join www.vuaskari.com,
To post to this group, send email to vuaskari_com@googlegroups.com
Visit these groups:
This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
Management: https://groups.google.com/group/vuaskari_mgt?hl=en
Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
MIS Group: http://groups.google.com/group/askari_mis?hl=en

--
consistancy is the key to success

--
We say, "Be one as Pakistani Nation and grow up for Pakistan's Future". Wish you all the best. Join www.vuaskari.com,
To post to this group, send email to vuaskari_com@googlegroups.com
Visit these groups:
This (Main) Group:http://groups.google.com/group/vuaskari_com?hl=en?hl=en
MIT/MCS Group: http://groups.google.com/group/vu_askarimit?hl=en?hl=en
HRM Group: http://groups.google.com/group/askari_hrm?hl=en?hl=en
Banking Group: http://groups.google.com/group/askari_banking?hl=en?hl=en
Management: https://groups.google.com/group/vuaskari_mgt?hl=en
Marketing: https://groups.google.com/group/vuaskari_mkt?hl=en
MIS Group: http://groups.google.com/group/askari_mis?hl=en