Posts

Showing posts from March, 2023

ACTIVITY TASK MODULE 3 INFMNGT LECTURE

Image
I. LEARNING TASKS A. ENGAGE Instruction: Based on your own understanding, kindly define the following terminologies: A. DATA DEFINITION LANGUAGE - Data Definition Language (DDL) is a subset of SQL. It is a language for describing data and its relationships in a database. You can generate DDL in a script for database objects to: Keep a snapshot of the database structure. It is used to provide commands for defining relation schemes, deleting relations, and creating indices, among others. B. INTERACTIVE DATA MANIPULATION LANGUAGE - Interactive Data Manipulation Language is a collection of programming languages explicitly used to make changes to the database, such as: CRUD operations to create, read, update and delete data. Using INSERT, SELECT, UPDATE, and DELETE commands. C. EMBEDDED DATA MANIPULATION LANGUAGE - Embedded Data Manipulation Language is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQ...