Click here to Skip to main content
15,790,175 members
Home / Discussions / Database
   

Database

 
GeneralRe: How to Sort this, Get Next Record ID when Many users inserting and different Districts Pin
ZurdoDev6-Jun-14 3:49
professionalZurdoDev6-Jun-14 3:49 
AnswerRe: How to Sort this, Get Next Record ID when Many users inserting and different Districts Pin
Eddy Vluggen6-Jun-14 3:36
professionalEddy Vluggen6-Jun-14 3:36 
AnswerRe: How to Sort this, Get Next Record ID when Many users inserting and different Districts Pin
PIEBALDconsult6-Jun-14 15:38
professionalPIEBALDconsult6-Jun-14 15:38 
QuestionSQLite query Pin
David Crow5-Jun-14 11:38
David Crow5-Jun-14 11:38 
AnswerRe: SQLite query Pin
Mycroft Holmes5-Jun-14 13:47
professionalMycroft Holmes5-Jun-14 13:47 
GeneralRe: SQLite query Pin
David Crow5-Jun-14 18:38
David Crow5-Jun-14 18:38 
QuestionQuestion on Canidate keys and functional dependecies Pin
Member 108651294-Jun-14 17:35
Member 108651294-Jun-14 17:35 
AnswerRe: Question on Canidate keys and functional dependecies Pin
Eddy Vluggen5-Jun-14 9:05
professionalEddy Vluggen5-Jun-14 9:05 
Member 10865129 wrote:
i know that cookie cost is functiolly dependent on the number of boxes
That goes for all calculations, but that's not what's meant in the context of normalization.

Member 10865129 wrote:
i am trying to fine the canidate key and the functional dependency in this table
The table should be in 0NF first, in which case it needs a name. To find the candidate keys, you'd make a list of the fields that can be used to identify a unique record.

They look like meetings. What fields would the you combine to get a unique meeting - no, rephrase, which of those facts does the user require to uniquely identify an entry? If I'm not mistaken, then it's a compound key.

Next you'll be hunting for fields that are functionally dependent on a part of that key; they need to be moved to their own table (if there are any, and yes, I seen one) Ask yourself for each non-key field the question: "does this fact depend on the complete cadidate key, or is it determined by part of the candidate?"

Easy explanation; http://support.microsoft.com/kb/283878[^]
Complex explanation; http://en.wikipedia.org/wiki/Functional_dependency[^]
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

AnswerRe: Question on Canidate keys and functional dependecies Pin
Eddy Vluggen7-Jun-14 0:39
professionalEddy Vluggen7-Jun-14 0:39 
QuestionIssue deploying SSIS Package in production web server Pin
Shuaib Kaniyar4-Jun-14 1:46
Shuaib Kaniyar4-Jun-14 1:46 
Question+ operaotor for outer joins in mysql. Pin
aghori3-Jun-14 20:55
aghori3-Jun-14 20:55 
AnswerRe: + operaotor for outer joins in mysql. Pin
Jörgen Andersson3-Jun-14 22:16
professionalJörgen Andersson3-Jun-14 22:16 
SuggestionData Mining Structure not Available in SSAS Tabular Model Pin
FLouis382-Jun-14 7:14
professionalFLouis382-Jun-14 7:14 
QuestionReady to give up on MySQL - is PostgreSQL better? Pin
Wombaticus1-Jun-14 23:09
Wombaticus1-Jun-14 23:09 
AnswerRe: Ready to give up on MySQL - is PostgreSQL better? Pin
Jörgen Andersson1-Jun-14 23:37
professionalJörgen Andersson1-Jun-14 23:37 
GeneralRe: Ready to give up on MySQL - is PostgreSQL better? Pin
Wombaticus1-Jun-14 23:43
Wombaticus1-Jun-14 23:43 
GeneralRe: Ready to give up on MySQL - is PostgreSQL better? Pin
Jörgen Andersson2-Jun-14 0:08
professionalJörgen Andersson2-Jun-14 0:08 
QuestionA query with lot of inner queries Pin
indian14329-May-14 13:41
indian14329-May-14 13:41 
AnswerRe: A query with lot of inner queries Pin
Mycroft Holmes29-May-14 14:02
professionalMycroft Holmes29-May-14 14:02 
GeneralRe: A query with lot of inner queries Pin
indian14329-May-14 14:09
indian14329-May-14 14:09 
GeneralRe: A query with lot of inner queries Pin
Mycroft Holmes29-May-14 15:08
professionalMycroft Holmes29-May-14 15:08 
AnswerRe: A query with lot of inner queries Pin
Jörgen Andersson29-May-14 23:20
professionalJörgen Andersson29-May-14 23:20 
GeneralRe: A query with lot of inner queries Pin
Mycroft Holmes30-May-14 2:50
professionalMycroft Holmes30-May-14 2:50 
GeneralRe: A query with lot of inner queries Pin
Jörgen Andersson30-May-14 4:15
professionalJörgen Andersson30-May-14 4:15 
GeneralRe: A query with lot of inner queries Pin
indian14330-May-14 10:08
indian14330-May-14 10:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.