Plus Two Computer Application Notes Chapter 8 Database Management System

by

Kerala State Board New Syllabus Plus Two Computer Application Notes Chapter 8 Database Management System.

Kerala Plus Two Computer Application Notes Chapter 8 Database Management System

DBMS means Data Base Management System. It is a tool used to store a large volume of data, retrieve and modify the data as and when required. DBMS consists of data and programs.

Advantages of DBMS

  1. Data Redundancy
  2. Inconsistency can be avoided
  3. Data can be shared
  4. Standards can be enforced
  5. Security restrictions can be applied
  6. Integrity can be maintained
  7. Efficient data access
  8. Crash recovery

Structure of DBMS

  1. Fields – Smallest unit of data. Eg: Name, age, sex, …
  2. Record – Collection of related fields.
  3. File – Collection of records

Components of DBMS

  1. Databases – It is the main component.
  2. Data Definition Language (DDL) – It is used to define the structure of a table.
  3. Data Manipulation Language (DML) – It is used to add, retrieve, modify and delete records in a database.
  4. Users – With the help of programs users interact with the DBMS.

Database Abstraction – Abstraction means hiding, it hides certain details of how data is stored and main-tained.

Levels of Database Abstraction:

  1. Physical Level (Lowest Level) – It describes how the data is actually stored in the storage medium.
  2. Logical Level (Next Higher Level) – It describes what data are stored in the database.
  3. View Level (Highest level) – It is closest to the users. It is concerned with the way in which the individual users view the data.

Data Independence – It is the ability to modify the scheme definition in one level without affecting the scheme definition at the next higher level.

  1. Physical Data Independence – It is the ability to modify the physical scheme without causing application programs to be rewritten.
  2. Logical Data Independence – It is the ability to modify the logical scheme without causing application programs to be rewritten.

Users of Database

  1. Database Administrator
  2. Application Programmer
  3. New users

Data models – It is a collection of tools for describing data, data relationship, data semantics and consistency problem. 3 models.

  1. Hierarchical model
  2. Network model
  3. Relational model

RDBMS – Relational DataBase Management System. It consists of a collection of relations as database.

Relation means table.

Domain – A pool of possible values from which col-umn values are drawn. ‘

Tuple means rows.

Attributes means columns.

Cardinality – The number of rows.

Degree – The number of columns

View – A view is a virtual table derived from one or more base tables.

Key is used to identify or distinguish a tuple in a relation.

Candidate key – It is used to uniquely identify the row.

Primary key – It is a set of one or more attributes used to uniquely identify a row.

Alternate key – Acandidate key other than the primary key.

Foreign key – A single attribute ora set of attributes, which is a candidate key in another table is called foreign key.

Relational Algebra – It consists of a set of opera¬tions that takes one or two relations as input and produces a new relation as a result.

  1. Select operation (σ)
  2. Project Operation (π)
  3. Cartesian Product
  4. Union Operation (∪)
  5. Intersection operation (∩)
  6. Set difference operation (-)