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

    Join Date
    Apr 2013
    Location
    India
    Posts
    65
    Rep Power
    20

    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
    Location
    Toronto Canada
    Posts
    27,260
    Rep Power
    4279
    do a search for key-value pairs and entity-attribute-value
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

IMN logo majestic logo threadwatch logo seochat tools logo