CFD module 6

This is the standard language of DBMS in storing, updating and retrieving data in the database.

SQL

What are the 3 common clauses for SQL?

Select, From, Where

This clause identifies the columns or fields to be displayed.

Select

This clause identifies the table or relation where the data is to be retrieved.

From

This clause identifies some criteria in retrieving data in the database.

Where

What does DML stand for?

Data Manipulation Language

What does DDL stand for?

Data Definition Language

This command ensures that transactions are either completed or rolled back.

Transaction controls

These are used to control access to the database and concerns about the creation of user permissions.

Security statements

Used to add, access and process data stored in the computer database

Database management system

This is an Open Source SQL database management system developed, distributed and supported by Oracle Corporation.

MySQL

This stores data into tables consisting of rows and columns. It is govern by the rules in relationship such as one-to-one, one-to-many and many-to-many

Relational database