Thursday, December 23, 2004 - Posts
Omaha's next local Microsoft.NET UG (Omaha.NET) meeting will be held on the 20th of January at Creighton University, West Omaha Campus. Ken Getz will be presenting on a topic to be determined. Whatever it is, mark your calenders as he is a great speaker and always does a kick ass job laying down the smack. This will be his second appearance at the Omaha.NET group, and it's all made possible by INETA.
I have been fortunate enough to be involved with INETA since the beginning and feel privileged to be both a UG liaison for other groups in my region, as well as a strategic member of the UG relations board. Thanks INETA for all of our speakers, both past and future.
Roll call to this date: Sam Gentile, Ken Getz, Jon Box, Rockford Lhotka, Martin Shoemaker, and Dan Wahlin
Yesterday I received an update on a project I am somewhat involved with including the standard Visio diagram with a purposed database layout from one of the developers on the project. After a quick glance there were some glaring revisions that needed to be made in order for the document to be an accurate representation of what the schema should look like. On of the suggestions I made was to use Xref tables between entities like Person > Address, Person > PhoneNumber, etc.. I explained to him the advantage of using an Xref table with a type field and how it would solve the problem of one person having many addresses, while minimizing the duplication of data in the address field. To my surprise, the developer had never heard of Xref tables or any of the other suggestions I made. A couple of the other main suggestions I made were:
- Use a standard nomenclature for tables,pks, and fks ie. Person(Table), Person_ID(PK), PersonID(FK)
- Use a guid for the identifier in certain tables for added security
Having said all of that, I started to wonder whether what I was explaining to him was standard or simply preference, or maybe a little bit of both. I was shocked to hear that he knew nothing of Xref tables, he had not even heard the name before. Is this no longer part of development education. Is the education market so corporate that we talk more about tools than theory and practical application now?
Anyway, I would be interested in hearing from you're thoughts on these issues. What are some of your practices in regards to the above mentioned suggestions?
If you have not heard yet, Yahoo! has launched their
beta movie search. You'll immediately notice the similar layout and color scheme of Google's Image Search, and after performing a search you'll realize the power of this tool. I have spent about an hour surfing for movies and I have yet to not find something I am looking for. I am surprised I have not heard more pub, but I suspect it's because of the release stage of the software. Pretty cool though.