Information Technology · Class 12 Commerce
Ch 4IT Applications - II — Class 12 Information Technology, concept-first.
In your first-year Information Technology course you learned how a computer system is built, how it is programmed, and how data is organised in a database. This second-year applications chapter puts all of that together for a single, very practical goal: building a working database application — the kind of software a…
Key concepts
Hover a concept to preview it and jump to its most relevant Q&A.
E-Business
E-business is the running of any business activity — trading, inventory, accounts, supplier dealings and customer service — with the help of computers, software and the internet.
Most relevant Q&A
- Running the whole of a business — including inventory, accounts, supplier dealings and customer service — with the help of information techn…Free
- Distinguish between e-business and e-commerce.Free
- What is e-business? Explain its main features and the common models of e-business (B2B, B2C, C2C, C2B) with an example of each.Free
Chapter contents
The NCERT structure, section by section. Open a section to see its questions, then read the concept-first solution.
Overview
In your first-year Information Technology course you learned how a computer system is built, how it is programmed, and how data is organised in a database.
Concept of E-Business
What e-business means. E-business (electronic business) is the carrying on of any business activity with the help of computers, software, the internet and other information and communication technolog…
Anatomy of a Database Application — Front-End and Back-End
What a database application is. A database application is a piece of software that lets users store, retrieve, update and manage data that is kept in a database.
The Front-End Interface
What the front-end interface does. The front-end interface is the collection of screens and controls through which a user works with a database application.
The Back-End Database
What the back-end holds. The back-end of a database application is a relational database managed by a relational database management system (RDBMS).
Front-End to Database Connectivity
Why connectivity is needed. The front-end and the back-end are two separate pieces of software — often even on two different computers.
Developing a Database Application — Bringing Front-End and Back-End Together
This section pulls the whole chapter together by building one small application from start to finish. Suppose a shop wants a simple program to keep its customer records — to add a new customer, search…
More questions
12 Q+−Show 5 questionsHide questions5 questions
- Q1Running the whole of a business — including inventory, accounts, supplier dealings and customer service — with the help of information techn…Free
- Q2In a database application, the part that the user sees and interacts with — the forms, buttons and text boxes — is called the: (a) Back-end…Free
- Q3Which SQL statement is used to add a new row of data into a table? (a) SELECT (b) UPDATE (c) INSERT (d) DELETEPreview
- Q4The software component that acts as a translator between the front-end program and a particular database is called the: (a) Compiler (b) Dri…Preview
- Q5Checking a user's input at the front-end — for example, refusing a blank name or a negative age — before it is sent to the database is calle…Preview
+−Show 4 questionsHide questions4 questions
- Q6Distinguish between e-business and e-commerce.Free
- Q7What is meant by the 'front-end' and the 'back-end' of a database application? State one function of each.Free
- Q8List and briefly explain any four common controls used to build a front-end form.Preview
- Q9State the standard steps a front-end follows to connect to a back-end database and run a query.Preview
+−Show 3 questionsHide questions3 questions
- Q10What is e-business? Explain its main features and the common models of e-business (B2B, B2C, C2C, C2B) with an example of each.Free
- Q11Explain the two-part (front-end and back-end) structure of a database application. Why are the two parts kept separate, and how do they work…Preview
- Q12Describe, with the steps and short code, how a customer-record database application is developed by bringing the front-end and back-end toge…Preview