Is there has a standard database schema design for business process application?
I found that many application for business purposes (such as accounting, inventory, AP/AR/GL, even includes manufacturing process, CRM) could sharing a similar database schema. Why nobody try to consolidate together and build a BEST database schema, and everybody follows it, to improve communication among applications? Or we could either build a BASIC Standard database schema, and allow people doing extension from it. It could save a lot of effort people putting it. These people all are spending time in doing similar job, and still create barrier for applications communicate to each other. Or, if there is one, please tell me where is it. Thanks.
Asked By: wyeechen - 8/13/2006
Best Answer - Chosen by Asker
I don't know if there is a standard, but there are certain rules that you should follow. It is VITAL that your database be setup correctly or you will have to pay for it every day of the rest of your life, or as long as you work there... More
Answered By: Michael M - 8/13/2006
Additional Answers (1)
It is very hard to build a fits all DB scheme, but you should always adhere to relational model RDBM with a high database normalization level, where there is no data repetition but you referance related data with their ID (primary key - foreign key relation ship) and enforce referential integrity with rules in DB... More
Answered By: hayral - 8/13/2006
Over 483 Local Jobs Now Hiring In Your Area. $18-$87/Hr - Apply Today!
Shop Online or Sign Up To Sell AVON & Earn Fast Cash Today!
Click. Search. Apply. Free!
Free for Job Listers and Job Seekers!
Other Career Questions
Do most mechanical engineering jobs offer job security?
What is your current job? Why did you choose this job? What do you enjoy about your job? What do you dislike about your job? What would be your perfect job? Would you rather have this j...
Where are the jobs? Is productivity and globalization creating a permanent “recession” of jobs? My main issue is I am doing a paper for school and have no idea where to begin. I was hoping suggestions...
Content is not owned or controlled by Monster. Any content concerns should be addressed with Yahoo!
Yahoo! Does not evaluate or guarantee the accuracy of any Yahoo! Answers content. Yahoo! Disclaimer.
Best-Paying Work-from-Home Jobs
It’s easier than ever to work from home. Of course, not every job is a mobile job, and some companies aren’t interested in having their employees work from home.
2013 Marketing Jobs Outlook
The US may be facing another year of anemic hiring overall, but that won't be the case in the high-orbit world of multichannel, digital media marketing.
2013 Engineering Jobs Outlook
Engineers will find job opportunities in select disciplines in 2013, with candidates who are all-around, client-oriented businesspeople in demand.
Best-Paying Jobs by Major
What could you earn with a particular four-year degree? Find out by checking out this list of the top-paying jobs for 20 of the most common majors.
Eight High-Paying, Secure Jobs
Want to earn a good salary and enjoy a measure of job security as well? Check out these well-paying jobs on tap for fast growth in the coming years.