Why a Database ?

Question

Hello Ducks, I am wondering why do we use databases, I know you will say it is commonly used as a storage for datas such as MySql, but why using it ? instead of that let’s make a folder in PC > Desktop > and make a folder and put all datas there and use some Microsoft Word/Excel to edit it, if you can answer me it would be nice from your part.

Answer 1

Amine Laaboudi you're using Franglais?

Answer 2

Databases are useful for storing data that is not under your control. For example, in a website where users can log in and create accounts, all the account information is stored in a database. If it wasn't this way, each time an user sings up or changes his account information, a human should be modifying tables in excel. It wouldn't make sense to store data manually. SQL is used to automatically save data into properly organised data.

You should check this article out:
https://tomassetti.me/excel-and-dsls/

Answer 3

Make a folder in PC/Desktop, then use *whatever software* to edit it, is only good where the data wasn't meant to be shareable.

You can share the folder in your local network, but then again, the idea means that the *whatever software* needs to be installed whereever the data needs to be viewed or modified.

DBMS are built to deal with data. That is to accept, manipulate, store and serve data. Specific purpose softwares are relatively more reliable than general purpose office tools.

Answer 4

actually, when you create a file or files et li remplie par des data quelconque, ça s'appelle aussi une base de données, mais ça sa marche pas quand vous êtes besoin de manipuler des milliers de Gbs de data et *automatiquement* par exp {les opérations bancaires
Réservations hôtels, compagnies aériennes, achats en ligne, livres, magasins en ligne.. } et donc on a besoin d'un système de gestion de base de donnée qui permet de définir, créer, manipuler et partager une base de données entre plusieurs utilisateurs et applications...

Answer 5

How will you associate one file entry with another in a different file? For example, a customer in a customers spreadsheet with an order in an orders spreadsheet?

Answer 6

Thanks you guys, now I know a little bit better.