Database Management System – Definition, Basic Database Terminologies, Forms of Database (SS3 NOTES)
Database Management System Definition, Basic Database Terminologies, Forms of Database Definition of Database and DBMS Database is a collection of related data organized for rapid search and retrieval. It can also be defined as a persistent, logically coherent collection of inherently meaningful data, relevant to some aspects of the real world. DBMS (Data Base Management System) : DBMS is an application software that controls the data in the database, including overall organization, storage, retrieval, security and data integrity. Examples of DBMS Packages (i) Dbase (ii) Rbase (iii) MS Access (iv) Oracle (v) Paradox (vi) MYSQL Server (vii) SyBase (viii) FOXPRO (ix) IDMS (x) System 2000. (xi) Ingres (xii) Postgres (xiii) NoSQL Basic Database Terminologies (i) Field: A field is a specific item of information containing a homogenous set of values throughout the table. Fields appear as columns in a table and as cells in a form. (ii) Record: an individual listi...