Category: Database

  • Create a Database in MySQL

    May 2, 2017 No Comment

    There are two ways to create a database in MySQL 1) By executing a simple SQL query 2) By using forward engineering in MySQL Workbench In this tutorial we will learn both of the ways to create the database in MySQL. Create a Database by query method: Lets imagine we need to create a database with name […]

    Posted in: Database

  • ALGEBRA(Join) In RDBMS(RELATIONAL DATABASE MANAGEMENT SYSTEM)

    April 16, 2017 No Comment

    ALGEBRA In RELATIONAL DATABASE MANAGEMENT SYSTEM Relational Algebra Operators are mathematical functions used to retrieve queries by describing a sequence operations on tables or even databases(schema) involved. With relational algebra operators, a query is always composed of a number of operators, which each in turn are composed of relations as variables and return an individual abstraction […]

    Posted in: Database

  • RDBMS, OODBMS and ORDBMS with the Comparison

    May 22, 2016 No Comment

    RDBMS, OODBMS and ORDBMS with the Comparison is given as below points. Comparing the RDBMS with the OODBMS: These two types of data modeling is represented by the encapsulation(binds together the data and functions that manipulate the data, and that keeps both safe from outside interference and misuse) in the object of both is state and […]

    Posted in: Database