Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2014

    Unanswered: SQL DB- Is that a functional dependency?

    Deleted Question
    Last edited by dbdisco; 05-02-14 at 11:47.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Quote Originally Posted by dbdisco View Post
    Im struggling with working out whether a UK Postcode functional determines its city... In the UK a Postcode(Zip Code) specifies a street (Maximum 80 properties) but the street/properties will always be in a City. e.g. LO01 1AS will always relate to Thames Road in London.

    There are only a few exceptions to a post code being functionally dependent on the city in the UK, but some do exist. From a RA (Relational Algebra) standpoint, the exceptions invalidate the functional dependency.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts