Database Interrogation Report: Queens Marry Hospital Analysis

This report focuses on database interrogation within the context of Queens Marry Hospital, exploring the role of information system strategy in organizations and its integration with overall business strategies. The report details the benefits of information systems, including improved efficiency and decision-making, and discusses various integration strategies like personnel and data integration. It also analyzes web accessibility considerations for website design, including user interface, navigation, and content presentation. Furthermore, the report covers the creation of database tables (Doctor_table, Medicine_table, Patient_table, and Staff_table) and the development of a relational database diagram (ERD) to manage patient and medical information effectively. The report provides website screenshots and URLs. This report provides a database design and implementation plan for the Queens Marry Hospital.

Database interrogation

Table of Contents
INTRODUCTION...........................................................................................................................3
TASK 1............................................................................................................................................3
Understand the specific role of information system strategy in the organization.......................3
List the integration with the overall organization strategy..........................................................4
TASK 2 .........................................................................................................................................13
Create database tables: .............................................................................................................13
Doctor_table:.............................................................................................................................14
Medicine_table:.........................................................................................................................16
Relational database diagram- ...................................................................................................17
CONCLUSION..............................................................................................................................25
REFERENCES..............................................................................................................................26

INTRODUCTION
Database interrogation is a process that collect the information and data in the form of
database system. It is a method for delete, modify and retrieve the data of Queens Marry
hospital. This report will discuss about the Queen Marry Doctors Surgery that provide the best
quality of services to their patient. A website can be designed to provide the comprehensive,
professional and personal service provided to patient and it easier for directly check the
appointment to their website. This assignment will describe the different role of information
system strategy in the organization and also integration with the overall corporate strategy.
Furthermore, it analyses the apply the different design to create dynamic web pages in effective
ways. At last task, it will create and design database of Queens Marry Doctor's surgery to collect
the information of patients and doctors etc. this report will design and implementation of
relational database system and also converting into the entity relationship diagrams.
TASK 1
Understand the specific role of information system strategy in the organization
Information system is an important part of organization to manage the data in the form of
database system. Any small or big companies used the strategy to collect the information from
different places. It can process, store and share data from one place to another. Modern
technology is beneficial for organization to increase the efficiency and speed of enterprises
process all over the world (Wang, Meng and Zhang, 2017). Information system is playing
important role in the organization for processing the data and take right decision. This process
will impact on the overall performance, revenue in the organization. Information system is
usually set of component that work together to manage the entire data processing system and
storage. This is playing important to support to the managing and controlling the organization.
Information system can be included the different combination of hardware, software and
telecommunication network to provide the best facilities to gain the better understanding or
target to the audience in marketplace (Andersen and et.al., 2015). Modern information system
used the Queens Marry hospital centre where staff members access the large amount of data by
using one platform to collect and gather all information in various sources such as articles,
website, customers etc.

Benefits of information system in the organization-
 This technology allows the faster services and more accurate to manage the report and
also taking the correct decision with the help of reports, It provides the efficient resource
allocations.
 This firm used the enterprises resources planning to manage and analyse the data from
different areas and manufacturing to accounts and finance. It is the fastest services
provided to their patient in the hospital centre.
 This service will provide the competitive advantages and increase the business process
across the world. It makes faster and easier in the enterprises decisions.
 In the organization, management is playing important part of organization to manage the
internal and external business process effectively and efficiently (Coordinators, 2017).
Email technology is a quick and fast method to store the data in the form of documents.
They also used the different communication technology to share data from one part to
another.
 Information system offering the effective and efficient information that allows to
operated the entire company's functions in proper ways.
List the integration with the overall organization strategy
Business integration strategies is a based on the organization to manage their task and
operations of employees. It is required for organization to reduce the ineffective communication
between the management and employee. In Queens Marry centre, It will use the integrate process
to save the time of organization and money. Integration process always help for operates the
entire business process effectively and efficiently. There are different types of integration
strategy applicable in the business process.
 Personnel integration- The management team and staff members of queens marry
hospital are playing important role in the entire firms to manage the business operations
and task in effective manner (Coronel and Morris, 2016). It becomes more essential for
take more time to integrate with the employee as well as patients. According to queens
marry centre, The manager plays effective role to provide all necessary requirement of
different departments and works in the conjunction of the firm. The another logistics
manager can be understand the payable facility and services. In this way, it can handle

