Posts

Showing posts from March, 2023

DATABASE, MS EXCEL, AND MS ACCESS

Image
DATABASE, MS EXCEL, AND MS ACCESS By: Gonzales, Brian Gabriel E. What is a Database? A database is a grouping of information that is logically related and is set up such that it is simple to access, administer, and change. A database management system (DBMS) often controls how databases are accessed electronically from a computer system.   What Type of Software is Microsoft Office Excel? The Microsoft Office software package contains the spreadsheet program Microsoft Excel. With the use of both simple and advanced arithmetic operations and functions, spreadsheets let users manipulate tables of numbers that are organized in rows and columns. The application is compatible with several operating systems, including Windows, macOS, mobile devices, and tablets.    What Type of Software is Microsoft Access? A database management system and application organization service is Microsoft Access. Software developers and application developers use it mostly to create their programs using the progr

INFORMATION MANAGEMENT CLASS

Image
MY EXPERIENCE IN INFORMATION MANAGEMENT CLASS By: Brian Gabriel Gonzales Being a BS in Information and Technology student, I expected already that we'd have this kind of subject. Information management is all about teaching us how to manage, organize, sort out, and use the different types of information that we, as users, are receiving and giving off to the computer, device, or any other medium that we are using. At first, it's kind of hard to understand since it's our first time taking this class. The first lesson that we learned is about databases, since that is the main purpose of this subject. It's a little bit confusing for me because it has different definitions, but the main purpose of this is to organize data. And I'm looking forward to us making our own database for our project. Our information management class, both lecture and laboratory, is fun and exciting. It's just that I enjoy more the laboratory part since we are doing hands-on activities, and I

Information Management: DATABASE MANAGEMENT SYSTEM

Image
DATABASE MANAGEMENT SYSTEM By: Gonzales, Brian Gabriel E. What is a Database Management System?           The system software used to create and administer databases is referred to as a database management system (DBMS). End users can create, protect, read, update, and remove data in a database with the help of a DBMS. Topics Functions of DBMS Advantages of DBMS Disadvantages of DBMS Functions Of DBMS These are the operations of a database management system and how it works. Data Definition Data Manipulation Data Security and Integrity Data Recovery and Concurrency Data Dictionary DATA DEFINITION Metadata must be accepted in source form by the DBMS and converted to the proper object form. DATA MANIPULATION It is the ability of the DBMS to be able to process user requests to access, update already-existing data in the database, and add new data. DATA SECURITY AND INTEGRITY Any efforts to bypass the security and integrity tests specified by the database administrator must be rejected by