Computer Capsule for Banking Exams Database Management System Notes Set 01

Official Study Materials for Computer Science

Explore structured advanced study materials through the Computer Capsule for Banking Exams Database Management System Notes Set 01. Tailored for learners, utilizing these Computer Science resources ensures thorough preparation and strengthens foundational knowledge before final evaluations.

Advanced Resources for Computer Science

Access the complete useful resource PDF for Computer Science below. Regular practice with these targeted academic notes builds familiarity with complex topics and helps secure higher marks in final school evaluations.

Database management system notes: definition and advantages of a DBMS, the three levels of data abstraction, kinds of database users and the work of the DBA, the relational model, all seven types of keys explained with an Employee table example, and the SQL command groups DDL, DML, DCL, TCL, VDL and SDL.

Database Management System

Database - A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.

DBMS - It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.

Advantages of DBMS

1. Redundancy is controlled.
2. Unauthorized access is restricted.
3. Providing multiple user interfaces.
4. Enforcing integrity constraints.
5. Providing backup and recovery.

Three Levels of Data Abstraction

1. Physical level: The lowest level of abstraction describes how data are stored. (How to store the data?)
2. Logical level: The next higher level of abstraction, describes what data are stored in database and what relationship among those data. (What type of data to be stored?)
3. View level: The highest level of abstraction describes only part of entire database. (How to show the data?)

In the usual diagram the view level holds the external models or views, the logical level holds the conceptual model, and the physical level holds the internal (physical) models.

Users of a Database

The people who use the database can be categorized as a) Database users and b) Database administrator (DBA). Database users are of 4 different types:

1. Naive users: These are the unsophisticated users who interact with the system by invoking one of the application programs that have been written previously. E.g. consider a user who checks for account balance information over the World Wide Web. Such a user accesses a form, enters the account number and password etc. And the application program on the internet then retrieves the account balance using given account information which is passed to the user.
2. Application programmers: These are computer professionals who write application programs, used to develop user interfaces. The application programmer uses Rapid Application Development (RAD) toolkit or special type of programming languages which include special features to facilitate generation of forms and display of data on screen.
3. Sophisticated users: These users interact with the database using database query language. They submit their query to the query processor. Then Data Manipulation Language (DML) functions are performed on the database to retrieve the data. Tools used by these users are OLAP (Online Analytical Processing) and data mining tools.
4. Specialized users: These users write specialized database applications to retrieve data. These applications can be used to retrieve data with complex data types e.g. graphics data and audio data.

Database Administrator (DBA)

A person who has central control over data and programs that access the data is called DBA. DBA functions are given below:

1. Schema definition: DBA creates database schema by executing Data Definition Language (DDL) statements.
2. Storage structure and access method definition.
3. Schema and physical organization modification: If any changes are to be made in the original schema, to fit the need of your organization, then these changes are carried out by the DBA.
4. Granting of authorization for data access: DBA can decide which parts of data can be accessed by which users. Before any user accesses the data, DBMS checks which rights are granted to the user by the DBA.
5. Routine maintenance: DBA has to take periodic backups of the database, ensure that enough disk space is available to store new data, ensure that performance of DBMS is not degraded by any operation carried out by the users.

SQL

SQL stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database.

Relational Model

The most popular data model in DBMS is the Relational Model. It is more scientific a model than others. This model is based on first-order predicate logic and defines a table as an n-ary relation. The main highlights of this model are:

1. Data is stored in tables called relations.
2. Relations can be normalized.
3. In normalized relations, values saved are atomic values.
4. Each row in a relation contains a unique value.
5. Each column in a relation contains values from a same domain.

In a relation (table), each column is an attribute (field) and each row is a tuple (record).

Key

A key is an attribute (also known as column or field) or a combination of attribute that is used to identify records. Sometimes we might have to retrieve data from more than one table, in those cases we require to join tables with the help of keys. The purpose of the key is to bind data together across tables without repeating all of the data in every table. Such an attribute is called a key attribute, and its values can be used to identify each entity uniquely. For example, the Name attribute is a key of the COMPANY entity type because no two companies are allowed to have the same name. For the PERSON entity type, a typical key attribute is SocialSecurityNumber. Sometimes, several attributes together form a key, meaning that the combination of the attribute values must be distinct for each entity. If a set of attributes possesses this property, we can define a composite attribute that becomes a key attribute of the entity type. The various types of key with examples in SQL are mentioned below. (For examples suppose we have an Employee table with attributes 'ID', 'Name', 'Address', 'Department_ID', 'Salary'.)

(I) Super Key - An attribute or a combination of attribute that is used to identify the records uniquely is known as Super Key. A table can have many Super Keys. Examples of Super Key: (1) ID, (2) ID, Name, (3) ID, Address, (4) ID, Department_ID, (5) ID, Salary, (6) Name, Address, (7) Name, Address, Department_ID, and so on, as any combination which can identify the records uniquely will be a Super Key.

