ACTIVITY TASK MODULE 1 INFORMATION MANAGEMENT LABORATORY

 A. ENGAGE

a. What is a database?

In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage.

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.

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.

Access is often more effective at managing data because it makes it easier to keep it structured, searchable, and accessible to several users at once. In general, Excel is preferable for data analysis since it can handle complex computations, explore potential outcomes, and create excellent visualizations.

B. EXPLORE & EXPLAIN  

1. What is Information management?

-  Information management  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?

- In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage.

3. What is database management system?

- Database Management Systems are software systems used to store, retrieve, and run queries on data.

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

- To put it simply, relational databases store data in rows and columns like a spreadsheet, whereas non-relational databases don't, utilizing a storage model that is most appropriate for the type of data it's storing.

5. What is object-oriented database?

- An object-oriented database 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, everything is an object.

C. ELABORATE & EVALUATION

Microsoft Access 1. A Microsoft software product that is primarily a

data management tool (database software).

Database Management System 2. Software package for defining and managing a

database

Entity Relationship Model 3. Logical arrangement, independent table,

relationship.

Microsoft Excel 4. Is a spreadsheet software program that is

traditionally used to manage numerical information

Database 5. A collection of information organized and presented

to serve a specific purpose.