Sponsored Links


Results 1 to 6 of 6

Thread: CS403 Assignment No 4 Deadline 29 June 2010

  1. #1
    Senior Member Guru's Avatar
    Join Date
    May 2010
    Location
    Jhelum
    Posts
    117

    99 CS403 Assignment No 4 Deadline 29 June 2010

    Sponsored Links


    CS403 Database Management Systems Assignment No 4
    Spring 2010
    Total Marks: 20
    Due Date: 29/06/2010


    [Q1. In which normal form the following STUDENT relation is if only A,B can act as the key. Marks 10

    STUDENT(A, B, C, D, E, F, G, H) Where A, B, C and so on are the attributes of the relation STUDENT.
    A, B -> C, D, E
    C -> F
    D -> G
    E -> H
    Note: Also mention why the relation is in that normal form.

    Q2. Examine the table shown below which is already in Second Normal Form (2NF). Marks 10

    Sponsored Links




    You are required to normalize this relation into Third Normal Form (3NF).


    Upload Instructions:
    Please view the document related to assignment submission process provided to you by the Virtual University to upload the assignment.

  2. #2
    Junior Member
    Join Date
    Jun 2010
    Posts
    21
    sol b mily ga kia?

  3. #3
    Administrator Xpert's Avatar
    Join Date
    May 2010
    Location
    Jhelum
    Posts
    6,251
    zaroor milay ga bhai just wait na. bana rahay han.

  4. #4
    Junior Member
    Join Date
    Jun 2010
    Posts
    21
    Allah bhla kry g ap ka

  5. #5
    Administrator Xpert's Avatar
    Join Date
    May 2010
    Location
    Jhelum
    Posts
    6,251
    Ameen aur app ka bhi. what is ur name and where u from? introduce tu karwa den.

  6. #6
    Senior Member viki's Avatar
    Join Date
    May 2010
    Posts
    2,132

    Just an Idea (Check it )

    [Q1. In which normal form the following STUDENT relation is if only A,B can act as the key. Marks 10

    Answer:
    No normal form exist here because here is functional dependency and starting form first normal form we have to remove the functional dependency. That’s why relation is in no normal form.




    Q2. Examine the table shown below which is already in Second Normal Form (2NF). Marks 10




    Answer:
    3rd normal form:

    Address ---------------------------------------------- Tel_No
    New Garden Town, Lahore---------------------------042-4466375,042-4586975,042-4554668
    Blue Area, Islamabad---------------------------------- 051-5546584,051-4687458



    Address is taken as forigen key in 3rd normal form.
    :o:o--------------------------------------------------------------------------------------:o:o
    [B]The more knowledge you have, the greater will be your fear of Allah.[/B]

    Please Join My [B]Group Vuhelp[/B][B], Birthday Wishing, Daily Hadees[/B] [CODE][B]http://vuhelp.net/groups/vuhelp.html[/B]
    [B]http://vuhelp.net/groups/birthday-wishing.html[/B]
    [B]http://vuhelp.net/groups/daily-hadees.html[/B][/CODE]
    [CENTER][B][COLOR="Red"][SIZE="4"]Email: [email]viki@vuhelp.net[/email][/SIZE][/COLOR][/B][/CENTER]

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-30-2010, 06:07 PM
  2. IT430 E-Commerce Assignment 4 Deadline 30 June 2010
    By viki in forum Assignments & Solutions
    Replies: 4
    Last Post: 07-16-2010, 03:31 AM
  3. CS410 Assignment 4 Deadline 30 June 2010
    By viki in forum Assignments & Solutions
    Replies: 0
    Last Post: 06-30-2010, 06:20 AM
  4. Replies: 8
    Last Post: 06-24-2010, 11:44 AM
  5. Replies: 1
    Last Post: 06-22-2010, 10:20 AM

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