VU Projects Video Lectures Handouts Past Papers Quizzes Assignments & GDB border= Members Free SMS Service FB Page
VU Projects Video Lectures Handouts Past Papers Quizzes Assignment,GDB Members SMS Service FB Page

Views: 691

Replies to This Discussion

idea solution

Attachments:

Relation can be called as a Table, but not vice versa.Because, a Relation is an un-ordered set of values and cannot have duplicates. But in a Table one can have duplicates and other anomalies.

CS101 GDB Solution 

Attachments:

thank you group members for helping :)

Technically a relation does not have any explicit ordering and cannot have duplicates.  While a table is a representation of a relation, it is an imperfect one unless there is a unique key constraint (otherwise it has duplicates).

 

a relation is may be a table but we can'ot say that table is a relation always.

Because, a Relation is an un-ordered set of values and cannot have duplicates. But in a Table one can have duplicates and other anomalies.


RelationalDatabase is a database constituting a set of relations (usually erroneously referred to as "tables"[1]). A relation is a set of tuples (a.k.a. "records"), a tuple being a set of attribute values, each attribute being identified by its name (and not by any ordinal position)

  • A relational database is a collection of time-varying, normalized relations of assorted degrees.

  • The following intiutitve correspondence can be made:

    1. A relation is a file
    2. Each file contains only one record type
    3. The records have no particular order 
    4. Every field is single-valued
    5. The records have a unique identifying field or composite field, called the primary key field.

RSS

© 2018   Created by Muhammad Anwar Tahseen.   Powered by

Badges  |  Report an Issue  |  Terms of Service

-->