Information Management

  ---Activity Task Module 1--- ---Functions, Advantages and Disadvantages of DBMS--- A. Functions of DBMS *Data Definition -  The DBMS must be able to accept data definitions(external, internal and conceptual schemas, and all associated mappings) in source form and convert to the appropriate object form. *Data Manipulation -   The DBMS must be able to handle request from the user to retrieve and possibly update existing data in the database, or to add a new data to the database. *Data Security and Integrity -   The DBMS must be able to monitor user requests and reject any attempts to violate the security and integrity checks defined by the database administrator. *Data Recovery and Concurrency -  The DBMS must have the capability of recover from, or minimize the effects of a system crash. *Data Dictionary -   The DBMS must provide a system database called the database dictionary. B. Advantages of DBMS *Reduced Data Redundancy -  ...

  --Learning Task Module 1-- A. WHAT IS A DATABASE? A database is a structured collection of information or data that is often stored electronically on a computer system. A database management system (DBMS) is usually in charge of a database. The data and the DBMS, as well as the applications that are associated with them, are collectively referred to as a database system, which is frequently abbreviated to just "database." B. WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL?  Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. With Office 365, you are able to download the application to your hard drive and will also have access to the online version. C. WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS? Microsoft Access is a database management system (DBMS) used to store and manage data. Access is part of the Microsoft 365 suite, and is made for business and enterprise users.           D.THINK OF ATLEAST TWO...

-- Information Management 1 Class Experience-- I had a great time in our Information Management 1 class. I am delighted and grateful that Ma'am Mayer is still our teacher since we know how kind and compassionate she is to her students because she was our teacher last semester in one of our major subject, PC Troubleshooting Class. She begins our Information Management (LAB) session by praying and thanking God for the day. Then she let us have our orientation, and I was relieved that she still did not require us to open our cameras in order to save data. She discussed the do's and don'ts and showed us the 2nd Semester Calendar of Activities . After our orientation, she discussed and taught us about our topic, which is the  Database . I have learned that a database is a collection of information organized and presented to serve a specific purpose. Examples of a database are Telephone directory, Log-in / log-out and Record book. I also learned about the Components of the...