A key is a field, or combination of fields, in a database table used to retrieve and sort rows in the table based on certain requirements. Keys are defined to speed up access to data and, in many cases, to create links between different tables. uses of keys in the database: Primary Key: There can be […]
components of the database management system Table View Key & etc. Why use a DBMS? Data independence & security. Reduced application development time. Uniform data administration. Concurrent access & recovery from crashes.
The database Management system is an organized collection of interrelated and persistent data. Difference between flat file system & database management system? File Management System Easy-to-use system to store general files which require less security and constraints. Data Redundancy is more in a file management system. Data Inconsistency is more in a file […]