MIDTERM - LECTURE ACTIVITY TASK MODULE 1

 A. Engage


What tasks does a DBMS perform?
Data is stored, retrieved, and questioned using database management systems (DBMS), which are computer programs. An end-user and a database can communicate with each other through a database management system (DBMS), which enables users to add, read, edit, and remove data in databases.




The benefits of database management
systems enable users to swiftly,
efficiently, and securely transfer data
throughout a company. A data
management system makes it possible to access more accurate data by quickly responding to database requests.





The database management system's initial drawback is this. This is so that DBMS can function properly, which requires both a fast processor and a huge amount of memory. Because of the vast amounts of data that must be stored securely and safely in today's world across all industries.






B. EXPLORE & EXPLAIN

Answer the following questions:

1. What are the different components of dbms?

Components of a database management system

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?

Information is structured or ordered, while data is not. Data is a mass noun while information is an uncountable noun. Information, as opposed to data, is usually useful on its own. In general, data consists of numbers, statements, and characters in their unprocessed forms.


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

A database system is made up of three parts: Query Processor, Storage Management, and Disk Storage. Related data are organized into tables within a database; each table has rows (also known as tuples) and columns, similar to a spreadsheet.

4. What are the different functions of dbms?

Concurrent processing, security, backup and recovery, integrity, and data descriptions are among a DBMS's features. 

5. Who are the different users of dbms?

The different users of dbms are: 

Database Administrators (DBA)
System Analysts.
Naive Users / Parametric Users.
Casual Users / Temporary Users.
Sophisticated Users.
Application Programmers / Back-End Developers.
Database Designers.

C. ELABORATE & EVALUATION
Answer the following questions:
Identification
Database Management System (DBMS)  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.

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

Query Language Processor (QLP)  5. Translate statements in query language.

Comments

Post a Comment

Popular posts from this blog

Seminar Title: “4th Regional Cybersecurity Conference 2025: Cyber Secure Gens: Bridging Knowledge, Building Defenders Across All Ages”

Image
  IT Seminars and Educational Trips  Reflection Paper Name: Jon Aldrick D. Pagulayan                               Date: 10 /06/2025 Block & Yr.: BSIT – 4C   Seminar Title: “4th Regional Cybersecurity Conference 2025: Cyber Secure Gens: Bridging Knowledge, Building Defenders Across All Ages” I. Details of the event/activity             The event, titled " 4th Regional Cybersecurity Conference 2025 " provided a comprehensive program focused on the national cyber defense strategy and individual security practices. The conference was organized in coordination with the Cybercrime Investigation and Coordinating Center (CICC) and featured intelligence speakers. The plenary sessions covered different but connected topics.  Plenary 1: Click Clean: Cyber Hygiene for the Hyperconnected –emphasized ...
Read more

Hour of Code “Learn AI and Coding in a Fun & Engaging Way!”

Image
IT Seminars and Educational Trips  Reflection Paper Name: Jon Aldrick D. Pagulayan                               Date: 11 /4/2025 Block & Yr.: BSIT – 4C   Webinar Title: Hour of Code “Learn AI and Coding in a Fun & Engaging Way!” I. Details of the event/activity             My experience with the "Hour of Code: Learn AI and Coding in a Fun & Engaging Way!" webinar was both inspiring and helpful. The program aimed to introduce AI ideas and coding foundations in a creative and engaging manner. The seminar effectively described how AI technologies work behind the scenes and showcased easy yet entertaining methods for developing AI-based projects with coding platforms. II. Reflections on the webinar/activity give rise to (learnings)            This learning experie...
Read more

"Build Your First Game: Tools, Engines, and Skills You Need"

Image
IT Seminars and Educational Trips  Reflection Paper Name: Jon Aldrick D. Pagulayan                               Date: 10 /02/2025 Block & Yr.: BSIT – 4C   Webinar: "Build Your First Game: Tools, Engines, and Skills You Need" I. Details of the event/activity             The webinar, "Build Your First Game: Tools, Engines, and Skills You Need," introduced us to the essential resources for beginner game developers. The session focused on easy-to-use game engines like Unity, Godot, and GameMaker Studio, explaining how they simplify complex coding so students can concentrate on design. A core theme was the importance of starting small and learning the fundamental skills—such as planning and iteration—that underpin any successful game project II. Reflections on the webinar/activity give rise to...
Read more