DATABASE

1. Keys in DBMS

2. Key plays an important role in relational database; it is used for identifying unique rows from table. It also establishes relationship among tables.

3. Types of keys in DBMS

4. What is Database Architecture?

5. A Database Architecture is a representation of DBMS design. It helps to design, develop, implement, and maintain the database management system. A DBMS architecture allows dividing the database system into individual components that can be independently modified, changed, replaced, and altered. It also helps to understand the components of a database.

6. Types of DBMS Architecture

7. There are mainly three types of DBMS architecture: One Tier Architecture (Single Tier Architecture) Two Tier Architecture Three Tier Architecture

8. There are mainly seven different types of Keys in DBMS and each key has it’s different functionality: Super Key - A super key is a group of single or multiple keys which identifies rows in a table. Primary Key - is a column or group of columns in a table that uniquely identify every row in that table. Candidate Key - is a set of attributes that uniquely identify tuples in a table. Candidate Key is a super key with no repeated attributes. Alternate Key - is a column or group of columns in a table that uniquely identify every row in that table. Foreign Key - is a column that creates a relationship between two tables. The purpose of Foreign keys is to maintain data integrity and allow navigation between two different instances of an entity. Compound Key - has two or more attributes that allow you to uniquely recognize a specific record. It is possible that each column may not be unique by itself within the database. Composite Key - An artificial key which aims to uniquely identify each record is called a surrogate key. These kind of key are unique because they are created when you don't have any natural primary key. Surrogate Key - An artificial key which aims to uniquely identify each record is called a surrogate key. These kind of key are unique because they are created when you don't have any natural primary key.

9. Applications of Database Management System

10. 1. Banking: for storing customer information, account activities, deposits, payment details, loans, etc. 2. Manufacturing: for supply chain management, production tracking and inventory management 3. Finance: for storing information about stocks, sales, and purchases of financial instruments like stocks and bonds 4. Universities: for student information, course registrations, payroll and grades 5. Airlines: for reservations, ticket booking and schedule information

11. WHAT IS DATABASE ?

12. DBMS stands for Database Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data.

13. What is the need of DBMS?

14. Database systems are basically developed for large amount of data. When dealing with huge amount of data, there are two things that require optimization: Storage of data and retrieval of data.

15. Advantages of DBMS

16. 1. DBMS offers various techniques and powerful functions to efficiently store & retrieve data 2. DBMS serves as an efficient handler to balance the needs of multiple applications using the same data 3. Provides Uniform administration procedures for data management 4. Application programmers never exposed to details of data representation and storage 5. Offers Data Integrity and Security 6. DBMS implies integrity constraints to get a high level of protection against prohibited access to data 7. DBMS schedules concurrent access to the data in such a manner that only one user can access the same data at a time 8. Reduces Application Development Time