Strengths And Weaknesses Of Database System

A database administration framework (DBMS) is a PC programming application that connects with the client, different applications, and the database itself to catch and dissect information. A universally useful DBMS is intended to permit the definition, creation, questioning, upgrade, and organization of databases.

A Database Management System or (DBMS) is an essential tool for any organization or company in today’s modern world. A DBMS is “a group of programs that manipulate the database and provide an interface between the database and its users and other application programs” (Stair & Reynolds, 2011, p. 189). So in choosing the right DBMS there are many factoring issues with choosing the right one for the company or organization. When choosing a DBMS one has to think about how the system will ultimately help the company or organization with day to day processes and the goals of the company or organization.

Database plays a major role in any organization. As a Database administrator(DBA) he/she is responsible in developing, implementing and maintaining the databases and DBA 's are also responsible in updating, backup 's and security of the databases. The first Database Management System was developed in the late 1960 's by two firms based on their network data model but in the early 1970’s a scientist of IBM introduced Relational database theory after six years IBM completed prototype on RDBMS (relational database management system). Oracle created the first versatile Relational Database Management Systems In 1983, which allowed organizations to use their DBMS on different machines including mainframes, workstations, and Pc 's. In 1993 Microsoft first created a database application called Access for Macintosh machines. Microsoft SQL server is a RDBMS which is used to store and retrieve the data by other software applications. There are 12 types of servers concentrated on various types of user 's from single computer to large networks (Microsoft SQL DBA).

Customer Relationship Management (CRM) is a tool that helps track, manage and supply information about customer’s interactions with an organization to help contribute to customer satisfaction that leads to customer loyalty. Additionally, CRM programs provide tools and applications designed to target their efforts on the most profitable customers, target new potential customers, and generate sales and maintain relationships with customers contributing to a greater market share.

This paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems’ functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of companies that typically use each one, the normal usage of the DBMS, and the costs associated with implementing the DBMS.

In order to support the business requirements and help the decision making process by top level managers in Sunshine Escapes, this BI Application is used as solution. The organization has outlined their business needs and drivers and presented this information. As such, the development for the BI application based on current system and database from Sunshine Escapes.

In the world of computer science large groups of data that are collected are referred to as databases. When there is a multitude of these databases, a way to manage all of this information is needed. That is where database management systems (DBMS) come into play. “A database management system is a collection of programs that enables users to create and maintain a database. The DBMS is a general-purpose software system that facilitates the processes of defining, constructing, manipulating, and sharing databases among various users and applications” [1]. Analyzing these database managements systems could potentially have huge benefits since companies could determine when and where to sell products, track certain trends, and possibly predict future outcomes.

Organizations accept CRM as a strategic focus medium for integrating fully with customers and help in the management and decision making process appropriately.

of its schema-less structure along with its capability of handling BIG Data. In this paper, we talk

Everyday the world progressively moves towards a digital future, and the use of physical data storage, such as files in filing cabinets, are becoming obsolete. Most companies store their information into databases to easily manage and share their data within the organization. A database management system (DBMS) is needed to to create, use and maintain databases for the efficient storage and retrieval of data.

It’s very important to a business to have good customer relationships; CRM Software’s main objectives are to attract new customers while maintaining and satisfying their current customers and trying to win back the trust of former customers. Customers are one of the most important variables for a business owner to pay attention to, when trying to create a profit. Customer Relationship Management software keeps track of customer information to help the company maintain a strong relation with the customers. Good CRM Software brings together information from all databases within a company and gives

CRM (Customer Relationship Management) is an information industry term for methodologies, software, and usually Internet capabilities that help an enterprise manage customer relationships in an organized way. For example, an enterprise might build a database about its customers that described relationships in sufficient detail so that management, salespeople, people providing service, and perhaps the customer directly could access information, match customer needs with product plans and offerings, remind customers of service requirements, know what other products a customer had

With the increasing requirements of the business world, software developers came up with the computerized database solution which has multiple built. Computer database reduces the replication of the data by storing the data at a central location so that everyone can access it

CRM systems are customer relationship management platforms. The goal of the system is to track, record, store in databases, and then the

A database can be termed as data collection. Data management applications allow the user to access the data, edit the data, update and monitor the data. One of such general purpose database applications is Oracle.