MIDTERM - LECTURE ACTIVITY TASK MODULE 3

 I. LEARNING TASKS

 A. ENGAGE

A. Data Definition Language


What is a Data Definition Language (DDL)?


 - Using predefined commands and a particular syntax, Data Definition Language (DDL) is used to construct and modify the structure of objects in databases. Tables, sequences, locations, aliases, schemas, and indexes are some examples of these database objects.


B. Data Manipulation Language


- A Data Manipulation Language (DML) is a computer programming language used to add (insert), delete, and alter (update) data in a database. A DML is frequently a sublanguage of a larger database language such as SQL.

C. Embedded Data Manipulation Language


 - A technique known as Embedded SQL is used to incorporate inline SQL statements or queries into the source code of a programming language, sometimes referred to as a host language. This is a reliable and practical way of fusing a programming language's computing capability with SQL's particular data management and manipulation abilities.


B. EXPLORE & EXPLAIN

Answer the following questions:

1. What are the basic sql expression?

    A combination of one or more values, operators and SQL functions that results in to a value.

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

    Equi join has the column name of both the tables in the resulting table whereas natural join only has one of the column names in the resulting table.

3. What are the different types of join?

    Inner Join
    Outer Join (Left Join, Right Join)
    Self Join
    Cross Join

4. What are the different components of sql structure?

    Data Definition Language (DDL)
    Data Manipulation Language (DML)
    Data Control Language (DCL)
    Transaction Control Language (TCL)
    Data Query Language (DQL)

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

    Fetch is setup to grab information doing a transmit while Transaction is setup for changing data objects and can send the changes to the backend.

C. ELABORATE & EVALUATION
 Answer the following questions: Identification

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

Permutation 2. Combinations of all the relations.

Database Management System (DBMS) 3. Is defined as a distinct activity within a computer system that reads or modifies the content of a database.

Structured Query Language (SQL) 4. A comprehensive language that has its own DDL and DML components.

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

Comments

Post a Comment

Popular posts from this blog

Seminar Title: “4th Regional Cybersecurity Conference 2025: Cyber Secure Gens: Bridging Knowledge, Building Defenders Across All Ages”

Image
  IT Seminars and Educational Trips  Reflection Paper Name: Jon Aldrick D. Pagulayan                               Date: 10 /06/2025 Block & Yr.: BSIT – 4C   Seminar Title: “4th Regional Cybersecurity Conference 2025: Cyber Secure Gens: Bridging Knowledge, Building Defenders Across All Ages” I. Details of the event/activity             The event, titled " 4th Regional Cybersecurity Conference 2025 " provided a comprehensive program focused on the national cyber defense strategy and individual security practices. The conference was organized in coordination with the Cybercrime Investigation and Coordinating Center (CICC) and featured intelligence speakers. The plenary sessions covered different but connected topics.  Plenary 1: Click Clean: Cyber Hygiene for the Hyperconnected –emphasized ...
Read more

Hour of Code “Learn AI and Coding in a Fun & Engaging Way!”

Image
IT Seminars and Educational Trips  Reflection Paper Name: Jon Aldrick D. Pagulayan                               Date: 11 /4/2025 Block & Yr.: BSIT – 4C   Webinar Title: Hour of Code “Learn AI and Coding in a Fun & Engaging Way!” I. Details of the event/activity             My experience with the "Hour of Code: Learn AI and Coding in a Fun & Engaging Way!" webinar was both inspiring and helpful. The program aimed to introduce AI ideas and coding foundations in a creative and engaging manner. The seminar effectively described how AI technologies work behind the scenes and showcased easy yet entertaining methods for developing AI-based projects with coding platforms. II. Reflections on the webinar/activity give rise to (learnings)            This learning experie...
Read more

"Build Your First Game: Tools, Engines, and Skills You Need"

Image
IT Seminars and Educational Trips  Reflection Paper Name: Jon Aldrick D. Pagulayan                               Date: 10 /02/2025 Block & Yr.: BSIT – 4C   Webinar: "Build Your First Game: Tools, Engines, and Skills You Need" I. Details of the event/activity             The webinar, "Build Your First Game: Tools, Engines, and Skills You Need," introduced us to the essential resources for beginner game developers. The session focused on easy-to-use game engines like Unity, Godot, and GameMaker Studio, explaining how they simplify complex coding so students can concentrate on design. A core theme was the importance of starting small and learning the fundamental skills—such as planning and iteration—that underpin any successful game project II. Reflections on the webinar/activity give rise to...
Read more