Information Management Blogs

 What is SQL? SQL (Structured Query Language) is a programming language designed for managing and manipulating relational databases. It is widely used in the field of database management systems (DBMS) to create, modify, and retrieve data from databases. SQL provides a standardized way to interact with databases and is supported by various database management systems such as MySQL, PostgreSQL, Oracle, Microsoft SQL Server, and SQLite, among others. It consists of a set of commands and statements that allow users to define and manipulate the structure and content of databases.

 A. DATA DEFINITION LANGUAGE In my own Understanding, DATA DEFINITION LANGUAGE is  a language that is used to modify data and define data structures . For instance, the DDL commands could be used to remove, add, or modify tables within a database. B. INTERACTIVE DATA MANIPULATION LANGUAGE Data Manipulation Language represents a set of programming languages that are explicitly used to change the database, such as CRUD operations to create, read, update, and delete data. INSERT, SELECT, UPDATE, and DELETE commands are used. C. EMBEDDED DATA MANIPULATION LANGUAGE   Embedded SQL is a technique for merging a programming language's computing capability with SQL's database manipulation skills. Embedded SQL statements are SQL statements that are written directly within the source code of a program written in the host language.

 My class experience in Information Management my experience in info management is not that great because at first I don't really enjoy the subject but as few weeks past by it's growing on me and it makes it more interesting in learning databases.  learning how databases works it gives me a little motivation to understand how it works and how they are processed. First few weeks were difficult because of adjustments and new faces to familiarize with. Because of the new things going on in Gordon College or in CCS, I have met a lot of people to help me in understanding the things that I don't know. I'm looking forward to learning more about this topic after our teacher gave us an overview of the subjects and activities in her class during the first week. I attend information management lessons every Wednesday and Thursday. At first, I didn't think this subject would be interesting, but after a few weeks, I had learned a lot about databases, how they function, and why d...

My Own Understanding about DBMS A. Functions of DBMS A database management system (DBMS) is a software system that enables users to efficiently organize, store, manage, and retrieve data. The primary function of a DBMS is to provide an interface between the user and the database, allowing users to interact with the data without needing to know the underlying technical details of how the data is stored and managed. B. Advantages of DBMS There are several advantages to using a DBMS, including: - Data consistency: A DBMS enforces data consistency by ensuring that all data in the database follows a predefined set of rules and constraints. - Improved data accessibility: A DBMS makes it easy to access and manipulate data from multiple locations and by multiple users simultaneously. - Enhanced data security: A DBMS provides security mechanisms to protect data from unauthorized access and modification. - Reduced data redundancy: A DBMS eliminates data redundancy by allowing data to be stored i...