Business Information System Strategy Analysis and Design Report

This report delves into the realm of information system strategy, exploring its crucial role in organizations and its integration with various corporate strategies. It examines the different levels of integration within an organization and analyzes a case study to apply universal design principles to web pages. The report also focuses on the design and implementation of a relational database, including converting an entity-relationship diagram into relational tables, and discusses the mindset and skills necessary for designing and operating an effective information system. Furthermore, it outlines the creation of forms for doctors, patients, and prescriptions, along with the design and creation of reports. The report uses the case study of Queen Mary Hospital and its website to illustrate the concepts discussed.

Business information System

Table of Contents
TASK 1............................................................................................................................................3
Knowledge and understanding the role of information system strategy in the organization and
integration with the different corporate strategy.........................................................................3
Role of information system strategy- .........................................................................................3
Different integration level in the organization strategy- ............................................................4
Ability to analyse the case study and apply the concept of universal design to web pages. ......6
TASK 2..........................................................................................................................................12
Design and implement the relational database for converting entity relationship diagram to
relational tables.........................................................................................................................12
Database system:.......................................................................................................................14
Mind set and skill needed for designs and operate an effective information system to meet the
business need and requirement..................................................................................................18
Create three forms : Doctor, Patient and Prescriptions.............................................................20
Design and create two reports:..................................................................................................23
REFERENCES..............................................................................................................................25

TASK 1
Knowledge and understanding the role of information system strategy in the organization and
integration with the different corporate strategy.
Information system is a type of business process to perform different operations in the
organization to handle the business aspects in effective manner. This system is designed to
collect the process, store and also distribute the informations and details. A computer
information system is a different branch of science to compose the different people and various
types of processes. Information system strategy is mainly developed to perform various functions
and operations. It also useful for deliver the best services to the customers. Strategic information
system strategy can defined the information that help for creating and enhancing the business
competitiveness in the organization (Alles and et.al., 2018). There are different types of
innovative ways applicable the information system strategy in the organization such as QAS,
MIS, ERP etc. There are important platforms and tools that applicable in the business process to
enhance the goals and objectives. The strategy planning is useful for meet the specific goals and
objectives of organization. There are different types of advantages of information system in the
organization.
Modern and advance technology is the most significantly support the entire efficiency
and performance of the business process. This type of process will help for increasing the
productivity and profitability all over the world. Information system strategy can save both time
and money.
Information system is playing important role in the organization such as business
intelligence system can run data into the different valuable insights. This strategy help to allow
for increasing the speed and efficiency. The organization used the enterprise resource planning to
collect, analyse and manage the data in the various areas. Information system strategy is consists
of the multiple application that help for measuring the need and requirement of accounting and
financing.
Role of information system strategy-
It can support the different operations that perform in the organization to manage the entire task
and functions in effective manner. The operational manager is keep track all the activities of
business process such as transactions and elementary activities.

Knowledge level system will support to the organization knowledge and data workers to handle
the functionality of enterprise processes. The information system is provided the different
benefits for organization to being strategic concepts to handle the enterprise business operations
in effective manner (Björklund, Abrahamsson and Johansson, 2017). It provides the clear about
the specific objectives because information system will give the directions about the specific task
and purpose.
This process always aware about the available resources that support to provide for managing the
dynamic environment.
The information system strategic has defined the specific roles discuss followings:
 Strategic Management- It is based on the systematic approach for performing different
operations and also have main responsibilities to manage the position regarding the
organization and its business environment. This management system will help for
organization to compete the task in the industry, It is outdoing process to rival in the
entire industry and firm.
 Strategic Planning- It is a process or method that help for maintaining and developing
the organization therefore, this method will useful in the business to maintain the
consistency in between the objectives and resources. Sometimes, the resources can be
changed according to the need and requirement of firms. The main purpose of strategic
planning to define the documents of approach to lead the business and always increase
profit and growth(Devece, Palacios and Martinez-Simarro, 2017). It is important part of
organization to improve the quality of services in marketplace.
 Strategic Operations- Strategic operation is a process that planning a specific task of the
organization to used the proper resources that support to produce and manufacture the
product and services. An operation strategy is basically driven by entire business
planning to designed the strategy for increasing the production in effective manner. In
this, it can reduce the cost of product in marketplace.
Different integration level in the organization strategy-
Enterprise integration is a process to manage the important aspects of organization. This
type of strategy useful for creating and implementing or evaluation taking the important decision
regarding the organization. It enables to achieve the long and short term goals and objectives. In
Queens Mary hospital, there are various integration process or method operates the functionality

and capability of organization. It is beneficial to save more time and money. The key integrated
strategy can considered in the organization as followings:
 Personnels integration- This integration process is required for queens marry hospital to
