Information Management - JAVIER JOHN IVERSON S.

JAVIER, JOHN IVERSON S.

BSSCS 1D

 DATA DEFINITION LANGUAGE (DDL):

The Data Definition Language (DDL) is a group of commands in SQL (Structured Query Language) that helps create, change, or remove database objects like tables, indexes, views, and rules. It's like the plans for building a house. It tells us how to make rooms (tables), what each room is for (columns and their types), and the rules for organizing things (constraints).











 INTERACTIVE DATA MANIPULATION LANGUAGE (IDML):

The Interactive Data Manipulation Language (IDML) is a set of SQL commands that lets us handle and change data in a database. It's like the tools we use to move, arrange, or clean furniture in a house. We can add new stuff (insert data), rearrange what's there (update data), remove things (delete data), or just look around (retrieve data).










 EMBEDDED DATA MANIPULATION LANGUAGE (EDML):

The Embedded Data Manipulation Language (EDML) means using SQL commands inside a programming language like C, Java, or Python. It's like having workers who follow instructions (SQL commands) to handle, rearrange, or clean the house while you oversee things from your programming language.









Comments

Post a Comment

Popular posts from this blog

MIDTERM - LECTURE SEATWORK - JAVIER, JOHN IVERSON S.

Image
INFORMATION MODEL An information model is like a plan for organizing data, making it easier to understand and use. It helps us see how different pieces of information are connected. For instance, in a database, it shows how tables relate to each other. By using an information model, we can design better systems for storing and finding data. It's sort of like creating a map for how information should be organized and accessed. In short, information models help us manage data more effectively. DATA MODEL A data model is like a plan for organizing information so it will be easy to use. It puts data into groups called entities and shows how they're connected through diagrams. Entities are like collections of things, and attributes describe those things.  The model makes sure the data stays correct by checking that it's all linked properly. Plus, it lets us ask questions and get answers using queries, which are like requests for specific information from the data. There are 3 ma...
Read more