3 posts tagged with "database"

View All Tags

SQL and defination of DDL, DML, DCL and DIL

samundrak

samundrak

JavaScript Dev

The first version of SQL was developed by IBM called Sequel as part of the System R project. SQL stands for structured query language and is a combination of simple english words. SQL is used as a language to communicate with database. Same SQL code can run on multiple database albeit some database have slightly different syntax than others but still they have to maintain specification of SQL.

Entity and Entity Relationship model

samundrak

samundrak

JavaScript Dev

ER or Entity Reletionship model is used to create and model the data which is simple, non technical and easily understood by people describing a diagram with relation. It helps us to analyze requirements systematically to produce a well designed database.