Dot Net Framework Evolution

Dot Net framework is a software development environment which aids in faster software development with the help of features such as Cross language interoperability, common language runtime, just in time compilation, dynamic coding etc. Dot Net Framework is not a programming language. It is a platform that provides tools and technologies to develop Windows, Web and Enterprise applications .

 

Evolution of .NET

NET technology was introduced by Microsoft, to catch the market from the SUN Microsystem’s  Java. Java has become an extremely popular language specially for web development and Microsoft had only VC++ and VB to compete with Java . With the world more and more dependent on Internet and java related tools, Microsoft seemed to be losing the battle.VC++ foundation classes were difficult to learn while Visual Basic though popular was too simple for serious applications.Microsoft developed the OLE and the COM technology before Dot Net .

 

OLE Technology

OLE stands for Object Linking and Embedding which enables one to create objects with one application and then link or embed them in a second application. For example, The Microsoft Excel worksheets can be embedded in a Visual Basic Form or in a PowerPoint presentation such that when the original embedded object changes the change is affected in the linked application. Embedded objects retain their original format and links to the application that created them. This technology enables users develop applications which requires interoperability between various products.

COM Technology

The component oriented model (COM)on the other hand enables to divide a software into independent executable and reusable components .These components can be collected to form a library which can be references in the future projects if required.

 

THE ADD REFERENCE DIALOG BOX FOR ADDING AN EXTERNAL COMPONENT TO THE PROJECT

 

What makes COM and OLE unique is that the architecture is based on reusable design and reusable code. One of the fundamental concepts in COM, the interface, is based on the idea of design reuse. COM and OLE introduce a programming model based on reusable designs.

Microsoft started development of the .NET Framework in the late 1990s secretly under the name of Next Generation Windows Services (NGWS) under the direct supervision of Mr.Bill Gates. Sometime in the July 2000, Microsoft announced a whole new software development   framework for Windows called .NET in the Professional Developer Conference (PDC).Microsoft also released PDC version of the software for the developers to test. By late 2000 the first beta versions of .NET 1.0 were released. The first version of .NET Framework was released on 13 February 2002, bringing managed code to Windows NT 4.0, 98, 2000, ME and XP.

 

 

Entity Relationship diagram

Entity Relationship Diagram..all about Relationships

when we design Entity sets during database designs through Entity Relationship Diagram, there have to be  some kind of connections existing between them too. These connections are called “Relationships “derived from the real world term. A relationship can be classified according to the degree or connectivity. The following are the important points to remember about relationships in Entity Relationship diagrams

  • A relationship is an association between entity sets.
  • The entity sets that are involved in the relationship are also known as participants.
  • Relationships are named and the name is generally a verb.
  • Relationships are always two ways i.e. they operate in both the directions, so the N: 1 between Students and Teachers could also be thought of as a 1: N between Teachers and Students.

 

DBMS Introduction

| Video

Introduction to Database Management Systems

This video demonstrates the need of DBMS ,the problems in the file based systems and the advantages of Database Management System in today’s era.

WHAT IS DATABASE SYSTEM?

A database management system (DBMS) is a computer software application that interacts with the user, other applications, and manage the organization and storage of data in database .

Some of the important Database Management Systems in use:-

Name of DBMS Full Name Company Name Year Introduced Latest version Query Language
IMS IBM Information Management System IBM 1966 IMS version 12 DL/I
IDMS Integrated Database Management System Cullinet, CA technologies 1983 CA IDMS/DB Version 18.0 SQL
MS-Access Microsoft Access Microsoft 1992 MS-Access 2013 SQL
SQL Server 2000 Structured Query Language Server Microsoft 2005 SQL Server 2012 T-SQL
Oracle Oracle Oracle 1978 Oracle 11g PL-SQL

Applications of DBMS

  • Railway reservation and ticketing.
  • Airlines booking.
  • Hotel reservation.
  • Movie ticket booking.
  • Retail store billing.
  • Salary processing.
  • Mobile address book.
  • Students mark sheet processing and printing.
  • News paper printing and publications.
  • Library Information System.

LIMITATIONS OF DATA PROCESSING ENVIRONMENT

  • Data redundancy:
  • Data Inconsistency:
  • Data Integrity problems:
  • Data Access difficulty:
  • Data Isolation:
  • Concurrent Access anomalies:

Advantages of using DBMS

  1. It represents complex relationships among different data items:
  2. Enforces data integrity in a System:
  3. Keeps a tight control on data redundancy:
  4. Efficient data access:
  5. Maintains data dictionary:
  6. Provides different interfaces through which users can manipulate data: