Posts

Showing posts from February, 2023

BLOGGING EXERCISES ASSIGNMENT - LABORATORY

Image
BLOGPOST #1 Monday, January 23, 2023, was the first day of my Information Management 1 class, and I have to say I'm excited to start learning about the fundamentals of information management. Mrs. Mayer gave us an overview of the course and its objectives. She emphasized the importance of information management in today's digital age, and how it plays a critical role in an organization's success.   We discussed the difference between data and information. I learned that data is raw and unorganized, while information is data that has been processed and organized to be meaningful. We focused on Information Management Systems, which are essential tools for managing and processing data. We learned about the different types of Information Management Systems, including Transaction Processing Systems, Management Information Systems, and Decision Support Systems.

ACTIVITY TASK MODULE 1 INFORMATION MANAGEMENT LECTURE

Image
 A. ENGAGE a. Functions of DBMS 1. Data Dictionary Management 2. Data Storage Management 3. Data transformation and presentation 4. Security Management 5. Multi User Access Control 6. Backup and Recovery Management 7. Data Integrity Management 8. Database Access Languages and Application Programming Interfaces 9. Database Communication Interfaces b. Advantages of DBMS A database management system(DBMS) may store and retrieve data in a series of manners.  A database management system(DBMS) is a reliable manager for handling numerous applications requiring identical data.  Data Integrity and Security are guaranteed by DBMS. The DBMS implements integrity contraints to provide a high degree of protection against unauthorized access to information. c. Disadvantages of DBMS The expense of DBMS hardware and software is enormously expensive which impacts your organization's overall budget.  A database management system(DBMS) is inadequate for doing complex mathematical calcu...

ACTIVITY TASK MODULE 1 INFORMATION MANAGEMENT LABORATORY

Image
 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...

Functions, Advantages, and Disadvantages

Image
  Functions of DBMS DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. The most important functions of Database Management System are 1. Data Dictionary Management One of the most crucial features of a database management system is data dictionary management. The DBMS searches the data dictionary for the necessary data component structures and relationships, saving you from having to code such intricate associations manually for each program. 2. Data Storage Management The creation and management of the intricate structures needed for data storage is one of the DBMS capability, which frees you from the challenging process of specifying and implementing the physical data characteristics. 3. Data transformation and presentation The DBMS converts inputted data into the necessary data structures. You are relieved of the burden of differentiating between the logical data format and the physical data format by the DBMS. In ...