Sponsored Links


Results 1 to 1 of 1

Thread: Cs403 database solved quiz on 4 January 2012-01-04

  1. #1
    Administrator
    Join Date
    Oct 2011
    Posts
    468

    Icon14 Cs403 database solved quiz on 4 January 2012-01-04

    Sponsored Links1


    Cs403 database quiz on 4 January 2012-01-04
    Please download the PDF to get full marks


    A relation is said to be in BCNF when
    it has overlapping composite keys
    In vertical partitioning if we divide a table into two vertical partitions then efficiency of those applications will be reduced which used to.
    Access data from second vertical partition
    Attributes are (i) properties of relationship (ii) attributed to entities (iii) properties of members of an entity set

    General reasoning for horizontal or vertical partitioning is.
    Increasing the consistency
    Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address), where roll no is PK
    it has more than 3 non-key attributes
    BCNF is needed because
    A second Normal Form (2 NF) relation should
    be in 1 NF
    Boye Codd Normal Form (BCNF) is needed when
    there are two or more possible composite overlapping keys and one attribute
    of a composite key is dependent on an attribute of another composite key
    A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency
    i and ii
    The process of normalization
    requires one to understand dependency between attributes
    ramiz
    Atomicity is a feature of ______.
    If A -> B and A -> C, then A -> BC The Inference Rule applies is;

    Augmentation
    A relation is said to be in BCNF when
    it has no overlapping composite keys which have related attributes
    A 3 NF relation is converted to BCNF by
    dependent attributes of overlapping composite keys are put in a separate relation
    Normalization is a process of restructuring a relation to
    minimize duplication of data in a database

    An attribute y may be functionally dependent on (i) a composite attribute x,y (ii) a single attribute x (iii) no attribute
    i and ii
    Consider the following relation vendor_order (vendor no, order no, vendor name, qty supplied , price/unit) where 'vendor no, order no' is PK. The second normal form relations are
    vendor (vendor no, vendor name, qty supplied, price/unit), vendor no is PK
    vendor order (order no, vendor no), order no and vendor no is PK
    Normalization of database is essential to (i) avoid accidental deletion of required data when some data is deleted (ii) eliminate inconsistencies when a data item is modified in the database (iii) allows storage of data in a computer’s disk (iv) use a database management system
    i and ii

    Sponsored Links
    Attached Files Attached Files
    03009520262
    Rabeel Website

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 11-29-2012, 02:54 PM
  2. CS403 - Database Management Systems quiz today 18/01/2011
    By Xpert in forum MCQ's & Quiz Discussion
    Replies: 0
    Last Post: 01-18-2011, 03:17 PM
  3. CS403 Database Management Systems quiz announcement
    By Xpert in forum Virtual University Announcenments
    Replies: 0
    Last Post: 01-12-2011, 03:22 PM
  4. Replies: 0
    Last Post: 12-04-2010, 03:00 PM
  5. Spring 2010 CS403- Database Management Systems Solved
    By desireforheaven in forum Solved Papers
    Replies: 0
    Last Post: 11-09-2010, 08:44 AM

Tags for this Thread

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