BlogPost#2 (LABORATORY)

 

ACTIVITY TASK MODULE 1 INFMNGT LABORATORY

A. ENGAGE

 Activity 1: Blogging

A.WHAT IS A DATABASE? 

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system,

B.WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL?

Microsoft Excel is a spreadsheet program that features calculation, graphic tools, pivot tables, and macro programming language support for Windows and Mac operating systems. See more on Excel with Microsoft 365.

C.WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS?

Microsoft Access is a well-known database management system produced by Microsoft and is part of the Microsoft 365 office suite. Microsoft Access combines Microsoft's relational Jet Database Engine with software development tools and a graphic user interface (GUI).

D.THINK OF ATLEAST TWO DIFFERENCES BETWEEN ACCESS AND EXCEL.

In general, Access is better for managing data: helping you keep it organized, easy to search, and available to multiple simultaneous users. Excel is generally better for analyzing data: performing complex calculations, exploring possible outcomes, and producing high quality charts.

B. EXPLORE & EXPLAIN

 Answer the following questions: 

1. What is Information management? 

Information management (IM) is the collection and management of information from one or more sources and the distribution of that information to one or more audiences.

2. What is a database? 

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system

3. What is database management system? 

Database Management Systems (DBMS) are software systems used to store, retrieve, and run queries on data. A DBMS serves as an interface between an end-user and a database, allowing users to create, read, update, and delete data in the database.

4. What are the difference between RDBMS and NON-RDBMS? 

To summarize the difference between the relational and non-relational databases: relational databases store data in rows and columns like a spreadsheet while non-relational databases store data don't, using a storage model (one of four) that is best suited for the type of data it's storing

5. What is object-oriented database?

An object-oriented database (OOD) is a database system that can work with complex data objects — that is, objects that mirror those used in object-oriented programming languages. In object-oriented programming (OOP), everything is an object.

C. ELABORATE & EVALUATION

 Answer the following questions: Identification

1.Microsoft Access

2.SQL Server

3.DBMS

4.RDBMS

5.Database