Acar_Activity Task Module 3_INFMNGT LECTURE

 

Activity Task Module 3_INFMNGT LECTURE


A. DATA DEFINITION LANGUAGE

Data Definition Language


The Data Definition Language (DDL) is used to offer commands for specifying data. 

Relationship schemes, removing relations, and generating indices are just a few examples.

It is used to create and modify the structure of objects in a database by interacting with database schema definitions. Unlike data manipulation language (DML) commands, which are used to modify data, DDL commands are used to change the database structure, such as establishing new tables or objects with all of their properties (data type, table name, etc.).



B. INTERACRTIVE DATA MANIPULATION LANGUAGE

Data Manipulation Language

A data manipulation language (DML) is a computer language family that includes commands that allow users to manipulate data in a database. Inserting data into database tables, accessing existing data, deleting data from existing tables, and changing existing data are all part of this manipulation.



C. EMBEDDED DATA MANIPULATION LANGUAGE

 Embedded SQL is a means of merging a programming language's computing capability with SQL's database manipulation capabilities. Embedded SQL statements are SQL statements that are written inline with the host language's program source code.


Thank you for reading!!



Comments

Post a Comment

Popular posts from this blog

Acar_Module-4 Blogging _INFMNGT LECTURE

Image
Module 4_INFMNGT LECTURE A. What is SQL? SQL is a language that is used to communicate with databases. We can use it to access and manipulate databases. SQL stands for Structured Query Language , and it is the standard language for relational database management systems, according to ANSI (American National Standards Institute). SQL can be used to insert, search, update, and delete records in a database. It may perform a variety of different tasks, including database optimization and maintenance. Here’s a list of some of the most commonly used  SQL commands : CREATE  – defines the database structure schema INSERT  – inserts data into the row of a table UPDATE  – updates data in a database DELETE  – removes one or more rows from a table SELECT  – selects the attribute based on the condition described by the WHERE clause DROP  – removes tables and databases
Read more

Acar_Module-6_INFMNGT

Image
  Module 6_INFORMATION MANAGEMENT_Blogging_Activity-1 A. XML The acronym XML stands for "extensible markup language." A markup language is a collection of codes, known as tags, that describe the text in a digital document. Hypertext Markup Language (HTML) is the most well-known markup language, and it is used to format Web pages. XML, a more flexible cousin of HTML, enables complicated business transactions to be conducted via the Internet. B. JSON JSON is a standard text-based format for encoding structured data that is based on JavaScript object syntax. It is often used for data transmission in web applications. It is a widely used data format for electronic data interchange, particularly for the interaction of web applications with servers. It's a language-independent data format. C. AJAX AJAX is a set of web development approaches that construct asynchronous web applications by utilizing multiple web technologies on the client side. Ajax allows web applications to tra...
Read more

Acar_Learning Task Module 1-Blogging

Image
  --Learning Task Module 1-- A. WHAT IS A DATABASE? A database is a structured collection of information or data that is often stored electronically on a computer system. A database management system (DBMS) is usually in charge of a database. The data and the DBMS, as well as the applications that are associated with them, are collectively referred to as a database system, which is frequently abbreviated to just "database." B. WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL?  Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. With Office 365, you are able to download the application to your hard drive and will also have access to the online version. C. WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS? Microsoft Access is a database management system (DBMS) used to store and manage data. Access is part of the Microsoft 365 suite, and is made for business and enterprise users.           D.THINK OF ATLEAST TWO...
Read more