ACTIVITY TASK MODULE 1 INFMNGT LECTURE

 I. LEARNING TASKS

A. ENGAGE
Instruction: Based on your own understanding, kindly define the following terminologies:

A. FUNCTIONS OF DBMS
  • Data Dictionary Management
  • Data Storage Management
  • Data Transformation and Presentation
  • Security Management
  • Multi user Access Control
  • Backup and Recovery Management
  • Data Integrity Management
  • Database Access Languages and Application Programming Interfaces
  • Database Communication interfaces
B. ADVANTAGES OF DBMS
    - There are many advantages of DBMS. Reduced data redundancy, data integrity, data independence, data security, data consistency, easier use of data, and less storage are the advantages of DBMS.

C. DISADVANTAGES OF DBMS
    - There are also many disadvantages of DBMS. Complexity, expense, vulnerability, size, training cost, compatibility, and locking-in of technology are the disadvantages of DBMS.

B. EXPLORE & EXPLAIN
Answer the following questions:
1. What are the different components of dbms?
  • Data
  • Hardware
  • Software
  • End User
2. What is the difference between data and information?
    - The difference between data and information is data is the raw material that can be processed for any computing machine. It is a collection of letters, numbers, or facts. While information is the data that has been converted into more useful or intelligent form. It is a processed data that provides value.


3. What is an overall system structure of a dbms?
    -  It is a database system is composed of several specialized modules that perform a
particular task or group of tasks. It consists of
  • File Manager
  • Database Manager
  • Query Processor
  • DML Precompiler
  • DDL Compiler


4. What are the different functions of dbms?
  • Data Information
  • Data Manipulation
  • Data Security and Integrity
  • Data Recovery and Concurrency
  • Data Dictionary
5. Who are the different users of dbms?
  • Application Programmers
  • Naive or Parametric Users
  • Specialized Users
  • Sophisticated Users
C. ELABORATE & EVALUATION
Answer the following questions: Identification
Database System 1. An automated system for maintaining records.

File Manager 2. Manages the allocation of disk storage space.

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

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

Query Processor 5. Translate statements in query language.


Comments

Post a Comment

Popular posts from this blog

CODE CAMP 2025: Season 3 – Frontend Development Category Webinar Series (Part 2 of 2)

Image
Name: Muni, Rodge Romer B. Course/Block: BSIT 4C Subject: ITC414 - IT Seminars and Educational Trips CODE CAMP 2025: Season 3 – Frontend Development Category Webinar Series (Part 2 of 2) I. Details of the Event Last August 30, 2025, I attended CODE CAMP 2025: Season 3 – Frontend Development Category Webinar Series (Part 2 of 2), a webinar organized by the TECHSAVVY Core Team in partnership with Workflow Co-Working Space. The session was led by a keynote speaker specializing in modern web development. The event focused on enhancing frontend skills and understanding updated tools, frameworks, and best practices for creating responsive, user-friendly web interfaces. II. Reflection on the Webinar (Learnings Gained) The webinar gave me a deeper understanding of how frontend development continues to evolve and how important it is to stay updated. The speaker discussed essential topics such as responsive design, component-based development, and the role of UI/UX in creating meaningful user ex...
Read more

ACTIVITY TASK MODULE 3 INFMNGT LECTURE

Image
I. LEARNING TASKS A. ENGAGE Instruction: Based on your own understanding, kindly define the following terminologies: A. DATA DEFINITION LANGUAGE - Data Definition Language (DDL) is a subset of SQL. It is a language for describing data and its relationships in a database. You can generate DDL in a script for database objects to: Keep a snapshot of the database structure. It is used to provide commands for defining relation schemes, deleting relations, and creating indices, among others. B. INTERACTIVE DATA MANIPULATION LANGUAGE - Interactive Data Manipulation Language is a collection of programming languages explicitly used to make changes to the database, such as: CRUD operations to create, read, update and delete data. Using INSERT, SELECT, UPDATE, and DELETE commands. C. EMBEDDED DATA MANIPULATION LANGUAGE - Embedded Data Manipulation Language is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQ...
Read more

BLOGPOST2 MODULE 1 - LECTURE

Image
BLOGGING Instruction: Based on your understanding, kindly explain the following: A. FUNCTIONS OF DBMS     - There are many functions of DBMS. Data storage management,  Creating a database for complex data and managing the data are two of DBMS's most crucial jobs. By giving the intricate data sets a structure, it relieves the user and makes it much easier for them to access and work with the data, Security Management, Database systems provide a high level of security measures using various security algorithms to keep the data safe and ensure the data privacy, Backup and Recovery Management,  the database system provides the features for backup and recovery management, Database Access Language and Application Programming Interface, a query language, often known as a database access language, is offered by DBMS. Non-procedural query languages are used to access databases and change data, Data Dictionary Management, It keeps both the data an...
Read more