Please enable JavaScript.
Coggle requires JavaScript to display documents.
difference between DATABASE and DBMS, . List 3 Desktop database and server…
difference between DATABASE and DBMS
Database:
A database is an organized collection of structured information or data that is stored electronically in a computer system.
It typically consists of tables, rows, columns, and relationships between data entities.
DBMS (Database Management System):
It manages the creation, maintenance, and use of databases.
Examples of popular DBMSs include MySQL, PostgreSQL, Oracle Database, Microsoft SQL Server, MongoDB, etc.
A DBMS is a software system that provides an interface for users and applications to interact with the database.
. List 3 Desktop database and server database.
Server Databases:
MySQL
PostgreSQL
Microsoft SQL Server
Desktop Databases
:
Microsoft Access
FileMaker Pro
SQLite
List 3 application that use the database.
Enterprise Resource Planning (ERP) Systems:
E-commerce Platforms:
Social Media Networks:
Explain the importance of using DBMS.
Organizes data efficiently.
Ensures data integrity and consistency.
Provides security against unauthorized access.
Allows easy data sharing and accessibility.
Optimizes data retrieval and query performance.