Back-End Database Class 12 Notes

CBSE Notes for Back-End Database Class 12 Notes

  • The back-end, also called the server side, consists of the server which provides data on request, the application which channels it, and the database which organizes the information.For example, when a customer browses shoes on a website, they are interacting with the front end.
  • After they select the item they want, put it in the shopping cart, and authorize the purchase, the information is kept inside the database which resides on the server.
  • A few days later when the client checks on the status of their delivery, the server pulls the relevant information, updates it with tracking data, and presents it through the front-end. Please refer Back-End Database Class 12 Notes for more information.

Front-End Interface Class 12 Notes

CBSE Notes for Front-End Interface Class 12 Notes

A front end is the graphical user interface of a computer that makes it easier to use. For example, MicrosoftWindows 3.11 was a front end for the MS-DOS command line. Before Windows, the user had to memorize a series of commands to perform tasks on the command line that made computers difficult for most users. Please refer Front-End Interface Class 12 Notes for more information.

Front-End Interface Class 12 Notes

Integrity Constraints and Tables Class 12 Notes

CBSE Notes for Integrity Constraints and Tables Class 12 Notes

1) Integrity Constraints are used to apply business rules for the database tables. Theconstraints available in SQL are Foreign Key, Not Null, Unique, Check. …
2) The constraints can be specified after all the columns are defined. This is called table-level definition. Please refer Integrity Constraints and Tables Class 12 Notes for more information.

Integrity Constraints and Tables Class 12 Notes

SQL Functions and Table Joins Class 12 Notes

CBSE Notes for SQL Functions and Table Joins Class 12 Notes

  • SQL is a language that enables you to create and operate on relational databases, which are sets of related information stored in tables.
  • Tables are created with the CREATE TABLE command. When a table is created, its columns are named, data types and sizes are supplied for each column.
  • SQL Join is used to fetch data from two or more tables, which is joined to appear as single set of data. It is used for combining column from two or more tables by using values common to both tables. Please refer SQL Functions and Table Joins Class 12 Notes for more information.
SQL Functions and Table Joins Class 12 Notes

Fundamentals of Database Class 12 Notes

CBSE Notes for Fundamentals of Database Class 12 Notes

Database is a collection of different kinds of data which are connecting with some relation. In different way, it is a computer based record keeping system. The collection of data referred to as a database.

Purpose of Database :
Years ago, for keeping record, a typical file-processing system is used. A number of different application programs are written to extract records from and add records to the appropriate files. But this scheme has a number of major limitations and disadvantages, such as data redundancy, data inconsistency, unsharable data, unstandardized data, insecure data, incorrect data, etc. Please refer Fundamentals of Database Class 12 Notes for more information.

Fundamentals of Database Class 12 Notes

HTML and XML Class 12 Notes

CBSE Notes for HTML and XML Class 12 Notes

1. HTML is designed to display data and hence, focussed on the ‘look’ of the data, whereas XML is designed to describe and carry data and hence, focuses on ‘what data is’.
2. In HTML tags are predefined, while in XML, tags can be created as per needs.
3. HTML tags are not case sensitive, whereas XML tags are case sensitive. Please refer HTML and XML Class 12 Notes for more information.

HTML and XML Class 12 Notes

Web Application Development Class 12 Notes

CBSE Notes for Web Application Development Class 12 Notes

World Wide Web is an example of an information protocol/service that can be used to send and receive information over the internet. It supports:
• Multimedia Information (Text, Movies, Pictures, Sound, Programs etc…)
• Hyper Text Information 😦 Information that contains links to other information resources)
• Graphical User Interface :(So users can point and click to request information instead of typing in text commands)

The World Wide Web is an example of an information protocol/service that works using a Client/Server software design. A service that uses Client/Server design requires two pieces of software to work: Client software (e.g. Web Browser) to request information, and Server software(Web server) to answer requests and provide their information. Most Web applications are designed this way. Please refer Web Application Development Class 12 Notes for more information.

Accessing MySQL Database Using ODBC/JDBC Class 12 Notes

CBSE Notes for Accessing MySQL Database Using ODBC/JDBC Class 12 Notes

  1. Start the ODBC manager. …
  2. Ensure that the MySQL ODBC driver is installed on the machine by clicking the Drivers tab.
  3. Next click the either User DSN or System DSN tab to create a DSN.
  4. To add a new data source, click the Add button and select MySQL/Connector ODBC from the list. Please refer Accessing MySQL Database Using ODBC/JDBC Class 12 Notes Start the ODBC manager. …
  5. Ensure that the MySQL ODBC driver is installed on the machine by clicking the Drivers tab.
  6. Next click the either User DSN or System DSN tab to create a DSN.
  7. To add a new data source, click the Add button and select MySQL/Connector ODBC from the list. Please refer
Accessing MySQL Database Using ODBC/JDBC Class 12 Notes

GUI Programming and Access Specifier Class 12 Notes

CBSE Notes for GUI Programming and Access Specifier Class 12 Notes

In this chapter we shall be revising the JAVA GUI programming concepts using Swing API through NetBeans IDE.Java GUI applications are created through RAD tools with Classes, Object and methods etc. Please refer GUI Programming and Access Specifier Class 12 Notes for more information.

GUI Programming and Access Specifier Class 12 Notes
Design a site like this with WordPress.com
Get started