(5-07-21)STARTING WITH MYSQL

DATABASE:                                                                                                                                                 A  DATABASE  MAY  BE  DEFINED  AS  A  COLLECTION  OF  INTERRELATED  DATA STORED  TOGETHER  TO  SERVE  MULTIPLE  APPLICATIONS .

FILE-BASED SYSTEM:                                                                                                                             A  FILE  BASED  SYSTEM  OR  A  FLAT FILE OR A FLAT DATABASE STORES ALL THE DATA IN ONE BIG FILE.

LIMITATIONS OF FILED-BASED APPROACH:

1) DATA REDUNDANCY :  REFERS TO THE STORAGE OF THE SAME DATA MULTIPLE TIMES.

2) DATA INCONSISTENCY : MULTIPLE COPIES OF THE SAME DATA CAUSED BY DATA REDUNDANCY IS CALLED DATA INCONSISTENCY.

3) DATA ISOLATION : REFERS TO A SITUATION WHERE DATA OF ONE FILE CANNOT BE MAPPED TO OTHER RELATED FILE IN THE ABSENCE OF LINKS OR MAPPINGS OR COMMON FORMATS.

4) DATA DEPENDENCE : THE CLOSE RELATIONSHIP BETWEEN DATA STORED IN FILES AND THE SOFTWARE PROGRAMS THAT UPDATE AND MAINTAIN THOSE FILES IS CALLED DATA DEPENDENCE.

# OTHER DEFINATION OF DATABASE : *(VERY IMPORTANT)

WORDS COLOURED IN RED ARE IMPOSTANT.

A DATABASE IS AN  ORGANISED COLLECTION OF  STRUCTURED  INFORMATION ,OR DATA,TYPICALLY STORED ELECTRONICALLY  IN  A  COMPUTER  SYSTEM  AT  A CENTRAL  LOCATION.

# DATABASE MANAGEMENT SYSYTEM (DBMS)

DBMS IS A SOFTWARE SYSTEM  DESIGNED TO MAINTAIN A DATABASE AND PROVIDE DATA MANAGEMENT SERVICE.