Views: 711

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

Discussion Forum

CS101 assignment 2........Spring 2018

Started by mahira khan.
Last reply
by IqraZaib 2 hours ago. 2 Replies

Cs101 assignment solution

Started by Iqra Mubasher.
Last reply
by Muhammad Abdullah on Monday. 12 Replies

cs101 assingment solution 2018

Started by Muhammad Hasan.
Last reply
by + caмe4ѕтυdιeѕ May 9. 1 Reply

CS101 Assignment # 1 Due Date: 9th May, 2018

Started by + caмe4ѕтυdιeѕ.
Last reply
by + caмe4ѕтυdιeѕ May 8. 12 Replies

SPONSORED LINKS

© 2018   Created by Muhammad Anwar Tahseen.   Powered by

Badges  |  Report an Issue  |  Terms of Service