Changing TargetFramework of ASP.NET project in VB

I recently faced a situation where we had to run one project on server running .NET 2.0. The project was ASP.NET application using VB.NET.

In C# you easily find the targetframework option in the applications tab of properties dialogbox but in VB.NET i was struggling to find that

Later on I found that you can go to project properties -> Compile -> Advance Compile Options where the target framework option can be found

Introduction to Web Applications (MAJU Fall 2012)

Learning Objective:
To introduce Web Applications in simplist terms and to introduce the key players involved

What are web applications?
Simplist definition:Stored on a server and accessed via A Web Browser

Whats the advantage?
- Code resides at a single place
- Clients need no installation therefore there is no need of high processing and memory capabilities at client end
- Incase new feature needs to be coded then update is required at the server only. In other words maintenance is easy

Why Study Web Application?
- Due to easy maintenance companies donot hestiate to chose web based solutions
- Requires less processing power at the client end
- Can be very easily made available over the internet so that remote users can also use the application

Entities Involved
- Web Browser
- Web Server
- Database Server (optional)

Web Browser: Has the responsibility of displaying the output to the end user

Web Server:
Has the responsibility of processing the request of user and preparinng the response

Database Server:Stores the data that is important to users

To understand the role of each lets take example of restaurant and compare it with Web Applications:
-You give your order to the waiter
-In web application you place request on web browser
-The waiter takes the order to the cook
-The browser sends the request to server
-The cook reads the order and prepares dishes
-The webserver reads the request and prepares response
- To prepare the dishes the cook obtains ingrediants from the server
- To prepare the response server obtains data from Database Server
- The cook gives the prepared dishes to the waiter
- The Server sends the prepared response to the browser
- The Waiter brings the dishes to you
- The browser displays the prepared response to you

Communication Between Browser and Server- The scenario of Browser and Server is more complex than that of Waiter and Cook. Both Waiter and Cook belong to the same restaurant, but browser and server and normally made by different companies
- If browser of each company applies a different set of rules to ensure successfull transit of data to server then developing a server will become a very complex task as server will have to have knowledge of varying rules of each browser
- Similary if server made by each company applies different set of rules to send respone then making browsers will become very difficult
- The solution is to have a standard set of rules that all browsers and servers use. This standard set of rules is known as Hyper text Transfer protocol
- Similary the contents of the response contain a standard language which Hyper text markup language

Mapping ER Models into Relations (For Students of Database Systems)

I was about to write something on this topic but found a resource that contains the contents I was willing to discuss.
Do visit the link below and get the copy of material for future reference
http://db.grussell.org/section006.html

Database Systems Lecture 1 & 2 (MAJU Spring 2012)

Topics of the Lesson:
• Introduction of Database
• File-based systems
• Database management systems
• Comparison between File-based system and Database management systems

Functions of DBMS
Introducing Database:
The simplest definition is given by Date (1999, p. 2) according to which Database is a
collection of computerized data files. In simple words it is computerized
record keeping.

Examples of Database Applications
• Purchases from the supermarket
• Purchases using your credit card
• Booking a holiday at the travel agents
• Using the local library
• Taking out insurance
• Using the Internet
• Studying at university

File-based Systems
• Collection of application programs that perform services for the end users (e.g. reports).
• Each program defines and manages its own data
• E.g. is a C++ system that accepts and stores data. In such case the sequence in which the fields are recorded is coded in the program, not in the file.

Limitations of File-Based Approach

• Separation and isolation of data
– Each program maintains its own set of data.
– Users of one program may be unaware of potentially useful data held by other programs.
– Duplication of data
– Same data is held by different programs.
– Wasted space and potentially different values and/or different formats for the same item.

• Duplication of data
– Same data is held by different programs.
– Wasted space and potentially different values and/or different formats for the same item.

Database Approach

• Arose because:
– Definition of data was embedded in application programs, rather than being stored separately and independently.
– No control over access and manipulation of data beyond that imposed by application programs.
•
Result:
– the database and Database Management System (DBMS).

Formal definition of Database
• Shared collection of logically related data (and a description of this data), designed to meet the information needs of an organization.
• System catalog (metadata) provides description of data to enable program–data independence.
• Logically related data comprises entities, attributes, and relationships of an organization’s
information.

Database Management System (DBMS)
• A software system that enables users to define, create, and maintain the database and that provides controlled access to this database.
Views
• Allows each user to have his or her own view of the database.
• A view is essentially some subset of the database.

Functions of Database Management System
· Provide Security
· Data Integrity
· Provide controlled concurrency
· Reduced data redundancy
· Crash Recovery
· Backup and Recovery