CBSE Class 12 Informatic Practices Database Connectivity

Read and download CBSE Class 12 Informatic Practices Database Connectivity chapter in NCERT book for Class 12 Informatics Practices. You can download latest NCERT eBooks for 2022 chapter wise in PDF format free from Studiestoday.com. This Informatics Practices textbook for Class 12 is designed by NCERT and is very useful for students. Please also refer to the NCERT solutions for Class 12 Informatics Practices to understand the answers of the exercise questions given at the end of this chapter

Database Connectivity Class 12 Informatics Practices NCERT

Class 12 Informatics Practices students should refer to the following NCERT Book chapter Database Connectivity in standard 12. This NCERT Book for Grade 12 Informatics Practices will be very useful for exams and help you to score good marks

Database Connectivity NCERT Class 12

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

Tags: 

 


Click to View or Download pdf file
Click for more Informatics Practices Study Material

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

Pariksha Pe Charcha 2022

The 5th edition of Pariskhas Pe Charcha the unique interactive program of Hon’ble Prime Minister with students teaches and parents will be held through virtual mode in February, 2022. In order to select participants who will be featured in Pariksha Pe Charcha programme...

Class 10th and 12th Term 2 Revaluation Process 2022

Evaluation of the Answer Books is done under a well-settled Policy. To ensure that the evaluation is error free, CBSE is taking several steps. After strictly following these steps, the result is prepared. Though, CBSE is having a well-settled system of assessment,...

Surya Namaskar Project on 75th Anniversary of Independence Day

Ministry of Education, Govt of India vide letter No. F.No. 12-5/2020-IS-4 dated 16.12.2021 has intimated that under the banner Azadi ka Amrit Mahotsav the National Yogasanasports Federation has decided to run a project of 750 million Surya Namaskar from 01 January 2022...

CBSE notification 40/2021 Innovation Ambassador Program

This is with reference to CBSE Notification No. 40/2021 dated 04.05.2021 regarding the Innovation Ambassador program – An online training program for teachers by CBSE in collaboration with Ministry of Education’s Innovation Cell (MIC) and AICTE. In view of the current...

CBSE OMR Sheet Guidelines for Term 1

You are aware that the CBSE will be using OMR for the first time for assessment of both the Classes-X and XII in Term-I examinations. Hence, there is a need that all the students appearing in the Term-l examinations and the schools sponsoring these students should have...

MCQ Question based CBSE examination

For 2021-22 CBSE has launched MCQ question-based examination for Term 1 & Term 2 board examinations. The entire syllabus has been divided into two parts each including 50% of the entire syllabus. To score well, students must practice as per the new CBSE term-wise...