ACTIVITY TASK MODULE 1 INFORMATION MANAGEMENT LECTURE

 A. ENGAGE

a. Functions of DBMS

1. Data Dictionary Management
2. Data Storage Management
3. Data transformation and presentation
4. Security Management
5. Multi User Access Control
6. Backup and Recovery Management
7. Data Integrity Management
8. Database Access Languages and Application Programming Interfaces
9. Database Communication Interfaces

b. Advantages of DBMS

A database management system(DBMS) may store and retrieve data in a series of manners. A database management system(DBMS) is a reliable manager for handling numerous applications requiring identical data. Data Integrity and Security are guaranteed by DBMS. The DBMS implements integrity contraints to provide a high degree of protection against unauthorized access to information.


c. Disadvantages of DBMS

The expense of DBMS hardware and software is enormously expensive which impacts your organization's overall budget. A database management system(DBMS) is inadequate for doing complex mathematical calculations. Since most database management systems are difficult and complicated, employees must always be instructed on how to operate them. Many individuals using the same application simultaneously time potentially lead to data loss.


B.EXPLORE & EXPLAIN


1. What are the different components of dbms?

  • Storage engine
  • Query language
  • Query processor
  • Optimization engine
  • Metadata catalog
  • Log manager
  • Reporting and monitoring tools
  • Data utilities
2. What is the difference between data and information?

While information places such facts into context, data is a collection of facts.

3. What is an overall system structure of a dbms?

The database system is divided into three components: Query Processor, Storage Manager, and Disk Storage.

4. What are the different functions of dbms?

1. Data Dictionary Management
2. Data Storage Management
3. Data transformation and presentation
4. Security Management
5. Multi User Access Control
6. Backup and Recovery Management
7. Data Integrity Management
8. Database Access Languages and Application Programming Interfaces
9. Database Communication Interfaces

5. Who are the different users of dbms?
  1. Database Administrators (DBA)
  2. Database Designers.
  3. System Analysts.
  4. Application Programmers / Back-End Developers.
  5. Naive Users / Parametric Users.
  6. Sophisticated Users.
  7. Casual Users / Temporary Users.

C. ELABORATE & EVALUATION


Database Management System 1. An automated system for maintaining records.

Disk Allocation 2. Manages the allocation of disk storage space.

Data Sharing 3. Stored in a database is both integrated and share.

Database Users 4. Refers to the people whose jobs require access to the database system for
querying, updating, and generating useful reports.

Query Language Processor 5. Translate statements in query language.

Comments

Post a Comment