Views: 725

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

Assignment #3 CS101 Spring 2018

Started by Eshal Ch.
Last reply
by SYED ANOOSH ABBAS RIZVI yesterday. 4 Replies

CS101 Midrterm papers Spring 2018

Started by + caмe4ѕтυdιeѕ.
Last reply
by Zindgi ghulzar hai Jun 30. 3 Replies

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

Started by mahira khan.
Last reply
by SYED ANOOSH ABBAS RIZVI May 29. 15 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