Database Management System Case Study: Clara Osbourne Technologies

This case study examines Clara Osbourne Technologies and its use of a database management system (DBMS) to achieve competitive advantages. The report delves into business strategy, applying Porter's Five Forces model to analyze competitive rivalry, supplier power, buyer power, threat of substitution, and threat of new entry. It also explores supply chain management, including chain management, inventory control, information management, fund management, and the role of information technology, along with push and pull strategies and e-procurement. Additionally, the case study differentiates between DBMS and enterprise resource planning systems, discusses customer relationship management (CRM), and touches upon the role of social media. Recommendations and conclusions are provided, offering insights into how Clara Osbourne Technologies can optimize its DBMS and business strategies for improved outcomes.

CASE STUDY

EXECUTIVE SUMMARY
In this report, it has been identified that database management system is the effective
element which certainly system software. It assists to create effective functioning to create
database management. In this way, computing business getting several advantages with
implementation of the business targets and goals. Therefore, database management system easily
developed with using accelerating information. With this regard, report summarized about the
Porter five forces model which assists to develop effective functioning within the market.
Therefore, it needed assessment of the market through catering effective information in the
market.

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
TASK 2............................................................................................................................................1
Section 1 Business strategy.........................................................................................................1
.....................................................................................................................................................7
Section 2 Differentiating between database management system and an enterprise resource
planning system...........................................................................................................................7
Section 3 Customer relationship management..........................................................................10
Section 4: Social media.............................................................................................................13
RECOMMENDATION AND CONCLUSION.............................................................................16
TASK 3..........................................................................................................................................17
REFERENCES................................................................................................................................1

ILLUSTRATION INDEX
Illustration 1: Porter five forces model............................................................................................4
Illustration 2: Supply chain management........................................................................................7
Illustration 3: Role of of CRM.......................................................................................................13
Illustration 4: Role of social media................................................................................................16

INTRODUCTION
Database management system is determines as the important concept which develop
system and software for managing the databases. This is because, it provides systematic way to
create, update data and managing the activities for programmers and clients as well (Sutherland,
2014). Therefore, it is possible to create, go through and delete details within the database. There
are several elements included in the database management systems which developed in
systematic way to identify access, MySQL, Oracle, etc. This is because, it caters several
advantages to get access in the organisation. For example, easy to install and use, ease to
integrate, etc. In this context, present report based on the computing firm Clara Osbourne
Technologies which is developed and impressed to Dr William Moulton Marston. There are
effective decision support system carry with utilising Microsoft excel.
For gaining insight knowledge of the company, report covers research activity with full
description to develop appropriate website in the business. In this aspect, time duration has been
ascertain in the activity to accomplish business strategy. In this way, Dr William Moulton
Marston want to attain competitive advantages so that report explain about Porter Five Forces
model which is related to the development of the goal and objectives.
TASK 1
Research activity: To attain competitive advantage in the computing knowledge for attain
overall growth and profit.
In this research activity, information collected to gain information towards the
competitive advantages in the business unit. Therefore, profitability can be made to gain relevant
results with different business strategies (Gai and Steenkamp, 2014). This activity require total 2
weeks to accomplish effective results in the business.
TASK 2
Section 1 Business strategy
Porter's five force model
Porter's five force is the powerful tool which assists to develop effective functioning and
attain competitive advantages as well. In this aspect, Dr William Moulton Marston can easily
make their business to attain competitive advantages. Therefore, outcomes will be develops in
1

