Database

  What is SQL? SQL stands for Structured Query Language. It is a programming language specifically designed for managing and manipulating relational databases. SQL allows users to store, retrieve, modify, and delete data from databases. It is widely used in the field of data management and is the standard language for interacting with relational database management systems (RDBMS). SQL provides a set of commands that enable users to perform various operations on databases. These operations include creating and modifying database schemas, inserting and updating data, querying the database to retrieve specific information, and defining relationships between tables. Some common SQL commands include: SELECT: Used to retrieve data from one or more tables based on specified criteria. INSERT: Used to add new records into a table. UPDATE: Used to modify existing records in a table. DELETE: Used to remove records from a table. CREATE: Used to create a new database, table, or other datab...

Embedded Data Manipulation Language (EDML) is a programming language that allows developers to embed data manipulation commands directly into the code of an application. This means that the code can interact with a database system by executing commands such as SELECT, INSERT, UPDATE, and DELETE statements without the need for an external program or tool. EDML is often used in the development of database-driven applications, where data is the core of the application. By embedding data manipulation commands in the code, developers can build powerful and flexible applications that can interact with the database system in real-time. EDML commands are executed by a database management system (DBMS) and are used to access, modify and retrieve data stored in a database. These commands can be written in the same programming language as the application code, or in a language specific to the DBMS being used. Overall, EDML is an important tool for developers who need to build database-driven appl...

Interactive Data Manipulation Language (IDML) is a type of programming language that allows users to interactively manipulate and retrieve data from a database system. IDML commands are used to retrieve, insert, modify, and delete data stored in a database. IDML is often used by end-users who do not have programming experience, as it provides a user-friendly interface for data manipulation. IDML commands are executed in real-time, allowing users to view the results of their queries immediately. Examples of IDML commands include SELECT, INSERT, UPDATE, and DELETE statements. The SELECT statement is used to retrieve data from one or more tables in a database, while the INSERT statement is used to insert new data into a table. The UPDATE statement is used to modify existing data in a table, and the DELETE statement is used to remove data from a table. Overall, IDML is an essential tool for data analysts, business intelligence professionals, and end-users who need to access and manipulate ...

Data Definition Language (DDL) is a set of SQL commands used to define and manipulate the structure of database objects such as tables, views, indexes, and sequences. It is a type of programming language that is used to create, modify, and delete database objects in a database management system (DBMS). DDL statements are used to define the schema of a database, which includes the data types of each field in a table, primary and foreign key constraints, and any other constraints on the data. DDL commands include CREATE, ALTER, and DROP statements. CREATE statements are used to create new database objects, ALTER statements are used to modify the structure of existing objects, and DROP statements are used to delete objects from the database. Overall, DDL plays an important role in the management and maintenance of a database by allowing database administrators to define and modify the database schema, ensuring the accuracy and consistency of data stored in the database.

MY CLASS EXPERIENCE REGARDING MY INFORMATION MANAGEMENT 1 CLASS: Hi, Good Day. I am Emmerson Reyes Aquino, and here is my class experience in my Information Management Class. Being in a class where you enjoy each and every company of your classmate while at the same time learning, is the best thing ever. Imagine enjoying while earning knowledge. A knowledge that you can use in the future. The memories and friends you had and hopefully still had in the future. The bond with my classmate and my teacher Ms. Mayer Sanchez is extremely euphoric.  I learn a lot in my Information Management class, all thanks to Mrs. Mayer Sanchez for being patience in teaching us, and for always making sure that every time she taught, we learn. She inserted a lot of knowledge in me like how Data Processing works, the DBMS, also the Concept of Information Management, the importance of Database and why do I need it, the Database Development Process and more, a knowledge that I’ll definitely bring and use in...

 A. FUNCTIONS OF DBMS A database management system (DBMS) is a software package designed to  de me, manipulate, retrieve and manage data in a database . A DBMS generally manipulates the data itself, the data format, field names, record structure, and file structure. It provides users and programmers with a systematic way to create, retrieve, update and manage data. B. ADVANTAGES OF DBMS Advantages of Database Management System (DBMS):   1. Better Data Transferring 2.  Better Data Security 3.  Better data integration 4.  Minimized Data Inconsistency 5.  Faster data Access 6.  Better decision making 7.  Increased end-user productivity 8.  Simple 9.  Data abstraction 10.  Reduction in data Redundancy C. DISADVANTAGES OF DBMS Disadvantages of Database Management System (DBMS): 1. Increased Cost:       1.  Cost of Hardware and Software      2.  Cost of Staff Training      3....