2 Replies - 1342 Views - Last Post: 04 October 2012 - 05:16 PM

#1 riceformvp  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 04-December 11

Need help identifying Functional and Transitive Dependencies.

Posted 04 October 2012 - 03:18 PM

Attached is the ERD. I need helped identifying the dependencies. I am new to SQL and am quite lost...Attached Image
Is This A Good Question/Topic? 0
  • +

Replies To: Need help identifying Functional and Transitive Dependencies.

#2 Atli  Icon User is online

  • D.I.C Lover
  • member icon

Reputation: 3716
  • View blog
  • Posts: 5,975
  • Joined: 08-June 10

Re: Need help identifying Functional and Transitive Dependencies.

Posted 04 October 2012 - 04:49 PM

I have no idea what those terms are supposed to mean. Does your textbook contain some sort of explanation for them?

I have to say, though, that that is pretty odd design. You've got the main "GuestInformation" table, where each guest is defined. Then you have four other tables, all of which store rows of data specific to one member, but rather than store the ID of the guest with the data in those tables you store a reference to the data in the main GuestInformation table. And if that's not odd enough, you don't actually store the PK of the data, but rather one of the data fields: the phone number, the check in data, the "gold" value, and the country.
Was This Post Helpful? 0
  • +
  • -

#3 riceformvp  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 04-December 11

Re: Need help identifying Functional and Transitive Dependencies.

Posted 04 October 2012 - 05:16 PM

A Functional dependency is where if a developer sees one attribute, he will know the outcome of the second. Example, If I know A --then I know B verbatim.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1