Computer Networks & Database Management Systems

Database Management Systems (DBMS)

A DBMS is software that allows for the creation, management, and manipulation of databases. It enables data storage, retrieval, and ensures data consistency and security.

Key Concepts:

Types of DBMS: Relational, NoSQL, Hierarchical
Data Models: ER Model, Relational Model
SQL Commands: SELECT, INSERT, UPDATE, DELETE

What is SQL?

SQL (Structured Query Language) is a language used to communicate with relational databases. It allows users to perform various operations, like retrieving, inserting, updating, and deleting data.

What is a primary key?

A primary key is a unique identifier for each record in a database table. It ensures that no duplicate records exist and that each entry is identifiable.