Distributed Information System Medical Lab Service Information Technology Essay

Distributed Information System medical examination testing ground go Information Technology EssayOnline booking transcription has become a common trend now days in business organisations. With the coming of the internet everything is just a click away.As the cliquish medical c be service provider began its quest for the outgrowth of a laboratory test, diagnoses and treatment services that would be white plagued to serve over blow outlets across the UK, it becomes every web stimulateer responsibility to deal with the ch wholeenges and this challenge still goes on. As developer took on the task, it created a platform for other and its from those existing constitution that refreshful development are based.The distributed health rush strategy should be knowing in a way that guarantees the security of the intentionrs data and it should be designed in the to the highest degree substance abuser friendly way possible, putting in consideration all the accessibility requirement s.1. IntroductionInformation Technology has created a recent surface knowledge do main(prenominal) for business to excel. It has opened many horizons for companies which are looking for better ways to impress their customers. Not only that it has given many options to the firms and helps them in their daily practise tasks. No wonder it is playing a vital role in development of the firm. Research and fuck offment for any firm is very important for future. permit it be long term planning or short term I.T has helped in many ways for example minimising risks, calculating costs, estimating future trends and so on.1.2-Tier computer architectureTechnology is dynamic as it changes day by day making business world easier to survive with excellent management. 3-Tier Architecture is one of the modern engineering science three way interactions in client / innkeeper environment. This architecture was generated to overcome the problems of 2-tier architecture.This consists of three essenti al components as shown in the figure.Fig 3-tier Architecture(Source www.cardisoft.eu//3_tier_architecture.jpg, ingressed on 04/06/2011) node TierThis is the layer where the users interact with the formation. So this is the user interface which is stored in client boniface. This layer sends the data to employment boniface and gets the prove back from there.An exercise TierThis server consist of two layers i.e. line of work layer and data access layer. This is the main layer which process the data received from client server and also interacts with database server.Data TierAll the data are stored in database server which can be retrieve at any time. This layer takes the require from application server and gives the required data back.2. OverviewThe vast development and empowering of todays knowledge in all sectors of our modern life is improving satisfaction, comfort and reliability. There are remark suit fitting effects entering in our medical service sector that make the pa tients and doctors tellingship much satisfactory and exciting. However, patients and Medical care Service lots struggle with disagreeing views about the Laboratory testing system and adoption of proper communication and appointment procedures. Patients look for technological advances to improve the quality and outcomes of medical care system.In new developed system, with the help of emerging web techniques and technologies the Medical Care Service turn into a great improvement by trim early days delay and difficulty. In the online system, Administrative faculty can track patients, staff and can book appointment for patient. Doctors will be able to access patient learning, their medical history and would be able to arrange for lab testing laboratory staff member will be able to track only sample which is belonged with a patient.2.1 Scope of get off.The main aim of the frame is to create a patients test booking system and manage doctors and staff member exposit that is more streamlined and easy to use for all. The disgorge also aims at ensuring reliability in the medical booking systems so that in the near future the members of the public as well as the health workers find communication between the two parties easy and secure and time saving. By secure we mean a reasonable level of data protection.2.2 Aims and objective.In devote to hit the set target for this aim aims and objectives were set and this includedDevelop a login facility to access details and information easily.Create an online interactive system between patients and Health Care Provider for quicker response (such as fixing online appointment).To design UML Deployment diagram of the system architectureTo design implement Case Diagram of the systemTo design ERD of the backend databaseTo design Class Diagram of the systemTo implement the 3-tier Architecture and design the prototypes2.3 Purpose of the ProjectAfter this project, Medical Care Service will have a efficient appointment system for their patients. Following are the advantages in implementing 3-tier Architecture.Development IssuesComplex application rules are easy to implement in application server.Business logic off-loaded from database server and client, which makes feat excellent.Changes to business logic automatically requested by server changes require only new application server software to be installed. natural covering server logic is suitable to other database server platforms by virtue of the application software.Performance3-Tier Architecture gives superior performance for medium to high volume environments2. Business Key Requirement AnalysisThe main requirement for Medical care Service provider is to overcome with the problem of Traditional database system. So the aim of the project is to develop Web Base applications and implement 3-tier architecture system.There are three signalize interfaces with contrastive functions for incompatible users.AdministratorAdministrator canLogin to the sys tem using login form.Track PatientsEnter Staff InformationBook Appointment for PatientsDoctorsDoctors canLogin the system.Access Patients InformationAccess Patients Medical historyArrange for Lab testingLaboratory StaffLogin the systemTrack Sample (Associated with Patients)3. Model Used for System DevelopmentThere are different types of methodology for the development of system such as Waterfall Model, Spiral Model, Prototyping Model, and Rapid Application Development. Among them Prototyping Model was selected for the purposed system.3.1 Prototyping ModelIn this model, the problems of the existing system are defined. The requirements are control down into different parts. For each requirement different prototypes are designed and tested separately. If the systems do not give the expected output, then again different actions are taken to construct the system.4. Feasibility StudyThe study involves a complete research for the project it looks at some of the features that could be tran slated into reality. This stage helps project developers to know accurately they can deal with the process. It is therefore a critical phase which requires a detailed study be carried out. Feasibility study is the initial study undertaken in the lead the actual project begins to highlight the possibility of the project success. It is an analysis of possible options and solutions to problems and provides suggestions on the best alternative.4.1 Technical FeasibilityThe project Medical Care Service runs on any windows system as well as in World Wide Web. Many organizations use the web server because it is a common and very user-friendly interface to develop ASP.net enabled programs in the Internet. The necessary technologies geted to run this project are available without any new software to be installed. The software ASP.net and Microsoft Access which is commonly available and widely popular software existing in the market. It comes with features to access the Internet in an efficie nt approach. Thus, by using this all the modules are able to perform the tasks required. The task is to produce a product that reflects the user mind.4.2 Operational FeasibilityOperational feasibleness is the evaluate of how well the explanation of problems will work in the organisation and also determine how people feel about the system project. In this area particularly, problems within the login areas and security validations that were sighted, A project is therefore said to be operationally feasible if it achieves the needs and expectations of end users. User acceptance is a tell apart determinant of operational feasibility. This project does not require any special memory or enhanced features in the system in order to run. preferably it will consume less memory and will operate efficiently even under normal speed.4.3 Economic FeasibilityEconomic feasibility is the measure of the cost-effectiveness of an information system solution. Regarding economic feasibility, the project is a less expensive one. As a whole, the project does not demand any special feature. It makes use of the available resources and provides a better performance in convinced areas.5. Languages Used for System DevelopmentIn this phase, the required hardware, software and people required for the project are selected. The following software is employ for designing.5.1 Microsoft Visual Studio 2008 (ASP.net)Microsoft visual studio is an integrated development environment (IDE) from Microsoft which can be apply to develop console and graphical user interface applications along with Windows Forms applications, web sites, web applications, and web services.Visual Studio 2008 was upgraded to support all the new features introduced in .NET poser 2.0, including generics and ASP.NET 2.0. The IntelliSense feature in Visual Studio was upgraded for generics and new project types were added to support ASP.NET web services. Visual Studio 2005 also includes a local web server, separate from IIS th at can be used to host ASP.NET applications during development and testing. It also supports all SQL Server 2005 databases. Other new features of Visual Studio 2005 include the Deployment Designer which allows application designs to be validated before deployments, an improved environment for web publishing when combined with ASP.NET 2.0 and load testing to see application performance under confused sorts of user loads.This is used in this project for the presentation tier to design the interfaces for window applications.5.2 VB.NETVisual Basic .NET (VB.NET) is an object-oriented computer programming language that can be viewed as an evolution of Microsofts Visual Basic (VB) which is generally implemented on the Microsoft .NET Framework. Microsoft currently supplies Visual Basic Express Edition free of charge.This language is used for coding of the main functions and process in this project. This is used for the presentation tier.5.3 UML DiagramsUML stands for Unified Modelling Lang uage which is used in the business logic layer in middle tier of 3-tier Architecture. This is specially designed for developers to see the system in different perspective view. There are different types of UML Diagrams such as use case diagram, social class diagram, sequence diagram, deployment diagram. Among them following UML Diagrams are used for this project.Use Case diagram to show how the users interact with systemClass Diagram forms class structure and hearts using design elements such as classes, packages and objects. It also displays relationships such as containment, inheritance, associations, generalization, etc.Deployment Diagram to show the interaction between the components that is relation between hardware and software. This diagram shows the physical architecture of the system.5.4 MS Access 2007MS Access is the database application for Windows, included in Microsoft Office suite which is used to store the data in tables form.MS Access offers many templates which ma kes easy to use. Many big and small organizations use this software for database server in order to store the data in standard tabulation form and retrieve as required.In this project, this program is used to store the data in the database server.6. intention the SystemThe purpose of design phase is to transform the business requirements statement from the requirements analysis phase into design specifications for construction. For this purpose, design phase encompasses following tasksDesign the Application ArchitectureDesign the System DatabaseDesign System Interface6.1 Design the Application ArchitectureFor the design of system architecture the UML diagrams such as Use Case Diagram, UML Deployment Diagram and Class Diagrams are used.6.2 System Architecture DesignClientsIIS5.0ServerBusiness LogicComponentsVB .netLibraryData Access viaADO.NETMiddleTierCLRMCSDatabaseMs Access2007 ServerASP.NET7. Use Case Diagram for Medical Lab Service8. Design the System DatabaseTo design the datab ase of the system, the E-R diagram is prepared at first. Then, the database structure is prepared in the MS Access.8.1 Entity Relationship DiagramERD stands for Entity Relationship Diagram.It is one of the most important analysis diagrams for designing a database which summarise the whole structure of database.In relational databases, the data is split up into tables instead of writing it all out in a single line or record.This removes some of the problems often encountered in building a database.The tables are linked together bythe primary key of one table being present as what is called a foreign key in another table.For National Car separate Retail, the database system main content followingAdminLoginBranchDoctors expandPatientDetailsPatientVisitDetailReportStatusStaffDetailsERD DiagramStaffDesignationStaffGenderLoginuserNameIdPasswordTypecreateDatePatientsPatientNamePatientIdMaritalStatusPatientDOBPatientHistoryPatientAddressPatientPhone runnelTypePatientGenderPatientBookingDate StaffDOBBranchFaxBranchPhonedressBranchNameHasBranchIdBranchHasVisitDetailPatientvisitIDDoctorsIdTestDatePatientIdArrange TestDoctorDetailsDoctorsNameDoctorsIdDoctorsGenderDoctorsAddressDoctorsSpecialDoctorsPhoneBookingHasStaffPhoneIdStaffAddressStaffIdStaffNameStaff Detailspostal codeBranchAddressThe above diagram is entity relationship diagram for Medical Lab Service explaining the relationship between the entities and their attributes. The attributes shown in the diagram are their primary keys.9. Database StructureThe database was designed using MS Access with the name Medical.mdbList of the various tables and their descriptions are as followsS. No.Table NameDescription1AdminLogin entrepot Login information2BranchStore Medical Lab Branches details3DoctorsDetailsStore Doctors information4PatientDetailsStore Patients booking details5PatientVisitDetailStore Patients Visit Detail For Medical Test6ReportStatusStore Patients Report Status7StaffDetailsStore Lab Staff detailsBelow is the more detail of database structure.Branch TableNameData TypeSizeNulls?Default ValueExtraBranchIdNumberLong IntNoBranchNameText30NoBranchAddressText50NoPostCodeText20NoBranchPhoneText20NoBranchFaxText20For more detail refer to appendix Medical9.1 Design the System InterfaceThis is the Index page of the Web Based system for Medical Lab Service where the user logins and does other processing.This is the Medical Lab Service index page from where user can process further.For more prototypes refer to appendix prototypes10. CodingCoding should be done according to design specifications in order to meet business requirements. VB.NET was used as the server-side script.Including entire code of the system would make the system unnecessarily lengthy. Hence I have included code of some important functionality and presented a brief explanation.11. Implementation and Testing of SystemAs I mentioned before this is the web based application so the other Medical Lab Branch can be accessed this System through internet. When the system gave expected result then it was implemented to the entire branch and old traditional system was completely removed.The list below is the test plan for the system.LoginAdd/Update/ delete Branch Detail (Admin)Add/Update Delete Patients Booking (Admin)Add/Update Delete Doctors Details (Admin)Add/Update Delete Staff Details (Admin)Add/Update Delete Test Arrangement (Doctors)Add/Update Delete Report Details (Lab Staff)Searching from Admin(Branch, Doctors, Patients, Lab Staff)Searching from Doctor (Patients History, Test Details)Searching from Lab Staff (Search Report Status)12. User DocumentationAfter the completion of the whole project the final user document was prepared which content all the information of the system. The user guide was prepared and different training was given to employees of the Medical Lab Service so that they can be beaten(prenominal) with the new system.13. ConclusionThis report is prepared as the System documentation for Web Based Application Designing for a Medical Lab Service.This project provided me with good professional practice in applying our knowledge of Information Systems to address business problems. During this endeavour, I learned to write a suite of programs that encompass the main facets of business computing. I was able to obtain an in-depth knowledge of a formal coding language. I have been able to produce relevant documentation in support of the developed system. With the preparation of the projects, I have learned the efforts time required to prepare a professional system. I gained knowledge about different phases methodology of a project, which supports both the system development operation and support stages of the system life cycle.Hence with the development of this system, I understood the real need and value of having 3-tier Architecture System. I learnt that coding is only small part of system development and that greater effort should be placed in understand the business re quirements. Understanding business need is a challenge and getting application built to suit it is a whole lot another theme by it self14. ReferencesReference BooksJeffrey L. Whitten, Lonnie D. Bentley, Kevin C. Dittman, Systems Analysis and Design Methods, Fifth EditionRoger S. Pressman, Ph.D., Software Engineering A Practitioners Approach, Fifth EditionVisual Studio 2008 paid (ASP.Net)