Information Management

Module 4_INFMNGT LECTURE A. What is SQL? SQL is a language that is used to communicate with databases. We can use it to access and manipulate databases. SQL stands for Structured Query Language , and it is the standard language for relational database management systems, according to ANSI (American National Standards Institute). SQL can be used to insert, search, update, and delete records in a database. It may perform a variety of different tasks, including database optimization and maintenance. Here’s a list of some of the most commonly used  SQL commands : CREATE  – defines the database structure schema INSERT  – inserts data into the row of a table UPDATE  – updates data in a database DELETE  – removes one or more rows from a table SELECT  – selects the attribute based on the condition described by the WHERE clause DROP  – removes tables and databases

  Activity Task Module 3_INFMNGT LECTURE A. DATA DEFINITION LANGUAGE The Data Definition Language (DDL) is used to offer commands for specifying data.  Relationship schemes, removing relations, and generating indices are just a few examples . It is used to create and modify the structure of objects in a database by interacting with database schema definitions. Unlike data manipulation language (DML) commands, which are used to modify data, DDL commands are used to change the database structure, such as establishing new tables or objects with all of their properties (data type, table name, etc.). B. INTERACRTIVE DATA MANIPULATION LANGUAGE A data manipulation language (DML) is a computer language family that includes commands that allow users to manipulate data in a database. Inserting data into database tables, accessing existing data, deleting data from existing tables, and changing existing data are all part of this manipulation. C. EMBEDDED DATA MANIPULATION LANGUAGE   ...

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