Sponsored Links


Results 1 to 2 of 2

Thread: CS614 Data Warehousing Assignment No 01 spring 2011

  1. #1
    Administrator Vuhelper's Avatar
    Join Date
    Apr 2011
    Posts
    9,578

    NEW CS614 Data Warehousing Assignment No 01 spring 2011

    Sponsored Links1


    Assignment No. 01
    SEMESTER SPRING 2011
    CS614- Data Warehousing
    Total Marks: 20

    Due Date: 20/04/2011
    Instructions
    Please read the following instructions carefully before submitting assignment:
    It should be clear that your assignment will not get any credit if:
    o The assignment is submitted after due date.
    o The submitted assignment does not open or file corrupt.
    o The assignment is copied.
    o There is not mentioned the student Id in the assignment File or
    name of file is other than student ID.

    GOOD LUCK

    Marks: 20

    Question 1: [10 marks]
    You are given the following data.

    Sponsored Links

    Patient No, Patient First Name, Patient Last Name, Patient Address, Sex, Tel No, DOB, Marital Status, Date Reg., Next of Kin Name, Relationship, Next of Kin Address, Next of Kin Tel No, Local's Doctor's Name, Clinic No, Doctor's Address, Doctor's Tel No.

    1. Normalize the given data in to 1st then 2nd and 3rd normal form. Give justification of conversion in to 1st then 2nd and 3rd normal form and the anomalies because of which you transformed it in to another normal form.

    Question 2: [10 marks]

    It is believed that Classical SDLC is not suitable for Data warehouse environment. In your point of view why it is not suitable. Secondly what changes you suggest to be made in Classical SDLC to make it suitable for data warehouse. Give reasons to support your ideas?



    Note: Try to write answer to the point and in your own words.


    Uploading Instructions:

    Upload your assignment as a word file. It should have name [YourRollNo.doc]

    Deadline
    Your assignment must be uploaded/submitted at or before Wednesday April 20, 2011.
    Attached Files Attached Files

  2. #2
    Junior Member
    Join Date
    Apr 2011
    Posts
    1
    Student Id: Mc090406871
    1N Form:
     Hospital Table
     Patient No
     Patient First Name
     Patient Last Name
     Patient Address
     Sex
     Tel No
     DOB
     Marital Statu
     Patient Address
     Sex
     Tel No
     DOB
     Marital Status
     Date Reg
     Next of Kin Name
     Relationship
     Next of Kin Address
     Next of Kin Tel No
     Local's Doctor's Name
     Clinic No
     Doctor's Address
     Doctor's Tel No





    2N Form:
    We decompose the OPD table into three tables that is Patient, Kin, Doctor as below:
    To transform the table OPD into 2NF we move the columns Patient No, Patient First Name, Patient Last Name, Patient Address, Sex, Tel No, DOB, Marital Status, Date Reg to a
    new table called Patient. The column Patient No becomes the primary key of this
    new table.
    To transform the table OPD into 2NF we move the columns Next of Kin Name, Relationship, Next of Kin Address, Next of Kin Tel No to a new table called Kin. The column Patient No becomes the primary key of this new table.
    To transform the table OPD into 2NF we move the columns Local's Doctor's Name, Clinic No, Doctor's Address, Doctor's Tel No to a new table called Doctor. The column Patient No becomes the primary key of this new table.

    Patient Table
     Patient No
     Patient First Name
     Patient Last Name
     Patient Address
     Sex
     Tel No
     DOB
     Marital Status
     Date Reg
     Kin Table
     Patient No
     Next of Kin Name
     Relationship
     Next of Kin Address
     Next of Kin Tel No

    Doctor Table

     Patient No
     Local's Doctor's Name
     Clinic No
     Doctor's Address
     Doctor's Tel No


    3N Form:
    The above tables are in 3NF, because there is no transitive dependency. For a relational table to be in third normal form (3NF) all columns must be dependent only upon the primary key. More formally, a relational table is in 3NF if it is already in 2NF and every non-key column is non transitively dependent upon its primary key

    Q No2:
    The classical system development life cycle (SDLC) does not work in the world of the DSS analyst. The SDLC assumes that requirements are known at the start of the design (or at least can be discovered). However, in the world of the DSS analyst, requirements are usually the last thing to be discovered in the DSS development life cycle


    Shani khan
    sirf.13mera7@yahoo.com
    03342599630
    MCS(Islmia Universty Bahwal Pur)
    MBA(Virtual Universty )

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. CS614 Data warehousing Assignment # 1 Spring 2014
    By Zombee in forum Assignments & Solutions
    Replies: 0
    Last Post: 05-01-2014, 11:30 PM
  2. Replies: 0
    Last Post: 06-14-2012, 09:42 PM
  3. Replies: 0
    Last Post: 04-10-2012, 05:45 PM
  4. Replies: 1
    Last Post: 07-01-2011, 05:03 AM
  5. Replies: 0
    Last Post: 04-25-2011, 08:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
-: Vuhelp Disclaimer :-
None of the files shown here are hosted or transmitted by this server. The links are provided solely by this site's users. The administrator's or staff of Vuhelp.net cannot be held responsible for what its users post, or any other actions of its users. You may not use this site to distribute or download any material when you do not have the legal rights to do so. It is your own responsibility to adhere to these terms. If you have any doubts about legality of content or you have any suspicions, feel free to contact us.
Online Education | JhelumSoft | Jobs