Posts

Showing posts from March, 2023

My Information Management Class Experience

Image
After the first semester, I get to relaxed myself for a few days. Thinking back at times I get very stressed in school taking a lot of pressure, I think it was really worth it naman because I get to be in the dean's lister yey! Now, second semester midterm exam is nearly behind. Also, lots of responsibilities comes up that overwhelm me shortly but I've been doing my best to do it responsibly and manageably. For me studying is not that hard, although some of my subjects are not that easy, still I can manage to learn efficiently. I'm gonna share my experience with our Information Management 1 class, our professor was Ma'am Meyer–she was nice and teaches us very good. Our classes shift from face-to-face to online learning every week, alternately. This subject is awesome, it gives us a review about our previous learnings and also teaches us new lessons which are related to managing information. When it comes to submission of activities through online platforms, I always man...

DBMS and how useful it was

Image
WHAT ARE THE FUNCTIONS OF DBMS? DATA DEFINITION - it accepts data definitions(external, internal and conceptual schemas, and all associated mappings) in source form and convert to the appropriate object form. DATA MANIPULATION - it handle request from the user to retrieve and update existing data or to add a new data to the database. DATA SECURITY AND INTEGRITY - it monitor user requests and reject any attempts to violate the security and integrity checks defined by the database administrator. DATA RECOVERY AND CONCURRENCY - it has the capability to recover from, or minimize the effects of a system crash. DATA DICTIONARY - it provide a system database called the database dictionary. WHAT ARE THE PROS OF DBMS? REDUCED DATA REDUNDANCY - data redundancy is avoided by keeping a single copy of the data. DATA INTEGRITY - since a single copy of a particular data is stored in the database, you can be certain that the changes to the data will be reflected in all future uses of that data. ...

How do you manage a database?

Image
INTRODUCING : EXCEL & ACCESS WHAT IS A DATABASE?  It is a collection of information organized and presented to serve a specific purpose. WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL ?  Microsoft Excel is a spreadsheet that features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA).  WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS?  Microsoft Access is a database management system (DBMS) that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. WHAT ARE THE DIFFERENCES BETWEEN ACCESS AND EXCEL? Excel is a spreadsheet software program that is traditionally used to manage numerical information, it is used to build models for analyzing data, write simple and complex formulas to perform calculation and present data in a variety of charts. Meanwhile Access is an RDBMS program that can link and extract info...