📌 CBSE Class 12 MySQL Notes – Last-Minute Revision
Preparing for your CBSE Class 12 Computer Science board exam? Need a quick and effective revision for MySQL? You're in the right place! This page provides concise, exam-focused MySQL notes designed for last-minute preparation.
DATABASE MANAGEMENT SYSTEM
8.Table:
Components of table
Data Item(Field) or Attributes/column:
A data item is the smallest unit of named data . It may consist of any number of bits or bytes .
A data item represents one type of information and is often referred to as a field or data element
Name | DOB | Mark | RollNO | Grade |
Al | 2007 | 96 | 001 | 9 |
Records/row/tuple:
A record is a named collection of data items which represents a complete unit of information
Table/Relation:
A table is a named collection of all occurrences of a given type of logical record. A table is also called a relation in relational database.
9.Database Objects:
1) Table: It is a collection of data elements (values). It consists of vertical columns and horizontal rows where we put the required information.
2) Columns or Fields or Attributes: It is a set of data values of a particularly simple type, one for each row of the table.
3) Rows or Records or Tuples: It represents a single data item in a table. Every row in the table has the same structure.
10.Data Types: These are used to identify which type of data we are going to store in the database.
11.MYSQL and SQL
Processing capability of SQL
1. Data Definition Language(DDL)
2. Interactive Data Manipulation Language
3. Embedded Data Manipulation Language
4. View Definition
5. Authorization
6. Integrity
7. Transaction Control
Data Dictionary:
A data Dictionary is a file that contains “Metadata” I.e,”data about data”
0 Comments