Skip to main content

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

See the attached file for 502 solution

On Tue, Nov 22, 2011 at 5:04 AM, mc 100404894 Saima Sarwar <mc100404894@vu.edu.pk> wrote:
please share me cs504 assignment plz koi send kar dey na..

On Tue, Nov 22, 2011 at 5:32 PM, Ghulam Mustafa <mc100401687@vu.edu.pk> wrote:
Are you sure this is right solution???????????????????

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.)




--
  Jawad Latif
 jwdlatif@yahoo.com
  MIT (3rd Semester)
CS304, CS502, CS506, CS614, CS615, CS619, MGT 602

--
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

Comments

Post a Comment