Databases In A Business
Phase 3- task 1: Discussion Board
Business rules are a set of characteristics of an application which contributes to the efficiency of a database. A database has to be flexible such that any application that is put in place embraces the subsequent changes which will be included in the database when it is being updated. This minimizes the need to establish a new database each time a something has to be added or modified.In this case study, one of the most essential business rules is the program codes for the various types of information that is incorporated into the database. Such program codes include details which are quite permanent such as their name which allows for a more enhanced task of editing the database.
This gives a chance for the company to put data which is relevant at that particular time and the denormalizing engine used in the application should ensure that any additional information is added simultaneously.Seeking clarifications as well as understanding the business rules of a company is important especially to a database designer as it must meet the needs and requirement of the company. The logical design of the database should incorporate the essential features which are most important to the company as it will make no sense when the design fails to meet the requirements.
Phase 3-task 2: Individual Project
Inherent limitations and benefits of Microsoft Access, SQL Server and FoxPro
FoxPro database incorporates the use of codes which enable the user to execute user defined applications. The best feature in FoxPro is the ability to store back ups of the data that has been put in the database online. This becomes equally important for companies which are faced by recurrent power failure which may lead to lose of unsaved data (Datanet Solutions, 2010). However, this advantage is only effective for individuals who are very keen on their data input otherwise more errors may be experienced. It therefore calls for experienced personnel to use FoxPro especially during subsequent up dates to avoid harming existing data. Consequently, FoxPro is less compatible with most operating systems thus limiting the number of areas where it can be applied. Only UNIX and Windows Winus are compatible with the application while others are not quite efficient (Datanet Solutions, 2010).
This is the program of choice for most companies solely due to its flexibility as it is highly compatible with quite a number of operation systems. MySQL is quite fast during data input as well as being user friendly such that it does not require a qualified computer wizard to run and operate it(Oracle Corporation, 2010).This database provides for faultiness when entering data by allowing the user to edit and compile complete data by suggesting ways through which the data which is entered can be verified. However, the database does not allow usage of more than one code such as when a certain feature of employees is not constant, different codes cannot be used for that item.
Therefore, it may prove to be quiet challenging for the needs of Sorenson Medical (Oracle Corporation, 2010).Microsoft AccessMicrosoft Access offers a unique opportunity to database managers such that they can be able to import data for other sources such as other employee records. By creating links, the various sources of data are incorporated into one hence making data entry a less tedious task. Data that is entered into the Microsoft Access database is often faced with the risk of being corrupted by unknown applications. This is especially common in small files which are less than 10MB in size. Larger files are however quite safe hence it becomes quite important to compile large files or else store them in secondary storage devices (Microsoft Access, 2010).
Why Microsoft Access is the most appropriate tool for this problem
Over the years, Microsoft Access has been modified to make it more efficient in storing al types of data regardless of size and complexity. Data which contains variant attachments as well as that containing different values such as information on level of education or home address may be incorporated without any problems. This makes it ideal for Sorenson medical as it will be flexible enough to enter all necessary data per employee (Microsoft Access, 2010).
An equally important feature of Microsoft Access allows different users to enter as well as edit their own data at the same time using different computers. This option reduces congestion as well as the workload which would otherwise be placed on a single employee. The company will thus save on manpower and time by ensuring all the computers are networked and each employee given the mandate to modify their information as they progress in their careers. This feature is exceptionally easy to execute as it offers a wide variety of queries which the user applies when entering any data (Microsoft Access, 2010).
Datanet Solutions. Inc, (2010), FoxPro vs. Access databases for medical and health software. Retrieved on June 2, 2010 from: www.datanetsolutions.org/foxpro.htm
Microsoft Access, (2010), what’s new in Microsoft Access 2010. retrieved on June 2, 2010 from: www.microsoft.com/.../8794ea1b-ef03-4a09-a86a-0caabf590fcd -
Oracle Corporation (2010), MySQL performance benchmark. Retrieved on June 2, 2010 from: www.databasejournal.com/.../Using-a-MySQL-database-with-PHP.htm.