Author: Sunny Singh

SQL Server

Introduction to Structured Query Language (SQL) — Part — 2

Introduction to Structured Query Language (SQL) – Part – 2 Data Definition Language (DDL) in Structured Query Language (SQL) The Data Definition Language (DDL) is a part of Structured Query Language (SQL) which allows database tables or relations to be formed or removed. An individual can describe indexes, different keys, relationship among the different tables or relations, as well as […]

SQL Server

Introduction to Structured Query Language (SQL) — Part– 1

Introduction to Structured Query Language (SQL) – Part – 1 History of Structured Query Language (SQL) This article tries to put emphasis on the Structured Query Language (SQL), from both the aspects of extensive as well as expansive ways. Expansive way, meaning that it is applied at numerous stages of database communication, starting from a simple Admission Form Combo-Box right […]

SQL Server

Relational Data Modeling for Database Systems Part – 4

Relational Data Modeling for Database Systems Part – 4 Relational Algebra Relational algebra is a technical language containing a group of different operators. Every single operator takes one (1) or more (N) tables or relations as its input as well as yields only one (1) table or relation as its output. There are seven (7) rudimentary relational algebra operations present, […]

SQL Server

Relational Data Modeling for Database Systems Part – 2

Relational Data Modeling for Database Systems Part – 2 Relational Database Modeling Constrictions Reliability Constrictions Every single relational schema should fulfill the subsequent four (4) sorts of constrictions. A. Area constrictions Every single column or attribute A i should be an atomic data from Area ( A i ) for that column or attribute. The column or attribute, labeled as […]

SQL Server

Information Modeling By means of Entity Relationship (ER) Method Part – 6

Information Modeling By means of Entity Relationship (ER) Method Part – 6 Columns or Attributes Columns or attributes are information objects which either classify or define entities. Columns or attributes which classify entities are known as important columns or attributes. Columns or attributes which define an entity are known as non important columns or attributes. Important columns or attributes will […]

SQL Server

Information Modeling By means of Entity Relationship (ER) Method Part – 5

Information Modeling By means of Entity Relationship (ER) Method Part – 5 Phases in Constructing the Information Model Though Entity Relationship (ER) diagram lists as well as describes the concepts which are mandatory for building an information model, but still there is no regular manner for completing so. A number of practices insist on a bottom up progress method where […]