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

TASK 2
Create database tables:
A database table is a collection of different data and information that structured in the proper
formats in the database system. In relational database, table is main part of database that contain
the set of data elements that has some specific value stored in the form of database management
system. A table has large number of column and also have some rows. There are tow important
key useful in the database table that create relationship between one or more tables in proper
ways.
Primary Key-
 Primary key is based on the unique identification key that can stored in the table.
 It cannot be contain the null values in the table.
 Primary key is a process that consist the clustered index whereas database tables are
physically existed in the form of rows and columns.
 In database table, it contains only one primary key that establish relations in the another
tables.
Foreign Key-
 Foreign key is basically field in the database table that shows as foreign key in another
table. It can say that one primary is one table shows the one foreign key into another
tables.
 This key will be accepts the various or multiple null values in the tables.
 Foreign key cannot create index automatically, non- clustered and clustered. It is required
for manually create an index on the foreign key.
 In the database table, it has more than one foreign keys in the tables.

Doctor_table:

Patient_table:

Medicine_table:
Staff_table:

Relational database diagram-
Entity relationship diagram is a type of flow charts that representation of different entities
that has specific attributes. Entity relationship diagram is most suitable design and debug the
relationship between the different fields of business information system, software engineering
and education or research etc. It can define the different set of symbol like diamond, oval,
rectangles and connecting lines etc. Entities and attributes are represented according to the
specified structure. This symbol will help for interconnected between the entities and
relationship to their attributes, In this figure, There are different entities exists and having the
specified attributes mention.
Entity- It is based on the definable things that applicable in the relationship diagram such as
object, event, person and concept that collect the data in the database system.
Attribute- It is a type of characteristic and property of entity that representation of objects and
their specific features. It can be divided into different ways such as simple, composite and
derived etc.
Entity:
 Doctor_table

Attributes:
 doctor_id
 doctor_name
 doctor_phone no
 doctor_Email
 doctor_address
Entity:
 Prescriptions
Attributes:
 Medicine_name
 Medicine_ quantity
 Medicine_ type
 Medicine_ time
 doctor_id
Entity:
 Staff
Attributes:
 Staff_id
 Staff_name
 Staff_email
 Staff_phone no
 Patient_id
Entity:
 Patient
Attributes:
 Patient_id
 Patient_name
 Patient_DOB
 Patient_gender
 Patient_email id
 Patient_phone no.

Use the entity relationship diagram-
Entity relationship diagram is basically used for the business process to collect all the
important details and information in the form of database system. Entity relationship diagram is
applicable in the business process to manage and collect all the information represented in the
form of diagrams.
 Database design- Entity relationship diagram can be used in the model and design the
relational database. It follows the business rules and logics in the terms of specified
modern technology that implemented. In the term of software, This diagram is used in the
initial stage to identify the need and requirement of information system. On the other
hand, it also used for particular database (Terrapon and et.al., 2017). Relational database
system is based on the tables and expressed the need and requirement of business
process.
 Database information system- Entity relationship diagram is basically analyse the
relational database that applicable in the business process. Each and every business
needed to use the different entities, action and interplay to create an effective and
dynamic database system in proper manner. It is based on the streamline processes to
uncover the information which are more easily improve and generate the results and
outcomes.
 Database trouble shooting- Entity relationship diagram mainly used for analysing the
existing database system to identify the problem and issues in the logic and deployment.
 Business process and re-engineering- this relationship diagram is applicable in the
business process for analysing the database that used in the re-engineering. It also
modelling the new database setup for achieving the goals and objectives.
 Education- Database is useful in the purpose of education to store the relational
information that help for providing the facilities to institutes and colleges therefore, it
always maintains the each and every record of student in proper manner (Wang, Meng
and Zhang, 2017). Entity relationship diagram is valuable for planing the structure of
entire data.
 Research- Research is the most efficient process that mainly focus on the data structure
to collect all information and represented in the form of ER diagrams. It is playing
important role that useful for analysing the data effectively and efficiently.

Queens Mary Doctor's Surgery vision that create database to manage the details of
patient, staff, staff members in the hospital. The database system is provided the better facilities
and services for collecting all the information and details. Staff member can used the hospital
database to check the daily appointment of patient because it is necessary part to maintain the
patient details (Wang, Meng and Zhang, 2017)). The main vision of Queens Mary database that
allows storing the information of staff to the administer.
Database should be combine with fully functionality, user friendly and reliability. It is
required for managing the business operations and tasks that performed by the staff members.
Database system is provided for data to patients regarding the allergies, medicine, appointment,
doctor specialist etc. All the necessary information can be stored in the database system.
Forms:
Doctor-

Patient:

Prescriptions-

Reports: 1

Report : 2

CONCLUSION
As per discussion, it concluded that Database interrogation method is basically used for
collecting 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. 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. This report discuss about the Queen Marry Doctors Surgery that provide the best
quality of services to their patient. Furthermore, it analyses the apply the different design to
create dynamic web pages in effective ways. It summarized to create and design database of
Queens Marry Doctor's surgery to collect the information of patients and doctors etc. this report
design and implementation of relational database system and also converting into the entity
relationship diagrams.

REFERENCES
Books and Journals:
Andersen, M.P and et.al., 2015, November. DISTIL: Design and implementation of a scalable
synchrophasor data processing system. In Smart Grid Communications
(SmartGridComm), 2015 IEEE International Conference on (pp. 271-277). IEEE.
Coordinators, N.R., 2017. Database resources of the national center for biotechnology
information. Nucleic acids research, 45(Database issue), p.D12.
Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management.
Cengage Learning.
Holliday, G.L and et.al., 2017. Biocuration in the structure–function linkage database: the
anatomy of a superfamily. Database, 2017(1).
Krishna, G.M. and Nagaraju, S., 2016, August. Design and implementation of short message
service (SMS) based blood bank. In Inventive Computation Technologies (ICICT),
International Conference on (Vol. 2, pp. 1-4). IEEE.
Marx-Rubiner, L and et.al., 2017. A patient driven cancer database to collect information,
analyze data, and predict outcomes.
Panchal, J., 2017. Virtual Reality enhanced user experience for scientific data collection using
Mobile Device.
Terrapon, N and et.al., 2017. PULDB: the expanded database of Polysaccharide Utilization
Loci. Nucleic acids research, 46(D1), pp.D677-D683.
Wang, X., Meng, J. and Zhang, Y., 2017. Design and Implementation of Housing Intermediary
Enterprises Management System. DEStech Transactions on Engineering and Technology
Research, (apetc).