Skip to content

Introduce to Database

DBMS and DB

Database (DB)

  • A database is an organized digital collection of structured information or data, stored electronically in a computer system

SQL

  • SQL means Structured Query Language.
  • We using SQL to control/manage DBMS and using DBMS to control our Database.

Database management system (DBMS)

  • DBMS means a software to manage a database.

Relational Database Management System (RDBMS)

  • An RDBMS (Relational Database Management System) is software used to store, manage, and retrieve data.
  • It's an database that build on top of the relational model, and it connected with many 2D Tables.

Properties of RDBMS

  • Using SQL Language to operate.
  • Using Table as a standardised format to store data.

RDBMS Example

Data Model of a database

Data Model of DBData Model of database

  • The Data Model of a Database is from Database > Table > Data.