Author: Sunny Singh

Pro Members SQL Server Standard Members

Database Development Life Cycle, Normalization, Errors and Security of Database – Part 2

TRIVIAL FUNCTIONAL DEPENDENCY A functional dependency is known as trivial when B is a subset of A. In a table or relation with the attributes or columns student name as well as student identification number (SIN), the name of the student is functionally dependent on the SIN, as this is the case for individual names. An SIN recognizes the student...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database Development Life Cycle, Normalization, Errors and Security of Database – Part 1

DATABASE DEVELOPMENT LIFE CYCLE (DDLC) The Database Development Cycle (DDLC) is a process of planning, applying, as well as preserving a database system to meet the tactical or operative information necessities of an enterprise or organization like – • Enhanced customer support as well as customer fulfillment. • Enhanced production managing. • Enhanced inventory managing. • More precise sales predictions....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 3

SQL (Structured Query Language) – Indexes Indexes are special search tables that allow the database search engine to speed up data recovery. In short, an index is a pointer to the data in a table. An index in a database is very much related to an index which is present at the end of any book. For example, if you...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 2

IBM DB2 Latest version 11.1. Developed in 1983. The language used is the C, C ++ assembler to write it. It is compatible with multiple versions of Windows, UNIX as well as Linux. Some functions are the following: It is very easy to install and configure, and the data is easily accessible. An individual can store the enormous amount of...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 1

What is SQL (Structured Query Language)? SQL is a structured query language, a computer language in which the data stored in a relational database is stored, manipulated and retrieved. The structured query language (SQL) is the default language of the relationship database system. All relational database management systems, such as MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 3

SQL (Structured Query Language) – Indexes Indexes are special search tables that allow the database search engine to speed up data recovery. In short, an index is a pointer to the data in a table. An index in a database is very much related to an index which is present at the end of any book. For example, if you...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 2

IBM DB2 Latest version 11.1. Developed in 1983. The language used is the C, C ++ assembler to write it. It is compatible with multiple versions of Windows, UNIX as well as Linux. Some functions are the following: It is very easy to install and configure, and the data is easily accessible. An individual can store the enormous amount of...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Different Software, Data types, Index and Operators applicable in Structured Query Language (SQL) – Part 1

What is SQL (Structured Query Language)? SQL is a structured query language, a computer language in which the data stored in a relational database is stored, manipulated and retrieved. The structured query language (SQL) is the default language of the relationship database system. All relational database management systems, such as MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database Models and Relational Algebra – Part 6

Expressions or Formulas The general expression of the tuple relational calculus is of the subsequent form: { t1.A1, t2·A2, tn·An, I COND (t1, t2 … tn, tn+j, 1n+2…. tn+m ) } here, t1, t2, 1n, 1n+2, tn+m are tuple variables, each An is an attribute or column of the table or relation on which the ranges as well as COND...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database Models and Relational Algebra – Part 5

THE RELATIONAL CALCULUS In relational calculus, a query is conveyed as a formulary plan which contains a number of variables as well as an expression concerning these variables. It is up to the Database Management System (DBMS) to convert these non – technical queries into the same, well-organized, effective and procedural queries. The concept of relational calculus was first planned...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register