Share
Explore BrainMass

Database Systems

convenient way to handle business transactions by eliminating the use of mundane processes that may occur. For instance, most e-Commerce based organizations have a FAQ page on their website in order to address the recurring concerns and questions of consumers, this allows an organization to answer the same question continuously without providing new information to answer that one question, therefore a FAQ page is a method of reducing the amount of reiteration of addressing the same issue. In retrospect a database is similar to an internal electronic FAQ page for a business, for example, it is a convenient way to handle an overwhelming demand for an organizational process such as; an HR function of payroll or employment recruiting. A database would contain sensitive information, thus offering a system that enables the organization to store a large amount of information. According to Senior Researcher for Microsoft Corporation, James N. Gray (1997), database systems have taken on many forms of evolution and variations of changes to restructure organization and revolutionize the way organizations conduct business. Databases evolved from a prehistoric form of an "ad hoc" framework, to network, to hierarchical database architecture. The server detail for databases implementation would be Windows 2000. Williams (1999) Windows has upgraded their cross-platform support to provide optimized binaries for a wide range of platforms, including Linux, Microsoft, Windows, Free BSD, Sun Solaris, IBM's AIX, Mac OSX, HP-UX, AIX, ONX, Novell Netware, SCO Open Unix, SGI Irx and Dec OSF. For transaction we will use the InnoDB or Berkeley DB (DBD) storage engines, the Microsoft SQL database server supports the transactions and this storage engine also supports foreign key constraints.

Microsoft SQL Database Server (Microsoft.SQL.com) is used as a relationship between the data and the data stored in a secondary storage. The data in a database may be kept in several separate files or in one large file. The way the data is stored depends on the database software engine. The capabilities of Microsoft SQL Database Server include an embedded database library so you can include the full power of Microsoft SQL 2000. This is a product of Microsoft Corporation current 64-bit version. It holds the top spot in non-clustering transaction processing into application and electronics and devices without your end-user having any awareness of the underlying database. This server has unlimited possibilities due the embedded databases idea for behind the scenes Internet application, such as public, kiosks, turn-key hardware/software combination units, high performance Internet servers, self-contained database distributed on CD". This information was gathered at (Microsoft.SQL.com)

Solution Preview

Dollar General Database

Database systems are developed to make an organization's day-to-day operations run smoothly. It provides an organization a convenient way to handle business transactions by eliminating the use of mundane processes that may occur. For instance, most e-Commerce based organizations have a FAQ page on their website in order to address the recurring concerns and questions of consumers, this allows an organization to answer the same question continuously without providing new information to answer that one question, therefore a FAQ page is a method of reducing the amount of reiteration of addressing the same issue. In retrospect a database is similar to an internal electronic FAQ page for a business, for example, it is a convenient way to handle an overwhelming demand for an organizational process such as; an HR function of payroll or employment recruiting. A database would contain sensitive information, thus offering a system that enables the organization to store a large amount of information. According to Senior Researcher for Microsoft Corporation, James N. Gray (1997), database systems have taken on many forms of evolution and variations of changes to restructure organization and revolutionize the way organizations conduct business. Databases evolved ...

Solution Summary

Dollar General Database

Database systems are developed to make an organization's day-to-day operations run smoothly. It provides an organization a convenient way to handle business transactions by eliminating the use of mundane processes that may occur. For instance, most e-Commerce based organizations have a FAQ page on their website in order to address the recurring concerns and questions of consumers, this allows an organization to answer the same question continuously without providing new information to answer that one question, therefore a FAQ page is a method of reducing the amount of reiteration of addressing the same issue. In retrospect a database is similar to an internal electronic FAQ page for a business, for example, it is a convenient way to handle an overwhelming demand for an organizational process such as; an HR function of payroll or employment recruiting. A database would contain sensitive information, thus offering a system that enables the organization to store a large amount of information. According to Senior Researcher for Microsoft Corporation, James N. Gray (1997), database systems have taken on many forms of evolution and variations of changes to restructure organization and revolutionize the way organizations conduct business.

$2.19