1.8.3 Data Definition Language (DDL) and Data Manipulation Language (DML)
• show understanding that DBMS software carries out:
○ all creation/modification of the database structure using its DDL
○ query and maintenance of data using its DML
• show understanding that the industry standard for both DDL and DML is Structured Query
Language (SQL)
1.8.3.1 Data Definition Language
• write simple SQL commands using a sub-set of commands for:
○ creating a database
○ creating a table definition
○ changing a table definition
○ adding a primary key or foreign key to a table
All of the above using the SQL sub-set:
– CREATE DATABASE, CREATE TABLE
– ADD PRIMARY KEY
– ALTER TABLE
1.8.3.2 Data Manipulation Language
• interpret a given SQL script
• write a SQL script for querying or modifying data which are stored in (at most two) database
tables
All of the above using the SQL sub-set:
Queries:
○ SELECT, FROM, WHERE, ORDER BY, GROUP BY, INNER JOIN
Data maintenance:
○ INSERT INTO
○ DELETE FROM
○ UPDATE