parzival1105

[parzival1105]

Information Management 1 LECTURE

Title: Introduction to Database Management

A. ENGAGE Activity 1: Blogging A blog is a discussion or informational website published on the World Wide Web consisting of discrete, often informal diary-style text entries. Posts are typically displayed in reverse chronological order, so that the most recent post appears first, at the top of the web page. Materials Needed: PC/Laptop/Smart phone, Internet Connection and Browser Instruction: Based on your own understanding, kindly define the following terminologies: A. FUNCTIONS OF DBMS B. ADVANTAGES OF DBMS C. DISADVANTAGES OF DBMS

The functions of a DBMS include concurrency, security, backup and recovery, integrity and data descriptions.

The advantages of database management include improved data integrity, consistency, and security, efficient data access and sharing, and reduced data redundancy and inconsistency.

Disadvantages of DBMS: Cost, Complexity, Scalability, Dependence on technology, Performance issues, Data integration, Security, Data loss/corruption.

B. EXPLORE & EXPLAIN Answer the following questions:

What are the different components of dbms?

The five major components of a database are hardware, software, data, procedure, and database access language.

What is the difference between data and information?

Data is a collection of facts, while information puts those facts into context.

What is an overall system structure of a dbms?

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

What are the different functions of dbms?

The acronym CRUD is commonly used in software development to describe the four basic functions of a database: Create, Read, Update, and Delete. These operations are fundamental to many applications.

Who are the different users of dbms?

In simple terms, if we understand, any person who uses a database and avails benefits from the database is known as database user in DBMS.

C. ELABORATE & EVALUATION Answer the following questions: Identification ____________1. An automated system for maintaining records. ____________2. Manages the allocation of disk storage space. ____________3. Stored in a database is both integrated and share. ____________4. Refers to the people whose jobs require access to the database system for querying, updating, and generating useful reports. ____________5. Translate statements in query language.

database system

file manager

data

end user

Sophisticated Users (SQL)