manage and control the entire enterprise process all over the world. Each and every staff
members are participated equal role for increasing the brand value in marketplace. It is
an essential part of business where time to time, it will interact with the patient and staff
to identify their need and requirement. This process will help for build an effective
integration with the patient and employees.
 Vertical integration- This process is focused on the one or different part of supply chain
to always maintain their website. This is the best platform of Queens Mary firm to
provide the details to their customer (Kasemsap, 2018). Many people attract towards their
dynamic site to check all necessary details in proper manner. This strategy is mainly used
for organization to gain the control of firms and their value chain. In this way, the cost of
product making is lower than the actual price of buying product. It is beneficial for firm
to control the entire processing of enterprise activities.
 Data integration- Data integration process or method mainly concern about the old one
planning and Strategy that applicable in the business process therefore, in queens marry
hospital, All staff members performs specific task to collect the details of each and every
patient or provide the best quality of services that's why, it is required hospital database
system that help for managing and collecting information in proper manner. Database
management system is the best technique to secure and store the data in the hospital
database. This queens marry clinic is also used the official website to provide all types of
information on the website. In this way, Patient can easily check the details and
availability of appointments. This website give all the data related the clinic , doctor
specialist etc.

Ability to analyse the case study and apply the concept of universal design to web pages.
Web page is concept that applicable for designing the dynamic website effectively and
efficiently. It is a process for creating plan or originating the different development of specific
product and services. According to case study, It can be explain the Queens Mary website which
is based on the dynamic and static web pages that provide the information to the customer and
peoples (Kavanagh and Johnson, 2017). Web page design refers the process of creating an
effective pages appearances and choose the layout, colour format, fonts and schema according to
the need of website. Each and every single web page contain the various type of content but the
pages are using different types of graphics design that looks more attractive.
Queens Mary hospital used the different template that contain the all type of elements in
the web design such as CSS style, back ground colours, buttons, borders and also consist of
graphics elements images, banner and bullets etc. Queens Mary website have own and specific
design elements that needed because it provides the different content and basic style which
applicable in the development of web pages. According to Queens Mary website, It will create
different pages that consist of various content on it. There are different types of web pages
included as followings:
 Home Page
 Online Booking appointment
 Blogs
 Services
 Team
 Contact
 Insurance
 FAQ
 About
 Quote
These are different types of web pages exists in the official website to mention of details
and information related the doctor, hospitals, booking, patient details, staff members etc. This

organization provide the facility to the people to book the appointment by using online mode.
This is the efficient technique to solve the problem and issue to their patient and other peoples.
This website is beneficial for the Queens Mary hospital to increase the demand in the
marketplace therefore, it will increase the market share and values. There are important
advantage of website for the business process of Queens Mary doctor's.
 Advertising- An official website is an effective and environmental friendly for the
purpose of marketing and promotions. There are different ways to promote the service by
using the internet. Queen Mary firm is also used this concept to promote their different
services in the marketplace. In this way, many people understand their best services and
also used them (Land, 2018). In the website, it also used the SEO plan to boost their
services because this plan will help for maintains the ranking of website in quickly as a
result to increase the profit and sales in the marketplace.
 Customer satisfaction- A website is more convenient for the people because it is easy
platform to check the availability of services and also check the entire details of particular
doctor's appointments. In this way, this website is useful for save the money or time. It is
provided the better experience to the peoples.
 Increase sales/ people- Website is the best platform for organization to increase the large
number of visitors check the site and increase the more lead in their sales. Queens Mary
firm always try to update and manage in proper manner. This is essential for firm to
provide the latest details. It is a process that consistently promote and update the content
on the site because an effective and more content help for increase the profitability in
global market.
 Accessibility- A website is the best tool and platform that access at any time and place
that' why, it is very reliable and accessible. It can be available all the time therefore,
people can access the website in mid night and check the details. It is a worldwide
process that provide the details all over the world. It only used the internet services to
offer in the various community in global ways. In this way, The Queens Mary firm
expand the business services all over the world. This organization always maintain their
services in proper manner to provide the more accessibility for the peoples.

Website screenshot:
Home Page:

Our Services:

Blogs Page:

Quotes Page:
In this business, there are different types of facilities and services provided to their
customers and patient. It also checks the availability of appointment of doctor on the website. I
can create website by using www.wix.com so that you can choose the login option to add the
username and password.
Steps: 1
Open www.wix.com
Step: 2
choose Sign in option
Step: 3
Add username : [e-mail]
Password: xyz@123

Step : 4
Choose the first website- http://xyz12344.wixsite.com/marry
Website Address: URL- https://xyz12344.wixsite.com/marry/about-2
New website Link: - https://queenmary123.weebly.com/