Sahan Lakshitha

Using MySQL Workbench Software or HediSQL Software to create a table in the database

Explain the DDL Query used to back up the created database.

Explain how to insert a new column with a DDL query and how to insert data into a created table.

Create a query statement relevant to updating, searching and creating a view of the data in tables

Create a database with DDL Query and explain how to create a table using the created database

Explain how to insert data into tables created using DDL Query

Explain how to create a table with foreign key using DDL Query.

Explain how to create a Relational Algebra Query using a Cartesian product related to a given need.

Explain how to create a Relational Algebra Query, Relational Algebra Query related to a given query

Explain how to create a Relational Algebra Query using Rename Operation related to a given need.

Explain how to create a Relational Algebra Query using Project Operation related to a given need.

Explain how to create a Relational Algebra Query using Select Operation related to a given need.

Create SQL View Query to suit the given requirements..

Create a query to modify a pre-created SQL View.

Create a query to remove a pre-created SQL View.

When creating an Inventory Control software, create an Insert Query Statement

Explain the relationship between tables created for storing data in Inventory Control software

Create an Insert Query Statement to enter data into tables created to store the details of the users

Explaining how to draw ER Diagram using MySQL Workbench software to create a table for storing

Explain uses MySQL Workbench Software or HeidiSQL Software how to create the tables required

Explain how to use the INNER JOIN with CHAR_LENGTH, CONCAT, UPPER, LOWER, AVG SQL Functions

Explain how to use ROUND, MIN, AVG SQL Functions and INNER JOIN uses the data in the Database Tables

Explain how to use MAX SQL Functions and INNER JOIN use the data in the Database Tables

Explain how to use COUNT SQL Functions and INNER JOIN use the data in the Database Tables.

Explain how to use the Average SQL Functions using the data in the Database Tables.

Explain how to use the data usage SUM SQL Functions in Database Tables.

Explain how to search for data by Sub Query and JOIN uses the data in the stored tables

Explain how to use Sub Query to search for data in data storage tables.

Explain how to use the JOIN keyword to join data storage, tables and how to search for data

Explain how to use SQL Functions, sub query such as maximum value, minimum value using given data.

Explain how to use SQL Functions such as maximum value minimum value data row count using given data

Explain how to use query statement to enter data, modify data, delete data, search data.

Explain how to create a database using Froward Engineering and graphically add data to the tables

Explain how to create a relationship between the tables in a normalized database created

Explain how to create a Normalized Database table as mentioned in the problem

Explain how to create a Relationship from the tables created as mentioned in the problem

Explain how to create an ER diagram for a given problem using the MySQL Workbench software

Explain how to create a table for storing information on products ,suppliers' bills, items purchased

Explain how to create a table for storing customer and supplier information as mentioned in problem

Explain how to create a table for storing employee information as mentioned in the problem

Create a Database and Table using MySQL Workbench Software or HeidiSQL Software.

Using the MySQL Workbench Software or HeidiSQL Software to create a database and table and add data

Using MySQL Workbench Software or HeidiSQL Software to create a database and table and add data

Using MySQL Workbench Software or HeidiSQL Software to create a Database and Table and insert data

Create a database with MySQL Workbench software or HeidiSQL software and use the Insert Query

Create a database with MySQL Workbench software or HeidiSQL software and insert data

Using MySQL Workbench software to create a table with a database and a table using the ER Diagram

Using MySQL Workbench software to create a table with a database and a table using the ER Diagram

Using MySQL Workbench Software with ER Diagram to create a database and table.

Using MySQL Workbench Software or HediSQL Software to create a table in the database.