Introduction to Network Administration & Fundamentals

Database Management System

software that allows users to define, create, maintain, and control access to databases.

Traditional file processing systems

 To store and manage data

Hierarchical DBMS

 Data is structured in a tree-like format.

Network DBMS

Uses a graph structure with multiple relationships between data records.

Relational DBMS (RDBMS)

Stores data in tables with relationships.

Object-Oriented DBMS

Stores data as objects, similar to _______ programming

Data Integrity and Consistency

Ensures accurate and up-to-date data

Efficient Data Access

Uses indexing and query optimization technique

Reduced Data Redundancy

Eliminates duplicate data storage.

Security and Authorization

Provides controlled access to data

Backup and Recovery

Supports automatic backup mechanisms.

High Initial Cost

Requires investment in hardware, software, and training

Complexity

Needs skilled administrators and developers.

Performance Overhead

Consumes more memory and processing power than file systems.

Real-world entity

A modern DBMS is more realistic and uses real-world entities to design its architecture.

Relation-based tables

DBMS allows entities and relations among them to form tables.

Isolation of data and application

A database system is entirely different than its data.

Less redundancy

DBMS follows the rules of normalization, which splits a relation when any of its attributes is having redundancy in values.

Consistency

It is a state where every relation in a database remains consistent.

Query Language

DBMS is equipped with __________ , which makes it more efficient to retrieve and manipulate data.

ACID Properties

• DBMS follows the concepts of Atomicity, Consistency, Isolation, and Durability.

• These concepts are applied on transactions, which manipulate data in a database.

Multiuser and Concurrent Access

DBMS supports multi-user environment and allows them to access and manipulate data in parallel

Multiple views

DBMS offers ________ views for different users.

Security

Features like multiple views offer_________ to some extent where users are unable to access data of other users and departments

Administrators

They maintain the DBMS and are responsible for administrating the database.

Designers

are the group of people who actually work on the designing part of the database.

End Users

_____________ those who actually reap the benefits of having a DBMS