simon-623950 (10/6/2010)
I'm glad I don't work in an environment where I rely on someone else designing the database then someone else programming the datalayer then someone else designing the frontend. Surely in any project you would put heads together and come up with a plan before just going ahead and bodging together a database then expecting everyone else to work with it.
Actually I am working in an environment where I created a database that fits the "frame" and ideas in this article (primary keys data audit fields etc) and the app developer that is coding in vb is totally out of the purpose of the project ... I would say that at the end the data will be stored in a database and this is the root of many projects involving SQL in any of its flavors ... the SQL developer mus be really the dude with a lot of brain in there and the others must respect the datatypes and the constraints he puts otherwise the final result will be like using bags of text instead of consistent data to store your information ... But this is just an opinion 😎