All Articles

UML example

UML or Unified modelling language is the best tool for modelling object oriented systems. As we know, in objet oriented modelling and design, we identify objects (entities)within the system and analyze how they interact with each other and thus design an interactive model preserving their individual properties, behavior as well as publicizing their public attributes…

All Articles

ERD examples

ERD or Entity relationship diagram is the most common database design and modelling tool used in System Design phase. The diagram basically represents all data entities of the targeted system, their attributes and relationships. Database modeller represents ERD in various levels of details such as Context Data Model, Key based model and Fully attributed model….

All Articles

DFDs example

Data Flow Diagram is the widely used system design tool which aids in depicting flow of logic and data (commonly called process flow) within the targeted system, in various levels of detail. Level 0 DFD is usually called ‘Context Diagram’ and it gives the highest level view. Starting from the black box in Context Diagram,…

All Articles

Use Case Building – An example

Use cases are one of the excellent tools for representing functional requirements of a system. Use case modelling refers to modelling of system’s functions in terms of business events (use cases), who initiated the events (actors) and how does system reacts to those events (Whitten J.L, 2007). Use case models are usually represented as use…

All Articles

Should countries like the United States push for agenda items like freedom of expression, intellectual property protection, and cybercrime prevention?

The freedom of expression, being one of the firmly stated and affirmed right in the US constitution, I think the question refers to effecting in a global scenario. Freedom of expression touches most sensitive areas such as religion, which has a soft corner for. Considering the current world situation, I think pushing for such agendas…

All Articles

What is IT?

We have seen so much about IT and all of us have been a part of it by some means or other. We all know what IT refers to and what are its applications. I have been trying to define what is IT or Information Technology, since some time. This is puerly a personal effort…

All Articles

Information Management and career levels

Deepesh JosephAugust 2006 Information Management (IM) refers to any activity that leads to effective collection, storage, retrieval and analysis of information by focusing on business strategy and by continuously improving business competitiveness and adaptability. The ultimate goal of any IM job is to add up to the combined efforts to meet the required business strategy….

All Articles

Compare and contrast data warehouse principles

Operational Vs Informational system : Operational Systems are those which are based on current data and thus supports current/day-to-day functioning of a business. Informational Systems on the other hand are based on historical information and thus supports complex data mining/analysis and decision making. The core difference lies in the way queries are run to process/analyze…

All Articles

Various kinds of Database Systems

a. Homogeneous vs. heterogeneous distributed database system Homogeneous database systems involve similar databases distributed over the network (on separate machines). Example of homogeneous database system is an enterprise’s nation-wide ERP system which comprises of distributed databases, all of which are Oracle. Heterogeneous database systems on the other hand are distributed database systems that consist of…

All Articles

Pros and Cons of normalizing data into 3NF form

Deepesh Joseph February 2009 The main purpose of normalization is to reduce data redundancy and avoid inconsistent data. Normalization leads to separation of unrelated entities into separate entities. In effect, normalization leads to clean database design. Since we do not store redundant data, we save storage space and save resources to maintain (update, delete) redundant…