panda17
Re:SQL X-to-Y
on Tuesday November 03, 2020 @03:33PM (#24983663)
Regarding the "industry term", search:
site:oracle.com "alternate key"
site:microsoft.com "alternate key"
site:ibm.com "alternate key"
Re:SQL X-to-Y
on Sunday November 01, 2020 @03:45PM (#24962359)
In general there can be more than one candidate key for a given relation (table). Only one candidate key is "primary", all others are "alternate".
Re:SQL X-to-Y
on Sunday November 01, 2020 @02:48PM (#24961952)
A thing is uniquely identified by T, category by C.
May read it as: CREATE TABLE thing (T_ID integer, C_ID integer)
Re:SQL X-to-Y
on Sunday November 01, 2020 @01:55PM (#24961567)
Sorry, firewall thing -- dependent on recent (geo-ip) threats. Nothing to do with ads -- no ads.
SQL X-to-Y
Teaching normalization past 1NF in basic DB courses considered harmful
Re:Ask HN: Database Design Materials?
on Wednesday May 08, 2019 @11:49AM (#19860005)
Consider starting with these two papers, and then ...
Michael Stonebraker et al., Architecture of a Database System, 2007.
Michael Stonebraker et al., The End of an Architectural Era, 2007.