CBSE Book Class 12 Informatic Practices Database Connectivity

Imagine a swanky air-conditioned car showroom in prime location of the city with all modern car accessories available in an outlet within the showroom. The showroom has a

DATABASE CONNECTIVITY

wonderful ambience, employs skilled salesperson with excellent communication skills to convince prospective buyers. They have a tie-up with various banks and financial agencies to provide lucrative payment plans to lure customers. What do you think he will sell? Do you think this showroom will be able to cover cost without selling cars? Do you think the skilled salesperson with excellent communication skills will be able to manufacture cars?

On the other hand there is a factory, as usual in a remote location, with abundant raw material, latest machinery, skilled workforce that is technically sound with latest automobile expertise. The factory keeps manufacturing cars but does not have any dealers. Factories are generally set up in remote industrial towns so do you think a remote area in Gujrat will be able to sell cars directly from their factory? Do you think the factory will be able to cover their costs incurred on raw materials without delivering cars? Do you think a skilled workforce can convince people to buy cars?

As you know that the programmers develop applications for solving real life problems to simplify life of others. That is the reason, they try to develop applications, which require minimum inputs from the user and provide meaningful information in the form of output through their applications. The programmer develops these applications keeping in mind that the user will have a very basic understanding of handling mouse, keyboard and desktop applications.

In the earlier lessons of GUI programs, you must have got a good idea of developing simple GUI Applications, in which user was typing in or clicking on certain inputs to produce meaningful results (output). If you see all these applications carefully, you will realize that none of them are capable of retaining the inputs or outputs for future reference or uses. So, typing in any number of inputs in the application carries a life span of one execution only and when the application is executed second time, it requires a new set of inputs from the user. Do you realize why it is like this? It is because; the data entered by you in a front end application was getting stored in temporary memory (RAM) and not getting saved on a hard disk (or any other secondary storage device). 

The database helps you to save data permanently in secondary storage devices and keeps data ready for future reference, modification and addition. In the earlier lessons about database concepts, you have learnt about how to create a table, modify content of a table, add new content in the table, delete content from a table and retrieve content from a table in various forms. But you must have seen that to perform these activities, you were required to learn SQL commands like CREATE, UPDATE, INSERT, DELETE, SELECT and so on and each of these commands had their own syntax structures. Let us review this with the help of the Employee table shown below:

Please refer to the link below for - CBSE Class 12 Informatic Practices Database Connectivity