Technological Blog

  Relational databases are managed and worked on using the standard programming language SQL (Structured Query Language). It is frequently used to carry out a number of actions on databases, including adding, deleting, and changing tables and records.  Users can run SQL queries, which are used to extract particular data from databases. These queries might be as straightforward as simple data searches or as intricate as procedures involving several tables and conditions.  Database administrators, data analysts, and developers all utilize SQL to store, retrieve, and alter data. It is a vital tool for data management in contemporary enterprises and is widely utilized in a variety of sectors, including banking, healthcare, and retail. SQL is frequently used in various industries and applications where data storage and retrieval are essential. Some of the common areas where SQL is used are: 1. Business applications: SQL is used in business applications such as Enterprise Resou...

A. A database is an organized collection of structured data that is stored and managed in a computer system. It allows users to easily store, retrieve, manipulate and analyze large amounts of data. B. Microsoft Office Excel is spreadsheet software used for data analysis and management. It allows users to create and manipulate spreadsheets, perform calculations, create charts and graphs, and more. It is primarily used for numerical data analysis. C. Microsoft Office Access is a relational database management system (RDBMS) used to store and manage data. It allows users to create and manage databases, tables, queries, forms, reports, and more. It is primarily used for storing and managing large amounts of data. D. Two differences between Access and Excel are: Purpose: Excel is primarily used for numerical data analysis, while Access is used for storing and managing large amounts of data. Excel is ideal for performing calculations, creating charts, and analyzing data, while Access is idea...

 Activity task module no.3 A Data Definition Language (DDL) is a language used to define and manipulate the structure of a database. DDL statements are used to create, modify, and delete database objects such as tables, indexes, views, and stored procedures. DDL commands typically include statements like CREATE, ALTER, and DROP, which are used to create, modify, and delete database objects, respectively. These statements allow users to define the characteristics of each object, such as its name, data type, length, and other attributes. An Interactive Data Manipulation Language (IDML) is a type of programming language that allows users to interactively manipulate data stored in a database. IDML provides a set of commands and syntax that can be used to query and modify the data in a database. Unlike DDL, which is used to define and manage the structure of a database, IDML is used to manipulate the data within that structure. An Embedded Data Manipulation Language (EDML) is a type of ...

 ACTIVITY  TASK MODULE 1 INFMNGT (LECTURE) DBMS Functions 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 dictionary. ADVANTAGES OF DATABASE REDUCED DATA REDUNDANCY DATA INTEGRITY  DATA INDEPENDENCE  DATA SECURITY  DATA CONSISTENCY  EASIER USE OF DATA  LESS STO...

What is A DBMS  DATABASE MANAGEMENT SYSTEMS A Collection of Computer Programs that Allow Storage, Modification and Extraction of information from a Database.       DBMS Functions 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 dictionary. Advantages of DBMS Disadvantages of DBMS 1....

 - Its late January  when we Started our class about Information Management at first my thoughts on information Management was Like A Subject like Data Handling  But it turns out we're more Studying and learning Databases from what I've Learned Databases are A Collection of Information Organized and Presented to Serve a specific purpose, I also learned That Databases are everywhere from Banks,Schools,Social media  and more - I get confused at times because of how Vast The databases are and How broad Information management can be  but Our Instructor Ma'am Yheng helps us comprehend it precisely I wish we get to learn more next time about how to make our own Databases  - This time we are currently Learning ERDs pretty confusing sometimes but I'll definitely learn about it. there's more to learn at Information management. I hope one day I get to make a DATABASE - maybe this is what I'll feel while making a database ☝️ who knows?