Database Management System (DBMS)
1. What is database? A database is a collection of information that is organized. So that it can easily be accessed, managed, and updated. 2. What is DBMS? DBMS stands for Database Management System. It is a collection of programs that enables user to create and maintain a database. 3. What is a Database system? The database and DBMS software together is called as Database system. 4. What are the advantages of DBMS? I. Redundancy is controlled. II. Providing multiple user interfaces. III. Providing backup and recovery IV. Unauthorized access is restricted. V. Enforcing integrity constraints. 5. What is normalization? It is a process of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the properties (1).Minimizing redundancy, (2). Minimizing insertion, deletion and update anomalies. 6. What is Data Model? A collecti...