DATABASE MANAGEMENT - Class 10 Boards Informatics Practices

Database Management System (DBMS)

A Database Management System (DBMS) is a software tool designed to make data management easy, efficient, and secure. It allows users to store, organize, access, update, and manipulate large volumes of data in a structured manner. DBMS is essential for handling data in various real-life applications, such as Aadhaar card management, school records, and login systems.

Data, Information, and Database

Data refers to raw facts and figures, such as numbers or text, which have not yet been processed or organized. Information is derived from data when it is managed and presented in a meaningful…

Database Management System (DBMS)

A Database Management System (DBMS) is a software tool designed to make data management easy, efficient, and secure. It allows users to store, organize, access, update, and manipulate large volumes of data in a structured manner. DBMS is essential for handling data in various real-life applications, such as Aadhaar card management, school records, and login systems.

Data, Information, and Database

Data refers to raw facts and figures, such as numbers or text, which have not yet been processed or organized. Information is derived from data when it is managed and presented in a meaningful way. A database is a collection of logically related data and information, organized so that it can be easily accessed, managed, and updated.

• Data: Raw numbers, figures, or text (e.g., student marks).
• Information: Processed data (e.g., percentage of students passing).
• Database: Place where related pieces of information are stored and can be accessed, managed, and updated.

DBMS: Definition and Purpose

A DBMS is a software tool that simplifies the management of data by providing a structured environment for storing, retrieving, and manipulating data. It is used wherever data needs to be stored securely and accessed efficiently, such as in login systems, customer records, and government databases.

• DBMS: Tool in software form for easy data management.
• Functions: Makes data management easy, enables data to be presentable, and allows for secure access and updates.

Real-Life Applications and Users

DBMS is used in various real-life scenarios, including Aadhaar card management, login systems, and school software. The main users of DBMS are developers, administrators, and end users.

• Developers: Design and create DBMS and databases.
• Administrators: Manage and oversee database operations.
• End Users: Access and use information stored in the database.

Types of Databases: Flat File and Relational

Databases can be categorized based on their structure. Flat file databases consist of a single table, while relational databases contain multiple tables linked by relationships.

• Flat File Database: Single table, stores general information.
• Relational Database: Multiple tables, tables are linked (e.g., student info linked to marks tables).

Database Objects

Database objects are components within a DBMS that serve specific functions. The main objects are tables, queries, forms, and reports.

• Tables: Store data in rows and columns; building blocks of a database.
• Queries: Used to ask questions and retrieve data based on conditions.
• Forms: Input data into the database; entry point for data.
• Reports: Draw information from the database for presentation.

Data Types and Field Properties

Data types define the kind of data that can be stored in each field of a table. Field properties specify characteristics such as length, default value, and validation.

• Numeric Types: INT, BIGINT, SMALLINT, TINYINT, DECIMAL, NUMERIC, MONEY, SMALLMONEY, FLOAT, REAL.
  • INT: No decimal point.
  • FLOAT/REAL: Decimal values.
• Character Types: CHAR (up to 8000 characters), VARCHAR (variable length), NVARCHAR, TEXT.
• Date and Time Types: DATE, TIME, DATETIME.
• Boolean Type: Stores TRUE or FALSE values.
• Field Properties: Length, decimal places, default value, format, entry required (compulsory fields).

Keys in Relational Databases

Keys are used to uniquely identify records and establish relationships between tables. The main types are primary key, composite primary key, foreign key, candidate key, and alternate key.

• Primary Key: Unique identifier for each record (e.g., user name, roll number).
• Composite Primary Key: Combination of two or more fields to form a unique identifier.
• Foreign Key: Field in one table that links to the primary key in another table.
• Candidate Key: Fields that are eligible to become primary keys.
• Alternate Key: Unique field not chosen as primary key.

Referential Integrity and Relationships

Referential integrity ensures that relationships between tables are consistent. It requires that foreign key values in one table match primary key values in another.

• Referential Integrity: Foreign key must have a matching primary key; prevents accidental deletion or amendment of linked data.
• Parent Table: Table with actual data (primary key).
• Child Table: Table linked via foreign key.
• Relationship Types:
  • One-to-One: One record in a table linked to one record in another.
  • One-to-Many: One record linked to multiple records in another table.
  • Many-to-Many: Multiple records linked across tables.

Creating and Managing Databases and Tables

DBMS provides methods to create and manage databases and tables. Two main approaches are using wizard and design view.

• Wizard: Step-by-step process to create tables, select fields, set data types, and define keys.
• Design View: Manually define fields, data types, and properties.
• Steps for Creating a Table:
  1. Open DBMS software (e.g., LibreOffice Base).
  2. Create a new database or open an existing one.
  3. Use wizard or design view to define table structure.
  4. Set field names, data types, and properties.
  5. Define primary key.
  6. Save the table.

Performing Operations on Tables

DBMS allows various operations on tables, including inserting, editing, deleting, and sorting data.

• Inserting Data:
  • Open table in data view.
  • Select field and enter value.
  • Use TAB key to move between fields.
• Editing Data:
  • Open table in data view.
  • Enable edit mode.
  • Change values as needed.
• Deleting Data:
  • Open table in data view.
  • Select record to delete.
  • Right-click and choose delete.
• Sorting Data:
  • Open table in data view.
  • Select field to sort.
  • Choose ascending (A-Z) or descending (Z-A) order.
  • For multiple fields, use multi-sort option.

Queries and Data Retrieval

Queries are used to retrieve specific data from tables based on conditions. They help extract meaningful information and answer questions.

• Query: Asks questions to the database to retrieve records.
• Usage: Retrieve data based on conditions, search, update, or access information.

Field Properties and Validation

Field properties control how data is stored and validated in the database. They include length, decimal places, default values, and entry requirements.

• Length: Maximum number of characters allowed.
• Decimal Places: Specifies number of decimal digits for numeric fields.
• Default Value: Pre-set value for a field.
• Entry Required: Field must be filled; cannot be left empty.
• Format: Controls display and storage format.

Exam-Focused Takeaways

• DBMS is a software tool for easy data management.
• Data is raw facts; information is processed data; database stores logically related information.
• Main database objects: tables, queries, forms, reports.
• Data types and field properties must be set for each field.
• Keys (primary, composite, foreign, candidate, alternate) are essential for unique identification and relationships.
• Referential integrity ensures consistency between linked tables.
• Operations: insert, edit, delete, sort data in tables.
• Queries are used to retrieve and manipulate data.
• Field properties control data validation and storage.
• Wizard and design view are used to create tables.
• Relationships: one-to-one, one-to-many, many-to-many.
• Steps for each operation should be practiced for exam readiness.