1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Rep Power

    Unable to understand the formatting of repeating fields in file of record of Database

    I am reading book named "Fundamentals of Database Systems by R.Elmasri and S.B.Navathe" on the page number 597 second paragraph " A file of records ....". I am unable to understand What they are trying to say by <field-name,field-value> or <field-type,field-value> I mean for what purpose.If you can explain it with the example then it will be more beneficiary for me. What they want to say by total number of fields for the record type is larger but the number of fields that actually appear in a typical record is small, we can include in each record a sequence of <field-name, field-value> pairs rather than just the field values.
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Toronto Canada
    Rep Power
    do a search for key-value pairs and entity-attribute-value
    r937.com | rudy.ca
    please visit Simply SQL and buy my book

IMN logo majestic logo threadwatch logo seochat tools logo