usage of index, user, data data administrator, database administrator .pptx

Usage of index in FMS and DBMS
Types of users
1. User or End User
2. Data Administrator
3. Database Administrator
Important tasks/responsibilities performed by DBA
data manipulation in DBMS system.

1. Index 1 user 2 data administrator 3 database administrator Data manipulation in DBMS

2. Usage of index in FMS and DBMS A data structure that is used by DBMS to locate a particular record in a file more quickly. Indexes are used to speed up the sorting and searching process. Some indexes are created automatically in the related tables when relationships are defined. The performance of database is improved with these indexes. The index may be created on primary key, secondary key and foreign key etc.

3. INDEX The indexes are stored in index file. DBMS uses this file to speed up the sorting and searching operations. However, indexes can slow down data entry and editing because the index file is also updated each time data is added or modified.

4. Types of users 1. User or End User 2. Data Administrator 3. Database Administrator

5. 1. User/End User persons who directly interact with database system. Use database application without technical knowledge of databases. Interact with the databases through an interface. Do not write any programs. Must have the knowledge of the installed software to be used.

6. 2. Data Administrator a person who is responsible for entire data of an organization. Develops overall functional requirements for database used in the organization. Authorizes access to the database and Controls and manages the whole database system. Establishes data standards and supervises the data distribution in the organization. Communicates with the user when necessary also conducts user training when required. Participate in developing data dictionary and preparing documentation Coordinates and monitors the use of database.

7. 3. Database Administrator Important person in development of any database system also responsible for the design, implementation, operation, management and maintenance of database. Must be technically competent and a good manager should have good communication skills . Managerial skills are important in planning, coordinating and carrying out different tasks. Technical skills are required to understand the complexity of hardware and software. Diplomatic skills are important in communicating with users and determining their needs.

8. Important tasks/responsibilities performed by DBA: Installation of database software Monitoring of database system Solution of any problem that occurs in the DBS Assigning permission to users to use DBS Taking regular backups of database Restoring the system in case of any problem or system crash

9. data manipulation in DBMS system. DBMS manipulates data as follows: It stores and manipulates data in tables or relations. DBMS may consist of one or many relations. The relations in relational database management systems are connected through different types of relationships. DBMS uses index to search the required data quickly and efficiently. DBMS usually uses structure query language (SQL) to perform different operations in the data. DBMS provides the facility to insert, modify, retrieve and delete new data in database.