DBMS - is a software that enables an organization to centralize data, manage them efficiently, and provide access to the stored data by application programs
1. How a DBMS Solves the Problems of the Traditional File Environment
---DBMS reduces data redundancy and inconsistency by minimizing isolated file in which the same data are repeated. DBMS uncouples programs and data, enabling data to stand on their own.
2. Relational DBMS - most popular type of DBMS for today's PCs and larger computers and mainframes.
Microsoft SQL Server are relational DBMS for large mainframes and mid-range computers.
---Tuples, rows are commonly referred to as records, or in very technical terms, as tuples
--- Key Field, uniquely identifies each record so that record can be retrieved, updated and sorted.
---Primary key, each table in a relational database has one field that is designated as its primary key
---Foreign Key, essentially a lookup field
3. Operations of Relational DBMS - The Project operation creates a subset consisting of columns in a table, permitting the user to create new tables that contain only the information required.