Homework 6: DBMS - definitions

 DBMS 

1. What is DBMS?

2. What are the benefits of using DBMS?

3. Name and explain different Database views

4. How is a DBMS different from a Spreadsheet software (Excel)?

	DBMS	Spreadsheet
Store and retrieve data	✓
Store and analyse data		✓
Provide support for data organizing and selecting	✓
Provide support for complex calculation		✓
Efficient data handling	✓

(Database vs Spreadsheet - Advantages and Disadvantages | 365 Data Science, 2022)

Examples of DBMSs (DBMS (Database Management System) Definition, 2022) :

MySQL

PostgreSQL

Microsoft Access

SQL Server

FileMaker

Oracle

RDBMS

dBASE

Clipper

FoxPro

Reference list:

 

365 Data Science. 2022. Database vs Spreadsheet - Advantages and Disadvantages | 365 Data Science. [online] Available at: <https://365datascience.com/tutorials/sql-tutorials/database-vs-spreadsheet/> [Accessed 4 April 2022].

 

DBMS, A., 2022. Advantages of DBMS | Top 15 Advantages of DBMS You Should Know. [online] EDUCBA. Available at: <https://www.educba.com/advantages-of-dbms/> [Accessed 4 April 2022].

 

Ibm.com. 2022. IBM Docs. [online] Available at: <https://www.ibm.com/docs/en/zos-basic-skills?topic=zos-what-is-database-management-system> [Accessed 4 April 2022].

 

Techterms.com. 2022. DBMS (Database Management System) Definition. [online] Available at: <https://techterms.com/definition/dbms> [Accessed 4 April 2022].