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 […]

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 […]

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, […]

Relational Data Modeling for Database Systems Part – 3 Relational Languages So far in this series of the article the database structure have been considered, along with the relations or tables as well as the associations among the tables or relations. Currently, in this part of the article we will consider the different tactical methods to use for extracting the […]

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 […]

Relational Data Modeling for Database Systems Part – 1 Introduction The ideology of the relational data model was 1st defined by Dr. E. F. Codd in the year 1970, June in a paper titled as "A Relational Model of Data for Large Shared Data Banks‘, in his paper Dr. E. F. Codd planned the todays modern world relational data model […]

Information Modeling By means of Entity Relationship (ER) Method Part – 8 Creating the Simple Scheme As soon as the entities as well as associations have been recognized as well as demarcated, the first (1st) draft of the Entity Relationship (ER) diagram can be formed. This portion of the article will present the Entity Relationship (ER) diagram by means of […]

Information Modeling By means of Entity Relationship (ER) Method Part – 7 Identifying Information Objects The names must have the subsequent properties: · Exclusive · Having a sense to the end user · Enclosing the least total words which are desirable to exclusively as well as to exactly define the object. For entities as well as columns or attributes, names […]

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 […]

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 […]