the entire business aspects to increase the efficiency of business process. All the staff
member are integrated in the organization to provide the best facilities and services to
their patient.
 Vertical integration- This process is mainly concern about the one or two parts of
supply chain because this process is handle the entire official website or time to time,
update new facility and services on the website. This is the beneficial for the organization
to update the information which is good for customers to check the availability of rooms
and appointments (Holliday and et.al., 2017). The main purpose of vertical integration is
to control the overall quality and the cost of services. This process will go outside of
company and can be expensive to their administers.
 Data integration- This process is mainly focused on the new system to remove old
strategy in the organization. The firms can be merge with the another computer network
to increase the performance, speed and efficiency etc. the official website provide the
benefits for the user that directly interact with the website. Sometimes, Data integration is
time consuming process that cannot planner according to need and requirement of
business process (Wang, Meng and Zhang, 2017). In this way, in efficient data
integration process cause the communication and interaction between the various
department of organization can be slow down. For Example- of two organization merge
that required to integrate with the two billing system to provide the bill services on time
(Krishna and Nagaraju, 2016). It can store the details and information of overall
transaction in the enterprises that's why, it is an essential for planning the data integration
process to mange and control the entire business operations and functions.
Web Accessibility:
Web accessibility is based on the different components that help for managing the entire design
features of website of Queens Mary hospital.
 Web Content- It refers to the part of website that contain images, forms and multi media
concept as well as code, scripts and other applications.
 User agents- It will use the software that easily access the web content that including the
different and specified voice browsers desktop graphical browser and mobile phone

browsers etc. These are the important criteria that applicable in the designing for website
effectively and efficiently (Wang, Meng and Zhang, 2017).
 Authoring tools- Various type of services and software useful for designing the website
therefore, Many people can use this technology to check the availability and produce web
content includes blogs, document conversion tools, database scripts and content
management systems etc.
According to my design pattern, I always remember the content and provide the content for
visitors to easily check the information and details of particular appointment with the doctors and
many more. There are some important patterns I always used in the website so that more patient
and visitors attracts towards:
 Colour used in the website in attractive and suitable according to the hospital and clinic
centre, In the website, it contains lot of information related the clinic centre.
 It used the default background and foreground colour combination that provide the proper
contrast between the website (Marx-Rubiner and et.al., 2017).
 The size of text is resizeable and it will replace to the other actual text. It also avoids the
possible results.
 User can be pause, adjust and stop the volumes according to the requirement and that
placed in the website. This video is provided the information of hospital and various
specialist doctor etc.
 The back ground music is low and can turned off, It also avoids the distraction and
interferences.
User interface and navigation-
I can develop an effective website of hospital system to provide the easy navigation for the
visitors. Many people do not use the mouse and keyboard to interact with the web tools. It is
necessary for user to access the operations and functionality such as input, output, form controls
and components etc.
 All the functionality is provided by the mouse to choose the option and also click on it.

 Key broad provide the facility to add some content on the website while administer has
power to access all the information therefore, they also provide the direction to visitors.
 Authoring tools and web browsers are important platform to manage the entire
functionality of web processing.
It is needed for website designer to maintain the information and also update time to time,
it is an essential because many people spend much time on the website. They also read,
understand and use the content. Many people has more time to understand the proper
instructions, control the operations and complete the task on website.
The website is creates that should available for free internet to access at any place and
anywhere. Queens marry hospital is also used the official website to provide the different types
of facilities to their patient such as online booking, doctor details etc (Panchal, 2017). this is the
best platform and tool to manage the entire details of patient, Sometimes, customer can book the
appointment of particular time according to their suitable and also check the details in proper
ways. There are different types of web pages design in this website such as
 Home page
 Blog page
 The clinic
 Our services
 Insurance page
 contact us page
 Meet the team
 Features pages
 About
These are all the webpages that can be design in the official website to easily finding the results.
Website is the best effective designed pattern that representation in dynamic ways in front of
user (Wang, Meng and Zhang, 2017). Many patient can directly contact with the administrator of
hospital to provide the details on time. There are different pages represented in the followings:
Website Screenshots:
Home page:

Blogs Page:

Website Address- URL : https://xyz12344.wixsite.com/queensmarry