(II) Candidate Key - It can be defined as minimal Super Key or irreducible Super Key. In other words an attribute or a combination of attribute that identifies the record uniquely but none of its proper subsets can identify the records uniquely. Examples of Candidate Key: (1) ID, (2) Name, Address. For the above table we have only two Candidate Keys (i.e. Irreducible Super Key) used to identify the records from the table uniquely. ID can identify the record uniquely and similarly combination of Name and Address can identify the record uniquely, but neither Name nor Address can be used to identify the records uniquely as it might be possible that we have two employees with similar name or two employees from the same house.

(III) Primary Key - A Candidate Key that is used by the database designer for unique identification of each row in a table is known as Primary Key. A Primary Key can consist of one or more attributes of a table. E.g. of Primary Key: Database designer can use one of the Candidate Keys as a Primary Key. In this case we have 'ID' and 'Name, Address' as Candidate Keys, we will consider 'ID' as the Primary Key as the other key is the combination of more than one attribute.

(IV) Foreign Key - A foreign key is an attribute or combination of attribute in one base table that points to the candidate key (generally it is the primary key) of another table. The purpose of the foreign key is to ensure referential integrity of the data i.e. only values that are supposed to appear in the database are permitted. E.g. of Foreign Key: let us consider we have another table i.e. Department table with attributes 'Department_ID', 'Department_Name', 'Manager_ID', 'Location_ID' with Department_ID as a Primary Key. Now the Department_ID attribute of Employee table (dependent or child table) can be defined as the Foreign Key as it can reference the Department_ID attribute of the Departments table (the referenced or parent table). A Foreign Key value must match an existing value in the parent table or be NULL.

(V) Composite Key - If we use multiple attributes to create a Primary Key then that Primary Key is called Composite Key (also called a Compound Key or Concatenated Key). E.g. of Composite Key, if we have used 'Name, Address' as a Primary Key then it will be our Composite Key.

(VI) Alternate Key - Alternate Key can be any of the Candidate Keys except for the Primary Key. E.g. of Alternate Key is 'Name, Address' as it is the only other Candidate Key which is not a Primary Key.

(VII) Secondary Key - The attributes that are not even the Super Key but can be still used for identification of records (not unique) are known as Secondary Key. E.g. of Secondary Key can be Name, Address, Salary, Department_ID etc. as they can identify the records but they might not be unique.

SQL Commands

SQL has the different types of commands that are given below.

1. DDL (Data Definition Language) - A database schema is specified by a set of definitions expressed by a special language called DDL. Examples of DDL commands are given below.

CommandUse
CREATEto create objects in the database
ALTERalters the structure of the database
DROPdelete objects from the database
TRUNCATEremove all records from a table, including all spaces allocated for the records are removed
COMMENTadd comments to the data dictionary
RENAMErename an object

2. DML (Data Manipulation Language) - This language enables user to access or manipulate data as organized by appropriate data model. Procedural DML or Low level: DML requires a user to specify what data are needed and how to get those data. Non-Procedural DML or High level: DML requires a user to specify what data are needed without specifying how to get those data.

CommandUse
SELECTretrieve data from a database
INSERTinsert data into a table
UPDATEupdates existing data within a table
DELETEdeletes records from a table, the space for the records remain
MERGEUPSERT operation (insert or update)
CALLcall a PL/SQL or Java subprogram
EXPLAIN PLANexplain access path to data
LOCK TABLEcontrol concurrency

3. DCL (Data Control Language) - Data Control Language statements. Some examples:

CommandUse
GRANTgives user's access privileges to database
REVOKEwithdraw access privileges given with the GRANT command

4. TCL (Transaction Control Language) - Transaction Control statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions.

CommandUse
COMMITsave work done
SAVEPOINTidentify a point in a transaction to which you can later roll back
ROLLBACKrestore database to original since the last COMMIT
SET TRANSACTIONchange transaction options like isolation level and what rollback segment to use

5. VDL (View Definition Language) - It specifies user views and their mappings to the conceptual schema.

6. SDL (Storage Definition Language) - This language is to specify the internal schema. This language may specify the mapping between two schemas.

Free CBSE Study Guides: Computer Science Database

Core Study Kit: Computer Science Database

Explore essential learning tools for Computer Science Database. This curated collection features in-depth notes and targeted practice questions built around the active 2026 curriculum to streamline your daily revision.

NCERT-Aligned Solutions for Database

Designed around the official curriculum, these study guides guarantee standard compliance. Reviewing step-by-step solutions clarifies complex sub-topics within Database and demystifies standard marking schemes for Computer Science evaluations.

Next Steps in Your Exam Preparation

Maximize your grade potential by utilizing Computer Science practice papers in tandem with these structured notes. All printable assignments and interactive mock tests on our platform are updated for the 2026 session and available free of charge.

FAQs

Where can I find the most advanced study material for [current-page:node:field_board] [current-page:node:field_class] Computer Science for 2026-27?

The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.

What does the 2026-27 Computer Science study package for [current-page:node:field_class] include?

Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.

Is this study material enough for both [current-page:node:field_board] exams and competitive tests?

Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.

How should [current-page:node:field_class] students use this Computer Science material for maximum marks?

in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.

Can I download [current-page:node:field_class] Computer Science study notes in PDF for offline use?

All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.

Are the [current-page:node:field_class] Computer Science resources updated for the latest NEP guidelines?

Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.