Chapter 4

 Chapter 4: Structure Query Language(SQL)

        This is last chapter for Subject Database System. In this topic, we learned about the basic concepts of database model using entity relationship diagram and translating completed data models by applying normalization technique in logical database designs. We also learned how to apply Structured Query Language (SQL) for database manipulation using a database management system in practical works inclusive of a report within stipulated time frame. SQL is an example of a transform-oriented language, or a language designed to use relations to transform inputs into required outputs. As a language, the ISO SQL standard has two major components:

1. A Data Definition Language (DDL) for defining the database structure and controlling access to the data;
2. A Data Manipulation Language (DML) for retrieving and updating data.

This is an example of SQL platform

        Data Manipulation Language

        For these three Data Manipulation Language, the students need to make the syntax first from a question that given before make a table as result. 

1. SELECT: to query data in database.

2. INSERT: to insert data in table.

3. UPDATE: to update data in table.

4. DELETE: to delete data in table.

        1)SELECT

                SELECT is the most frequently used SQL command and has the following general form. SELECT is must be the first syntax on command.

An order of command in SQL

        2)INSERT

                INSERT will add new rows of data to a table.

Basic syntax for INSERT command

        3)UPDATE

                UPDATE will modifies existing data in table.

Basic syntax for UPDATE command

        4)DELETE

                DELETE will removes rows of data from a table.

Basic syntax for DELETE command

        We did our activities by individual that given by Madam Shamsiah, and the luckiest person will write their answer on whiteboard. The activities is about the different between SELECT, INSERT, UPDATE and DELETE. Besides, we need to do a syntax of comparison search condition which is very confusing. This is fun because we need to pick up a vote paper.

 

            As usual when 10 minutes or 15 minutes, we will do a Kahoot game. This Kahoot game was for the last time we played because we done our chapter for this suject that means we will sitting an examination within 3weeks. This Kahoot game won by Aizat, Roy and Fitri.