Best Practice- DB design
-
Hi, What is the best recomended approach for designing Database for calculated fields. lets say you are collecting daily expense reports. department A reports the total weekly and department B reports every day expense. So the weekly are the calculated fields for the daily expense of Dept A. On the other hand department C might report both depending on the details and the availability of the information. they might give you the totals now as you are trying to create the budget. but they will give you the details when you need the auditors to do their work. Is there a text book best practice for solving this problem. Cheers It is Illogical to define an inventor by his invention
-
Hi, What is the best recomended approach for designing Database for calculated fields. lets say you are collecting daily expense reports. department A reports the total weekly and department B reports every day expense. So the weekly are the calculated fields for the daily expense of Dept A. On the other hand department C might report both depending on the details and the availability of the information. they might give you the totals now as you are trying to create the budget. but they will give you the details when you need the auditors to do their work. Is there a text book best practice for solving this problem. Cheers It is Illogical to define an inventor by his invention
While this might be considered something of a programming question, and this is the Lounge, it is after all Easter, and I am filled with the joy of the promise of rebirth, so I will respond. The company you are working for is obviously filled with mean minded wastes of skin clinging to what putative power they believe they have in order to somehow justify their meager and petty existences. Petition higher management to standardize expense reporting techniques across departments. Refusal to do so will not be tolerated. Those in the various departments who complain shall be shot. Those using the phrase "But we've always done it this way!" will be shot twice. Failure to smack this company upside its collective lard filled head will result in you, the poor programmer, being saddled with writing a new report every time some spotty bummed porridge brain decides that today would be a good day to file a bi-monthly breakdown. With my sincere best wishes and the hope that you shall receive the blessings of the Prophets, Tim
-
While this might be considered something of a programming question, and this is the Lounge, it is after all Easter, and I am filled with the joy of the promise of rebirth, so I will respond. The company you are working for is obviously filled with mean minded wastes of skin clinging to what putative power they believe they have in order to somehow justify their meager and petty existences. Petition higher management to standardize expense reporting techniques across departments. Refusal to do so will not be tolerated. Those in the various departments who complain shall be shot. Those using the phrase "But we've always done it this way!" will be shot twice. Failure to smack this company upside its collective lard filled head will result in you, the poor programmer, being saddled with writing a new report every time some spotty bummed porridge brain decides that today would be a good day to file a bi-monthly breakdown. With my sincere best wishes and the hope that you shall receive the blessings of the Prophets, Tim
Tim Deveaux wrote: The company you are working for is obviously filled with mean minded wastes of skin clinging to what putative power they believe they have in order to somehow justify their meager and petty existences. Don't hold back. Tell us how you really feel. Mawahahahahahahahaha... Jerry He said this was like painstakingly assembling the first layer of a house of cards, then boasting that the next 15,000 layers were a mere formality.--The Code Book, pp. 331 Toasty0.com DotNetGroup.org
-
While this might be considered something of a programming question, and this is the Lounge, it is after all Easter, and I am filled with the joy of the promise of rebirth, so I will respond. The company you are working for is obviously filled with mean minded wastes of skin clinging to what putative power they believe they have in order to somehow justify their meager and petty existences. Petition higher management to standardize expense reporting techniques across departments. Refusal to do so will not be tolerated. Those in the various departments who complain shall be shot. Those using the phrase "But we've always done it this way!" will be shot twice. Failure to smack this company upside its collective lard filled head will result in you, the poor programmer, being saddled with writing a new report every time some spotty bummed porridge brain decides that today would be a good day to file a bi-monthly breakdown. With my sincere best wishes and the hope that you shall receive the blessings of the Prophets, Tim
The company you are working for is obviously filled with mean minded wastes of skin clinging to what putative power they believe they have in order to somehow justify their meager and petty existences. :laugh: So that's the joy of rebirth, eh? I'm filled with that everyday then! Should I be extra joyful on Easter sunday? :-D
[Cheshire] I can't afford those plastic things to cover the electric sockets so I just draw bunny faces on the electric outlets to scare the kids away from them... [RLtim] Newsflash! Kids aren't afraid of bunnies. [Cheshire] Oh they will be... -Bash.org
-
Tim Deveaux wrote: The company you are working for is obviously filled with mean minded wastes of skin clinging to what putative power they believe they have in order to somehow justify their meager and petty existences. Don't hold back. Tell us how you really feel. Mawahahahahahahahaha... Jerry He said this was like painstakingly assembling the first layer of a house of cards, then boasting that the next 15,000 layers were a mere formality.--The Code Book, pp. 331 Toasty0.com DotNetGroup.org
-
While this might be considered something of a programming question, and this is the Lounge, it is after all Easter, and I am filled with the joy of the promise of rebirth, so I will respond. The company you are working for is obviously filled with mean minded wastes of skin clinging to what putative power they believe they have in order to somehow justify their meager and petty existences. Petition higher management to standardize expense reporting techniques across departments. Refusal to do so will not be tolerated. Those in the various departments who complain shall be shot. Those using the phrase "But we've always done it this way!" will be shot twice. Failure to smack this company upside its collective lard filled head will result in you, the poor programmer, being saddled with writing a new report every time some spotty bummed porridge brain decides that today would be a good day to file a bi-monthly breakdown. With my sincere best wishes and the hope that you shall receive the blessings of the Prophets, Tim
Tim Deveaux wrote: Petition higher management to standardize expense reporting techniques across departments. Refusal to do so will not be tolerated. Those in the various departments who complain shall be shot. Those using the phrase "But we've always done it this way!" will be shot twice. I love it....
George Carlin wrote: "Don't sweat the petty things, and don't pet the sweaty things." Jörgen Sigvardsson wrote: If the physicists find a universal theory describing the laws of universe, I'm sure the asshole constant will be an integral part of that theory.
My Blog[^]
-
While this might be considered something of a programming question, and this is the Lounge, it is after all Easter, and I am filled with the joy of the promise of rebirth, so I will respond. The company you are working for is obviously filled with mean minded wastes of skin clinging to what putative power they believe they have in order to somehow justify their meager and petty existences. Petition higher management to standardize expense reporting techniques across departments. Refusal to do so will not be tolerated. Those in the various departments who complain shall be shot. Those using the phrase "But we've always done it this way!" will be shot twice. Failure to smack this company upside its collective lard filled head will result in you, the poor programmer, being saddled with writing a new report every time some spotty bummed porridge brain decides that today would be a good day to file a bi-monthly breakdown. With my sincere best wishes and the hope that you shall receive the blessings of the Prophets, Tim
Dear Tim The ENCHANTER, First Happy Easter before your mail get crowded with good wishes. :rose: second let me in front of all our fellow CP'ians appologize for not staying in touch. now that should cool down the moose (and the camel too) in all of us. Tim Deveaux wrote: The company you are working for is obviously filled with mean minded wastes of skin clinging to what putative power they believe they have in order to somehow justify their meager and petty existences Wow, in which cubic are you setting.... is it the one next to the new blond chick. ;P No really, the place here is big on policy and procedures. but.. Tim, I know You will envy me when you know that....:sigh: you know how you always dreamt of working for "RESEARCH" I do now :suss::cool: MWAHAHAHAHA. When it comes to data collection I work out the best of what I get. I could not enforce rules for historical data that goes back to 20-30 years (hell, good thing they have data for it anyway). let alone from different research centers. so having policy and or procedures to enforce the proper way is out of the question. Any other thoughts dude!! P.S. no that thing in your hand does not count as easter egg. It is Illogical to define an inventor by his invention
-
Dear Tim The ENCHANTER, First Happy Easter before your mail get crowded with good wishes. :rose: second let me in front of all our fellow CP'ians appologize for not staying in touch. now that should cool down the moose (and the camel too) in all of us. Tim Deveaux wrote: The company you are working for is obviously filled with mean minded wastes of skin clinging to what putative power they believe they have in order to somehow justify their meager and petty existences Wow, in which cubic are you setting.... is it the one next to the new blond chick. ;P No really, the place here is big on policy and procedures. but.. Tim, I know You will envy me when you know that....:sigh: you know how you always dreamt of working for "RESEARCH" I do now :suss::cool: MWAHAHAHAHA. When it comes to data collection I work out the best of what I get. I could not enforce rules for historical data that goes back to 20-30 years (hell, good thing they have data for it anyway). let alone from different research centers. so having policy and or procedures to enforce the proper way is out of the question. Any other thoughts dude!! P.S. no that thing in your hand does not count as easter egg. It is Illogical to define an inventor by his invention
Hey Raz! Ok - enough with the cliquey buddy buddy stuff now. We're discussing programming in the lounge, which is bad enough! :cool: Ghazi Al Wadi wrote: Any other thoughts dude!! Well, yes. Develop a schema for the database itself that is as simple as possible, i.e. what you would ideally have if all reporting was the same. Set up some secondary db and/or speadsheet environment that can funnel the diverse data sets into a form you can import when all the camels have been fed. This is a process I call 'data composting', a term I just made up. If you see this phrase in a textbook, let me know so I can sue. Ghazi Al Wadi wrote: P.S. no that thing in your hand does not count as easter egg. How does he know?? :~