systematic way. Following are certain elements implemented in the porter's five forces model
which assists to accomplish the effectiveness in the country:
Competitive rivalry (High): This element show effectiveness at the number of strength of
the competitors. Therefore, rivalry develop to make competitive advantages for the products and
services of the company of Dr William Moulton Marston. When the company has rivalry, they
can easily attract several customers together with aggressive price cuts and impact highly on the
marketing campaigns (Kumar, Dass and Kumar, 2015). In addition to this, buyers can also go
elsewhere to get good deal with competitive rivalry. When competitive rivalry is minimum,
strength and profitability outcomes can be enhances in the market that enhance profitable
solution to achieve more profits and revenue. High rivalry sometimes creating more profits and
revenue that assists to develop effective functioning at workplace. It makes high profits and
growth in the business for developing profitability at workplace (Marshall, 2013). In order to
determines implication of the porter five force model, competitive advantages can be attain when
development can be enhances in systematic way.
Supplier power (Less): This element determines how suppliers easily increasing their
prices towards the products and services. For the company of Dr William Moulton Marston,
several suppliers have so that they can easily switch towards the other suppliers to develop
profitability. Therefore, alternative solution can be made in effective aspect that enhance targets
and outcomes as well (Esfandiari and Rizvandi, 2014). Beside this, market have lots suppliers
who provide raw material at low cost. Therefore, it is the important parameter to accomplish the
targets and effective results in computing business. However, there are several suppliers who
have strong position so that their ability assists to develop the target market and outcomes in
positive way.
Buyer power (High): In this aspect, buyers can drive on the prices down. This is because,
the company need to assess that how many buyers are exists in the market. In this aspect, cost of
the products and services need to be assessed for the rival (Jarzabkowski and Kaplan, 2015).
When the company deal with savvy customers, they have power to increases their price when
they have large base of the customers. This is because, each person have power to switch
towards other business where they demand for low cost products and services. In addition to this,
2

they are also determines profitable elements to accomplish effective functioning on the target
market.
Threat of substitution (Moderate): In this way, customers are likely to find out several
ways to do the job. For instance, supply is the unique software products that automated and
important process which make substitute for performing several targets. Substitute products and
services can easily find in the market at low cost so that it create big impact on the performances
and functions of Dr William Moulton Marston. Further, it also makes cheap quality to products
and services that make threaten to the profitability (Nag, Han and Yao, 2014). In addition to this,
it makes sure process manually outsourcing for performances of the enterprise.
Threat of new entry (low): In this aspect, position can be affected to the organisation and
its performances. In the market, there is low entry to new businesses so that it create impact on
the functions and performances of the business unit. In this aspect, protection is needed for key
technologies. As results, strong and durable entry can be made to perform functions and
operations at workplace (Kumar, Dass and Kumar, 2015). When the company has barrier to
entry, Dr William Moulton Marston has advantages to create effective functioning in their
business operations.
3

In addition to this supply chain management determines very important concept to deal
with different strategies and functions in the market. In this aspect, Dr William Moulton Marston
need to adopt the following steps in his business:
 Supply chain: In the Dr William Moulton Marston business, supply chain encompass
with all activities and information that flows necessary for transforming of the goods to
consumed and discarded. In this aspect, typically involved distribution of the products
from supplier to the manufacturer and from wholesaler to retailer, etc. (Sutherland, 2014).
Therefore, there are several elements need to be included in this aspect that assists to
accomplish transformation of the services in the industry. For example, planning,
customer services, distribution, etc.
 Management of the chain: In order to manage chain, primarily it has been concentrate
to the movement in three areas. For example, material, information and funds, etc. As
results, it will assist to accomplish the targets and goals in systematic way.
4
Illustration 1: Porter five forces model
Source: (Porter’s Five Forces of Competitive Position Analysis, 2017)

 Inventory control: Inventory control element includes several elements that considered
as the important parameter for controlling inventory. For example, number, location, size
etc. In addition to this, there is production schedule must be design which includes cycle
management that ensure new products for successful integration into the chain (Nag, Han
and Yao, 2014). It is also known as transportation strategy of Dr William Moulton
Marston.
 Information management: In this step, potential level of the end users and customer
demand must be determined in systematic aspect. Therefore, daily production system
must be developed with distribution of the plans. Hence, it creates resources availability
and utilisation of the strategy. With the help of key elements' information successful
chain can be develops in systematic way. Therefore, potential level of the end user and
customer demand must be develop in systematic way. Further, resources availability and
utilisation also developed in the systematic aspect that create proper functioning for Dr
William Moulton Marston. In this way, computing business will be develop for attain
overall profits and revenue (Kumar, Dass and Kumar, 2015).
 Fund management: Fund management is the another important parameter in which
work need to be accomplish with sufficient information. All needs to be ensure with
bottlenecks that can be avoided and supply will be sustained. In addition to this, Dr
William Moulton Marston require trust on each person so that chain can be developed in
systematic way. As results, it assists to make sure that profitability will be undertake in
systematic way.
 Importance of information technology: Information technology is the important
