Database Topic 2 - Introduction to Database, DBMS, and Key Concepts

Q&A flashcards to review key concepts from the lecture notes on database, DBMS, data vs. information, and related topics.

What is a database?

A collection of related data, organized in a manner that allows access, retrieval, and use of that data.

What is DBMS?

Application software (or a collection of programs) that creates, maintains, accesses, and manages a database.

What is a database system?

An organization of components that defines and regulates the collections, storage, management and use of data in a database environment.

What is data?

A collection of unprocessed items (text, numbers, images, audio, video) that has no meaning until interpreted and processed.

What is information?

Processed data that is organized, meaningful, and useful.

Explain the IPO relationship in a database context.

Input provides data; Processing turns data into information; Storage holds data; Output presents information; the DBMS stores data and manages it within the database environment.

What are the five major components of a DBMS?

Data, Hardware, Software, People, and Procedures.

What does CRUDS stand for in the context of DBMS tasks?

Create, Read (Access/Search/Retrieve), Update (Edit/Modify), Delete, Store.

Give examples of DBMS software.

Microsoft Access, Oracle, DB2, SQL Server, LibreOffice Base, MySQL.

What is the relationship between a DBMS, a database, and a database system?

A database system or database application is formed by the combination of the DBMS and the database it manages.

What are common database applications mentioned in the notes?

Banking system, Airlines reservation system, Student registration system, Sales system, Human resources system, Order processing system, Inventory control system.

Why do businesses need databases?

To know customers, products, employees, debts, and to provide data to decision makers; data can range from MB to TB and must be stored, processed, and retrievable quickly.

Give examples of database domains in Education, Business, and Healthcare.

Education: School, Library, University databases. Business: Customer, Inventory databases. Healthcare: Patient, Medicine databases.

What are the 'Procedures' in DBMS components?

Instructions and rules that govern the design and use of the database, such as how to log on and how to back up.

What is the difference between raw data and information with an example?

Raw data are unprocessed items (e.g., 1957, H2SO4); information is the processed, meaningful interpretation (e.g., 1957 = year Malaysia gained independence; H2SO4 = chemical formula for sulfuric acid).