A. ENGAGE

Instruction: Based on your own understanding, kindly define the following terminologies: 

A. DATA DEFINITION LANGUAGE 

Data Definition (DDL) is capable of creating a framework for database by specifying the schema of the database. Its common uses include the creation and alteration of tables, indexes, files and columns within the database.

B. INTERACTIVE DATA MANIPULATION LANGUAGE 

Interactive Data Manipulation Language or IDML is designed to allow users to manipulate data in a specified database, specifying a series of commands on what to be executed by the database.

C. EMBEDDED DATA MANIPULATION LANGUAGE

Embedded Data Manipulation Language or EDML is typically embedded within another programming or scripting language and provides a set of commands that an be used to manipulate data structures and perform data analysis tasks.

B. EXPLORE & EXPLAIN

1. What are the basic sql expression? 

The basic sql expressions: SELECT to extract data from the database, UPDATE to update data in a database, DELETE to delete a data from a database, INSERT INFO to insert a new data into a database, CREATE DATABASE to create a new database and etc.

2. What is the difference between simple equijoin and natural join? 

equjoin is a join operation that matches records between two tables based on the equality operator "=" while natural join is also a join operation that matches records, but unlike the equijoin, this is based between two based on columns with the same name without requiring any specified join condition.

3. What are the different types of join?

The different types of join in sql are the inner join, left outer join, right outer join and full outer join.

4. What are the different components of sql structure?

The different components of sql are the DML or Data Manipulation Language, DDL or the Data Definition Language and DCL or the Data Control Language.

5. What is the different between write and fetch transaction? 

The write transaction modifies data in a database, while the fetch transaction retrieves data from a database without modifying it.

C. ELABORATE & EVALUATION

Answer the following questions: Identification

1. Consists of a predicate that involves the attributes of the relations described in the From clause.

WHERE clause

2. Combinations of all the relations. 

SQL Join

3. Is defined as a distinct activity within a computer system that reads or modifies the content of a database.

Database 

4. A comprehensive language that has its own DDL and DML components. 

SQL or Structured Query Language

5. Is used to list the attributes needed to be included in the output of the query ate statements in query language. 

SELECT command