Featured 1
Curabitur et lectus vitae purus tincidunt laoreet sit amet ac ipsum. Proin tincidunt mattis nisi a scelerisque. Aliquam placerat dapibus eros non ullamcorper. Integer interdum ullamcorper venenatis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.
Featured 2
Curabitur et lectus vitae purus tincidunt laoreet sit amet ac ipsum. Proin tincidunt mattis nisi a scelerisque. Aliquam placerat dapibus eros non ullamcorper. Integer interdum ullamcorper venenatis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.
Featured 3
Curabitur et lectus vitae purus tincidunt laoreet sit amet ac ipsum. Proin tincidunt mattis nisi a scelerisque. Aliquam placerat dapibus eros non ullamcorper. Integer interdum ullamcorper venenatis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.
Featured 4
Curabitur et lectus vitae purus tincidunt laoreet sit amet ac ipsum. Proin tincidunt mattis nisi a scelerisque. Aliquam placerat dapibus eros non ullamcorper. Integer interdum ullamcorper venenatis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.
Featured 5
Curabitur et lectus vitae purus tincidunt laoreet sit amet ac ipsum. Proin tincidunt mattis nisi a scelerisque. Aliquam placerat dapibus eros non ullamcorper. Integer interdum ullamcorper venenatis. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.
Tuesday, February 5, 2013
Asia political
Friday, February 1, 2013
Fourth Generation Computer Languages
Using SQL you can retrieve data from a database in different formats for various conditions just by specifying the headings you need, where they are stored (tables), and the conditions.
Fig 4.3 compares the differences when instructing a computer using SQL and Visual Basic (Third Generation Language) to retrieve data from a database. The example prints a list of students who have obtained an Avg above 75 from a database. In the Visual Basic example you are required to write all the details on how the data should be retrieved. In the SQL example only the requirements need to be specified.
Thursday, January 31, 2013
Third Generation Computer Languages
High Level languages are relatively easy for people to learn and to program computers. Fig 4.2, shows examples of four programs written in diffe rent high level programming languages which display the message “Hello World” on the computer screen.
If you knew how to speak in Japanese, that would be the best way to carryout your speech. But if you knew English couldn’t you still made the speech? You could by getting help of a translator who is conversant in both Japanese and English. This is exactly how things work in a computer. A translator is used to translate instructions given in a high level language into machine code.
Coming back to the earlier example you could use two approaches to conduct your speech. One way to carry out your speech is for you to speak a few sentences in English and pause allowing the translator to repeat what you have said in Japanese. The second approach is that you could prepare your speech before hand and give awritten copy of it to the translator. You could conduct your speech completely in English. Your Japanese friends would not understand anything you say, but would probably patiently wait till you finish. After you have finished the translator could now repeat your entire speech in Japanese.
These two approaches are used by computers to translate high level language programs to machine. Translator software which uses the first approach are called Interpreters and the latter are known as compilers.
An Interpreter converts a program written in a high level language to machine code as follows.
1. Interpret the next high level language instruction to machine code
2. Execute translated machine code instruction
3. Goto 1st step
the executable file. i.e. by typing the name of the executable file in the command prompt or by selecting the executable using the Windows Task Bar Run command.
There are some high level languages which are special purpose. These languages are intended for writing specific types of programs only. For example COBOL was a language that was used for developing Business type applications. Fortran is used to developing scientific, engineering types of applications. Most of the languages that are used in the software industry fall into the Third Generation Computer Language category..
Wednesday, January 30, 2013
Introduction to Programming
Tuesday, January 29, 2013
Problems in Systems Development
- Estimating cost and time: “What is the best way to estimate the cost and time required by a project?”
- Selecting a project team: “What members must be included in a project team? What type of background and skills are required?”
- Capturing user requirements: “What is the best method to capture user requirements? How to ensure that all requirements are captured? How to ensure that the accuracy of the requirements (that is, requirements captured meets the goals of users)?”
- Using standards: There are many standards and methodologies proposed for system development (such as SDLC). “Which standard/methodology should be used for the project?”
- Choosing design approaches: There may be many design alternatives for a problem. “How do we ensure that the best design choice is made?”
- Coding programs: There are many different programming languages, tools and programming methodologies to develop programs. “How do we ensure that the right tools and languages are used?”
- Testing programs: Programs if incorrectly written can cause errors (sometimes also called “bugs”). “How do we minimize errors in programs? What is the best way to test programs?”
- Maintaining systems: “What is the best way to ensure that the systems are maintained till the end of their life cycle?”
It has been shown that as an organisation’s standard information system development process matures, project delays and costs decrease while productivity and quality increases. The Software Engineering Institute at Carnegie Mellon University (USA) has observed and measured this phenomenon and developed a framework, called the Capability Maturity Model (CMM), to assist all organisations to achieve these
benefits.
The Capability Maturity Model (CMM) is a framework to assess the maturity level of an organisation’s information systems development and management processes and products. It consists of five levels of development maturity.
- Level 1 – Initial: This is sometimes called anarchy or chaos. System development projects follow no prescribed process. Each developer uses his or her own tools and methods. Success or failure is usually a function of the skill and experience of the project team. The process is unpredictable and not repeatable. A project typically encounters many crises and is frequently over budget and behind schedule. Documentation is sporadic or not consistent from project to project and causes problems for those who maintain the system over the life cycle. Almost all organisation start at Level 1.
- Level 2 – Repeatable: Project management processes and practices have been established to track project costs, schedules and functionality. The focus is on project management, not systems development. A systems development process is always followed, but it may vary from project to project. Success or failure is still a function of the skill and experience of the project team; however, a concerted effort is made to repeat earlier project successes.
- Level 3 – Defined: A standard system development process has been purchased or developed, and its use has been integrated throughout the information systems/services unit of the organisation. All projects use a tailored version of the software development process to develop and maintain information systems and software. As a result of using this standardised process for all projects, each project results in consistent high-quality documentation and deliverables. The process is stable, predictable and repeatable.
- Level 4 – Managed: Measurable goals for quality and productivity have been established. Detailed measures of the standard system development process and product quality are routinely collected and stored in a database. There is an effort to improve individual project management based on this collected data. Thus, management seeks to become more proactive than reactive to systems development problems (such as cost overruns, scope creep, schedule delays etc.). Even when projects encounter unexpected problems or issues, the project can be adjusted based on predictable and measurable impacts.
- Level 5 – Optimised: The standardised system development process is continuously monitored and improved based on measures and data analysis established in Level 4. This can include changing the technology and best practices used to perform activities required in the standard system development process, as well as adjusting the process itself. Lessons learned are shared across the organisation, with an emphasis on eliminating inefficiencies in the systems development process while sustaining quality. In summary, the organisation has institutionalised continuous systems development process improvement.
Sunday, January 27, 2013
Systems Development Life Cycle
- Systems Investigation
- System Analysis and Requirements Definition
- Systems Design
- Software Development
- Testing
- Implementation
- Maintenance
- Problems in or opportunities for improving the existing syste
- Objectives of the system investigation
- Overview of the proposed system
- Expected costs and benefits of the proposed system
- Operational feasibility – whether the project can be put into action or operation. This includes considering motivational, logistical and acceptance considerations (such as resistance by users and other ethical considerations).
- Technical feasibility – whether hardware, software and other system components can be acquired or developed to solve the problem.
- Schedule feasibility – whether the project can be completed in a reasonable amount of time.
- Economic feasibility – whether the project is financially viable. Whether the predicted benefits offset the costs and time needed to obtain them.
- Legal feasibility – whether there are laws and regulations that may prevent or limit the system development project.
- Problems in or opportunities for improving the existing system. By having a SIMS in the school, we can keep all student records, staff records, timetables etc. in the SIMS. This can improve the efficiency of the administrative division. For example, some of the objectives of the system may be:
- Release student reports within 2 days of submitting the marks by teachers.
- Student character and leaving certificates provided to students within 2 working days from the time of request.
- Student reports are accessible to students and parents via the Internet.
- Staff attendance and salaries are calculated using SIMS.
- Objectives of the system investigation
- The objectives of the system investigation phase are to evaluate the feasibility and merit of introducing a SIMS to the school. The operational, technical, schedule, economic and legal feasibility is studied. Also, justification for introducing a SIMS to the school is discussed.In our SIMS example, a requirement may be to keep student and staff records in Sinhala and Tamil languages. The technical feasibility study will investigate whether current technology has adequate support for Sinhala and Tamil languages.
- Overview o f the proposed system
- The overview of the proposed system including the main features is discussed. The following diagram illustrates an example of a proposed system.
- Expected costs and benefits of the proposed system
- Since the school currently uses a manual system, the costs must be computed for technology infrastructure, re -organization and training of staff. Then an analysis of whether the benefits outweigh the costs or not must be determined.
and Management System (SIMS)
The design specifications typically cover the following areas:
- Hardware design: All computer equipment including input, processing and output devices with performance characteristics. In our example of SIMS, hardware design includes specification of all hardware requirements (such as computers etc.) and specifying for what purpose the equipment will be used.
- Software design: All software must be specified with capabilities. Certain software may be purchased or others may be developed. All input, output and processing requirements are considered in software design. In our example of SIMS, this includes all software that needs to be purchased (such as Operating Systems, Database Management Systems) and also specifying the software components to be developed (such as Principal, Registrar, Student, Parent interfaces to SIMS, etc.).
- Personnel Design: Positions, job titles and task descriptions are considered in the personnel design. In our SIMS example, we may propose new positions, duties and job titles such as a “System Administrator” etc. and even restructure existing positions.
- Database design: The type, structure and function of the database must be specified. In our SIMS example, this may include the database design that stores the student and staff records.
- Telecommunications and network design: The necessary characteristics of the communications software, media, and devices must be specified. In our SIMS example, this pertains to the school network design that connects the different computer systems.
- Procedures design: All information systems require procedures to run applications and handle problems if they occur. These important policies are captured during procedures design. An important aspect of this step is to design security and backup polices and procedures to minimise the potential for fraud and crime.
- Training requirements: Specifies the training requirements.
- Maintenance requirements: Specifies maintenance requirements for both hardware and software.
- Design Decisions and Alternatives: Major design decisions and alternatives considered are documented.
Software development phase: The specifications produced in the systems design phase provide the input for the Software Development Phase. At this stage, software developers and programmers build and test individual modules of the overall software system. The individual modules are integrated to produce the new system.
Testing phase: Testing Phase proceeds in parallel with the major phases. A broad test strategy is defined at the time the system requirements are identified. Detailed test design takes place during system design, and testing is a part of the software development phase. There are different types of testing that takes place:
- Unit testing: tests individual modules.
- Integration testing: modules are integrated and tested.
- System testing: entire system is tested
- Acceptance testing: verifying users’ test scenarios. This is usually performed at the end of the system development to verify that the system meets users’ requirements.
- Direct implementation: The entire system is replaced with the new system at once.
- Parallel implementation: Both systems (i.e., the new and the old systems) are executed in parallel for a certain defined period of time. This strategy is helpful because of the following:
- Results of the old system can be compared with the results of the new system.
- Failure of the new system at the early stage, does not affect the working of the organisation, because the old system continues to work, as it used to do.
- Phased implementation: The new system is introduced in a phased manner. In this implementation, the new system is installed in parts. Some part of the new system is installed first and executed successfully for considerable time period. When the results are found satisfactory then only other parts are implemented. This strategy builds the confidence and the errors are traced easily.
- Pilot implementation: Pilot implementation allows users to test-drive the solution to make sure it meets both business and technical needs. During a pilot implementation, the solution is installed and configured in the users’ environment for the first time. A pilot implementation provides a snapshot of the same functionality of a full system implementation, generally without the scalability and redundancy found in a full system. To complete the changeover, users must be trained in system operation and any existing old procedures converted to the new system.
The SDLC allows for a large degree of management control. At the end of each phase, a formal review is performed and a decision is made whether to continue, terminate the project or modify and repeat some of the current tasks of the current phase. During the SDLC, documentation is created and this can be useful for system modification later. A major problem of SDLC is that the user does not see a solution until the system is nearly complete. It may result in a system, which does not address the user’s real needs since the development was based on development team’s understanding of the needs. This is quite possible since the user may not necessarily be a computer literate or expert on systems and his expression of requirements may be incomplete and inaccurate resulting in misunderstanding by the development team. SDLC is also inflexible to changing needs of the users. Changes to requirements during system development may not be incorporated. This is because once the systems requirements definition phase is completed, the development team works on other phases without much interaction with the users. If the users’ requirements change during this time, the development team may not be aware or be able to incorporate these new requirements to the system. Even with these shortcomings, SDLC is still a popularly used development methodology for many TPS and MIS systems because of its advantages. Table 3.2 below illustrates some of the advantages and disadvantages of SDLC.
Saturday, January 26, 2013
Information Systems Development
is often the only person who sees the system in totality
Similar to humans, plants and animals, information systems also have a life cycle. An information system also follows a system life cycle – from its development to operation and to final retirement. The system life cycle divides the life of an information system into two stages as follows:
- System development: developing the information system
- Systems operation and support: running the system and supporting it until its retirement.
What is object oriented programming ?
Information System Types
- Transaction Processing Systems
- Management Information Systems
- Decision Support Systems
- Executive Information Systems
- Expert Systems
Processing System
Management information systems: Management Information Systems (MIS) supplement transaction-processing systems with management reports required to plan, monitor, and control routine business operations. In other words, an MIS provides managers with information and support for effective decision-making and provides feedback on daily operations. The primary focus of an MIS is managing theefficiency at the operational level. Management info rmation systems typically provide standard reports derived from information in transaction processing systems. These reports assist managers at the middle -level in their decision–making process. For example, in the bank, a report consisting of average cash flow per month in a branch might assist the manager to plan for future cash requirements at the branch.
Decision support systems: A Decision Support System (DSS) is used to support problem-specific decision-making. The focus of a DSS is to support effective decision-making. A DSS supports all aspects of problem-specific decision-making. It goes beyond the traditional MIS. It supports complex, unstructured and semistructured decision-making. For instance, in our bank example, the management decides to expand and open a branch. A DSS may support in finding the best city or town to open the branch. It may analyse customers’ addresses and their nearest bank branch to suggest locations. For instance, “there are many customers whose addresses are in Matara region having accounts in the Galle branch”, which may suggest opening a branch at Matara. Traditional MISs are seldom used to solve these types of problems; a DSS can help by suggesting alternatives and assisting in final decision-making. A DSS analyses the information already captured by TPSs and MISs in order to support unstructured and semi-structured decision-making at various levels. A DSS may also include data obtained from external sources as well.
Executive information systems: An Executive Information System (EIS) or sometimes also called Executive Support System (ESS), is a DSS specifically made for top-level managers and executives to support their strategic decision making process. EISs provide executives with internal information as well as information from external sources (such as research databases, news services etc.). EISs provide executives to view information in a user-friendly, customised manner that assist them in their decision-making process.
Expert systems: Expert Systems belong to area known as Artificial Intelligence1 in the Computer Science field. The focus of an expert system is to capture the knowledge and reasoning of a human expert in a particular field and utilise this in decision-making in the respective field. Expert systems have been successfully utilised in different areas such as performing medical diagnosis or credit evaluations. In our bank example, an expert system may be utilised to determine the creditworthiness of a loan application.
Thursday, January 24, 2013
Types of Information Systems
policy that is been formulated by upper management. In our example of the bank, this Strategic Tactical Operational Set Goals Arrange Resources Carry out Tasks may include finding appropriate locations and buildings, purchasing equipment, hiring staff and training, making marketing strategies etc. for the newly established bank branches. Managers at the middle level generally deal with semi-structured decisions. A semi-structured decision or a tactical decision is a decision that is made without a clearly defined informational procedure.
The personnel at the operational level carry out the detailed tasks defined by the middle management. Most decisions at this level require easily defined information that relates to the current status and activities within the basic business functions. This information is generally given to lower management in detailed reports. The decisions taken at this level are called structured decisions, also known as operational decisions. A structured decision is a predictable decision that can be made by following a well-defined set of routine procedures.
Let us consider the bank example. A bank teller withdraws cash for a customer’s request if the customer’s account has the available funds. This is a structured decision. The current balance of the customer’s account is the information the bank teller requires to make this decision.
Information systems can be a key element in empowering employees. Often, information systems enable empowerment by providing information directly to employees at lower levels of the hierarchy. In our example of the bank, the bank teller may be enabled to obtain information to verify the validity of the cheque and availability of funds prior to processing the cheque.
Wednesday, January 23, 2013
What is an Information System?
An interface is the means by which two or more entities interact with each other in a system. For instance, in a school, a student may request for a “Character Certificate” by filling a pre-defined form and submitting it to the Registrar. The form that is filled is the interface between the student and Registrar of the school.
In the above definition of information systems, note that we have considered
“problem solving” and “decision-making” needs in addition to our previous definition of a system - a collection on interrelated components (people, data, processes, and interfaces) that work together to achieve a goal (day-to-day operations in an organisation). Also, in the previous section, we have seen how information and data can assist in problem solving and decision- making in an organisation.
It is interesting to note that we have not mentioned the use of computers in information systems. Actually, an information system can exist without the use of computers (a manual information system) or using computers (a computerised information system or computer-based information system). We will study manual and computer-based information system in the next section.
Manual information system: In a manual information system, all data processing is done manually. Filing cabinets, manual procedures and papers are vital components of a manual information system.
large number of filing cabinets to store records
We could store all the data and information of students in a computer. Then, we could check the records of students in a very fast manner (without the use of filing cabinets). Then, the system becomes a computer-based information system (CBIS).
(i.) System software that governs the basic computer operations such a startup etc. For example, the Operating System.
(ii.) Application software allows specific tasks to be accomplished. For example, Word Processing software enables us to create documents – letters, books, etc.
- A database is an organised collection of data and information. As we discussed previously, data and information are critical for problem solving and decisionmaking in an organisation. Hence, most managers and executives consider a database to be the most valuable and important part of a computer-based information system.
- Telecommunications is the electronic transmission of signals (i.e. data) for communications. Telecommunications enable organisations to carry out processes and tasks through effective computer networks. Networks connect computers and computer equipment in different locations (i.e. places) and enable electronic communications. For example, the Internet is the world’s largest computer network, which connects computers around the world.
- People are the most important element in most computer-based information systems. These include users, people who manage, run, program, and maintain the system. Users are persons, who use information systems to get results.
- Procedures include the strategies, polic ies, methods, and rules for using a computer-based information system. Procedures may include methods such as
“how to perform a task by executing a particular program?” or policies such as
“who can have access to the database and what data?”
We have discussed computer-based information systems in general. Let us consider an example of a CBIS. In Sri Lanka, we are seeing many financial institutions, such as banks, using computer-based information systems.
- Cost: The initial cost in installing a computer-based information system is higher than a manual system. In a computer-based information system, there is a cost for hardware, software, and computer networks (also called technology infrastructure) in addition to people and making up procedures. In a manual system, the initial cost is lower since this technology infrastructure is not required.
- Fast access to information: In a CBIS, information can be retrieved very fast when compared to a manual system. This is because computers store and access data electronically which is faster than a person looking through a cabinet of files.
- Accuracy: In a CBIS, computers handle many repetitive data processing tasks. When programmed properly, computers are very accurate in data processing. In a manual system, humans handle these tasks. Humans get tired and bored and thus may result in errors.
- Distributed access to information: With computer networks, we can connect different computer systems and communicate between them. Hence, we can access information from many different places. In our previous example of the bank’s CBIS, a customer can access his/her account information from any branch (e.g. Anuradhapura or Kandy) because the computer networks connect the different branches and head office. Gaining efficient distributed access to information is difficult in a manual system.
- Availability: In a CBIS, since many tasks rely on computer systems, they are available throughout the day. In a manual information system, since many tasks rely on humans, they may not be available. Humans get tried and needs a rest so they work during daytime (for instance, 8am – 5pm). Computers do not get tired and can work all 24 hours a day. In our example of the bank, a customer can go to the ATM in the night when the bank is closed and still withdraw money from his/her account. This is because the bank is using a CBIS.
- Reliability: In a CBIS, computers are used for many tasks. Computers rely on electricity to work. If there is a power failure or system failure, many tasks cannot be performed in a CBIS (unless alternative systems are in place). Sometimes, the entire system may come to a standstill! In a manual system, humans are performing the tasks and if a person gets ill another person may easily replace him/her during this period. However, if all persons gets-together and strike, then the entire system can come to a standstill!
- People resources: In a CBIS, since computers perform many tasks, there is a need for fewer people to operate a system. However, the people in a CBIS need to be well trained to operate the CBIS. In a manual system, larger number of people is needed to operate the system. Hence, some persons argue that CBIS replaces certain people’s jobs (such as clerks, office assistants etc.), while other’s claim that organisations are more efficient and productive and hence save more money by utilising a CBIS.
Tuesday, January 22, 2013
Information Systems
information systems.
It is evident from the above discussion that data and information play a key role in decision-making. Think of other examples of decision-making and type of data and information that influences such decisions? Also, it is evident that different people use different types of information to make decisions. In our above example, the principal makes a decision based on the average marks rather than the student report book. Similarly, the student based his/her decision by considering the information in his/her report book rather than average marks obtained by all students for a subject. Now that we understand what data and information mean and also, we have seen how data and information influence our decision-making to solve problems, we will start to explore informatio n systems in detail.
Monday, January 21, 2013
System Types
Now that we have learnt and gained an understanding of what a system is, we will focus our attention to the next section, which is Information Systems.
Elements of a System
System: School
Goal: Education of students
Input: Children, teachers, funds
Processing: Teaching and learning
Output: Educated students
Sunday, January 20, 2013
Information systems
A system is a collection on interrelated components that work together to perform a specific task or achieve a goal. In a system, the different components are connected with each other and they are interdependent. Each component is a subsystem of the original system and carries out a part of the system task.
Let us consider the respiratory subsystem which provides air to the body from the environment. Some of the components of the respiratory subsystem includes nasal passages, lungs etc. Each component, such as lungs, can it self be considered as a subsystems. Similarly, the heart and blood vessels can be considered as components of the circulatory subsystems.
What is the goal of the circulatory subsystems? The digestive subsystems? List some components of circulatory and digestive subsystems.
Another example of a system is a school. Principal, teacher, students, equipment and classrooms are components of a school.
Saturday, January 19, 2013
Introduction to Information Technology
There is a genera belief that Information Technology (IT) is about computers. However, this is not true. Information Technology (IT) is about computers. Information and knowledge utilizing such computers and communication networks. Information Technology (IT) has enabled people indifferent parts of the world to exchange information freely and with ease. In effect, IT makes us realize how small the world, we live in, is as it removes physical constraints such as distance between people in exchanging information.
Information Technology (IT) has opened up a whole new of employment opportunities as programmers, systems analysts, systems designers, software engineers, software architects, systems engineers, database administrators, network engineers, network administrators, computer hardware professionals, Website developers, multimedia professionals, IT consultants and the like. In addition, IT has created vast job opportunites in other fields such as management, accountancy, commerce, banking, publishing and media, engineering, architecture, health and medicine.
There are also emerging areas of specialization such as electronic commerce, web services, network and data security, intelligent systems, e-government services all spurred by IT.
With the availability of a wide variety of employment opportunities in the field of IT and a whole host of opportunities in the field of IT applications in other disciplines, those who are knowledgeable and proficients in IT will naturally find satisfying jobs with high remuneration both here and abroad. This is good enough reason for any student to embark on studies in IT.