parameter that helps to set targets and accomplish the role in providing, managing and
interrogating information management which take important part for supply chain
management. There are several areas needed with consideration through system will be
developed for e-procurement in the enterprise. Information management also determines
supply chain management areas that require consideration through the effective system.
This element help to Dr William Moulton Marston to save their cost, time, saving, faster
innovations, better marketing with better quality. Therefore, objectives can be develops in
systematic way to accomplish the profits and revenue.
5

 Pull and push strategy: Push and pull strategy also play very important role in
systematic work of the raw material suppliers. It demonstrates connectivity among
manufacturer and distributors those turn for connection to the retailer and the end
customers as well. In addition to this, customers are also important source of the profit
which develop chain of the push model in systematic way. With the help of driven on the
e-commerce capabilities, clients are empowered (Sutherland, 2014). Therefore, many
companies need to move from the traditional push business model in which marketers
determines high power. With the help of new business opportunities, less product centric
develop with electronic connection. Hence, it will be profitable to make sure targets and
goals will be develop that are beneficial for customers and manufacturer as well.
 E-procurement: E-procurement is the another important aspect that using to covers all
relevant activities. It is the important term that identifying for gaining authority to acquire
them. Finding the suitable suppliers. In addition to this, supplier also needed to choose so
that organisation issues could be resolved in systematic aspect. With the help of
identifying the items, gaining authority could be ascertain to make sure that suitable
suppliers. In this aspect, Dr William Moulton Marston need to choose the best supplier
from various alternative. In this way, they are agreed for the price on which range of
prices depending on the volume (Nag, Han and Yao, 2014). They can also order to goods
with the chosen suppliers, checking goods as the order that need to be done in systematic
way. Checking also needed to the goods that recorded for fixed assets register as
appropriate.
Dealing with intermediaries: In respect to deal with final step, the organisation need to make
their contacts with intermediaries and manufacturer. In this way, they have to involve selling to
the distributors. They can also turn towards the retailer and operations. E-commerce can also
lead to disintermediation. It is the important aspect in which outcomes will be accomplish in
computing business. In this aspect, Dr William Moulton Marston need to implement their targets
and outcomes with taking advise from the measurement of the results. In addition to this, supply
chain management also useful to focus on the relationship for ascertain effective functioning in
systematic aspect.
6

Illustration 2: Supply chain management
Source: (GE embraces social media for supply chain management and business process
improvement, 2017).
Section 2 Differentiating between database management system and an enterprise resource
planning system
There various difference between data base management and resource planning system.
These are:
Enterprise resource planning system refers to the set of organisation software tools
designed to facilitate the smooth flow of information between all department of function within
enterprise. It integrates information from entire company. On the other hand data base
management system is a computer software that provides interface between database.
Data base management system is a innovative and effective way that can be used by
organisation for interacting and abstracting information from various sources. Whereas, resource
planning system can be the innovative way for managing and allocating resources from various
sources.
Data base management consist of only data base. On the hand resource planning system
include both use of application plus database.
7

Enterprise resource planning is a global term designed for managing various business
resources. It helps business unit in effective utilisation of resources. Whereas Data base
management system business in maintaining information. It enables firm to retain information
for longer period.
Data base mangemnt system focuses on designing and mangling database. On the other
hand Enterprise resource planning intends to design and mange various products.
The resource planning system is more beneficial for organisation as compared to database
management system as it focuses on all important processes across all departments of business
unit. It maintains automatic workflow from one department to another. It ensures smooth
transition and quicker completion of process, Advanced e-commerce integration is possible with
enterprise resource planing system (Kavanagh and Johnson, eds., 2017)
Core Enterprise Resource Planning system component
Core Enterprise planning system refers to the traditional element that includes most of
ERP system. They emphasize on internal operation.
The five main component of enterprise resource planning system are :
 Financial accounting- It has focus on analysing the revenue, profit and sales. This
component covers all accounts and taxation level in order to integrate and evaluate
various figures. This figures can be used by organisation for producing various reports
and retaining information for future use.
 Manufacture and Distribution-It provides business unit with the data related to demand
and supply. By aggregating this information the business unit can analyse the availability
and shortage of stock. Using this component company can easily identify the requirement
of various resources in the future.
 Customer relationship management-This tool help organisation in gaining feedback from
customers and analysing their perception about the enterprise.
 Stock and sales figure-It is the important component of Enterprise resource planning
system. It provides data related to sales and stock. It provides automatic update on
available resources (Liu, Gong, Zhou and Huang, 2017)
Components of Extended Resource Planning system
8