Database Interrogation Using Conjunctive Queries

Added on - 06 Jan 2021

  • 27

    pages

  • 3409

    Words

  • 13

    Views

  • 0

    Downloads

Showing pages 1 to 6 of 27 pages
Database interrogation
Table of ContentsINTRODUCTION...........................................................................................................................3TASK 1............................................................................................................................................3Understand the specific role of information system strategy in the organization.......................3List the integration with the overall organization strategy..........................................................4TASK 2.........................................................................................................................................13Create database tables:.............................................................................................................13Doctor_table:.............................................................................................................................14Medicine_table:.........................................................................................................................16Relational database diagram-...................................................................................................17CONCLUSION..............................................................................................................................25REFERENCES..............................................................................................................................26
INTRODUCTIONDatabase interrogation is a process that collect the information and data in the form ofdatabase system. It is a method for delete, modify and retrieve the data of Queens Marryhospital. This report will discuss about the Queen Marry Doctors Surgery that provide the bestquality 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 theappointment to their website. This assignment will describe the different role of informationsystem 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 effectiveways. At last task, it will create and design database of Queens Marry Doctor's surgery to collectthe information of patients and doctors etc. this report will design and implementation ofrelational database system and also converting into the entity relationship diagrams.TASK 1Understand the specific role of information system strategy in the organizationInformation system is an important part of organization to manage the data in the form ofdatabase system. Any small or big companies used the strategy to collect the information fromdifferent places. It can process, store and share data from one place to another. Moderntechnology is beneficial for organization to increase the efficiency and speed of enterprisesprocess all over the world (Wang, Meng and Zhang, 2017). Information system is playingimportant role in the organization for processing the data and take right decision. This processwill impact on the overall performance, revenue in the organization. Information system isusually set of component that work together to manage the entire data processing system andstorage. This is playing important to support to the managing and controlling the organization.Information system can be included the different combination of hardware, software andtelecommunication network to provide the best facilities to gain the better understanding ortarget to the audience in marketplace (Andersen and et.al., 2015). Modern information systemused the Queens Marry hospital centre where staff members access the large amount of data byusing 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 andalso taking the correct decision with the help of reports, It provides the efficient resourceallocations.This firm used the enterprises resources planning to manage and analyse the data fromdifferent areas and manufacturing to accounts and finance. It is the fastest servicesprovided to their patient in the hospital centre.This service will provide the competitive advantages and increase the business processacross the world. It makes faster and easier in the enterprises decisions.In the organization, management is playing important part of organization to manage theinternal 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 toanother.Information system offering the effective and efficient information that allows tooperated the entire company's functions in proper ways.List the integration with the overall organization strategyBusiness integration strategies is a based on the organization to manage their task andoperations of employees. It is required for organization to reduce the ineffective communicationbetween the management and employee. In Queens Marry centre, It will use the integrate processto save the time of organization and money. Integration process always help for operates theentire business process effectively and efficiently. There are different types of integrationstrategy applicable in the business process.Personnel integration-The management team and staff members of queens marryhospital are playing important role in the entire firms to manage the business operationsand task in effective manner (Coronel and Morris, 2016). It becomes more essential fortake more time to integrate with the employee as well as patients. According to queensmarry centre, The manager plays effective role to provide all necessary requirement ofdifferent departments and works in the conjunction of the firm. The another logisticsmanager 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 staffmember are integrated in the organization to provide the best facilities and services totheir patient.Vertical integration-This process is mainly concern about the one or two parts ofsupply 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 organizationto update the information which is good for customers to check the availability of roomsand appointments (Holliday and et.al., 2017). The main purpose of vertical integration isto control the overall quality and the cost of services. This process will go outside ofcompany and can be expensive to their administers.Data integration-This process is mainly focused on the new system to remove oldstrategy in the organization. The firms can be merge with the another computer networkto increase the performance, speed and efficiency etc. the official website provide thebenefits for the user that directly interact with the website. Sometimes, Data integration istime consuming process that cannot planner according to need and requirement ofbusiness process (Wang, Meng and Zhang, 2017). In this way, in efficient dataintegration process cause the communication and interaction between the variousdepartment of organization can be slow down. For Example- of two organization mergethat 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 overalltransaction in the enterprises that's why, it is an essential for planning the data integrationprocess 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 designfeatures of website of Queens Mary hospital.Web Content-It refers to the part of website that contain images, forms and multi mediaconcept as well as code, scripts and other applications.User agents-It will use the software that easily access the web content that including thedifferent and specified voice browsers desktop graphical browser and mobile phone
browsers etc. These are the important criteria that applicable in the designing for websiteeffectively and efficiently (Wang, Meng and Zhang, 2017).Authoring tools-Various type of services and software useful for designing the websitetherefore, Many people can use this technology to check the availability and produce webcontent includes blogs, document conversion tools, database scripts and contentmanagement systems etc.According to my design pattern, I always remember the content and provide the content forvisitors to easily check the information and details of particular appointment with the doctors andmany more. There are some important patterns I always used in the website so that more patientand visitors attracts towards:Colour used in the website in attractive and suitable according to the hospital and cliniccentre, In the website, it contains lot of information related the clinic centre.It used the default background and foreground colour combination that provide the propercontrast 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 thepossible results.User can be pause, adjust and stop the volumes according to the requirement and thatplaced in the website. This video is provided the information of hospital and variousspecialist doctor etc.The back ground music is low and can turned off, It also avoids the distraction andinterferences.User interface and navigation-I can develop an effective website of hospital system to provide the easy navigation for thevisitors. Many people do not use the mouse and keyboard to interact with the web tools. It isnecessary for user to access the operations and functionality such as input, output, form controlsand components etc.All the functionality is provided by the mouse to choose the option and also click on it.
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document