Notes for BSc CSIT

 Difference between Operational Database(OLTP) and Data Warehouse/(OLAP). • The Operational Database is the source of information for the data warehouse. It includes detailed information used to run the day-to-day operations of the business. The data frequently changes as updates are made and reflect the current value of the last transactions. • Operational Database Management Systems also called OLTP (Online Transactions Processing Databases), are used to manage dynamic data in real-time. • Data Warehouse Systems serve users or knowledge workers in the purpose of data analysis and decision-making. Such systems can organize and present information in specific formats to accommodate the diverse needs of various users. These systems are called as Online-Analytical Processing (OLAP) Systems. Operational Database(OLTP)  Operational systems are designed to support high-volume transaction processing. Operational systems are usually concerned with current data. Data within operational systems

 Prototyping Model Prototyping is the iterative process of system development which is more appropriate for developing a new system where there is no clear idea of requirements, inputs, and output. Using prototyping, programmers can build an early version of systems. These systems are then continuously modified until the users are satisfied. Prototyping is especially helpful in situations where there will no heavy user interaction with the system, where the needed output is uncertain, and in some decision support applications where the logic is hard to determine in advance. The developer interviews the user and designs an initial system using a database management system. The user works with the prototype and suggests changes. The process repeats until the user or developer is satisfied.   The figure shows the steps involved in developing the type of prototype. There are 4 steps and are as follows:- Identify the user need                 The system analyst interviews the user to obtain