Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Big Data Analytics Articles
Page 122 of 135
Explain closure of attributes in DBMS
Closure of an attribute x is the set of all attributes that are functional dependencies on X with respect to F. It is denoted by X+ which means what X can determine.AlgorithmLet’s see the algorithm to compute X+Step 1 − X+ =XStep 2 − repeat until X+ does not changeFor each FD Y->Z in FIf Y ⊆ X+ then X+ = X+ U ZExample 1Consider a relation R(A, B, C, D, E, F)F: E->A, E->D, A->C, A->D, AE->F, AG->K.Find the closure of E or E+SolutionThe closure of E or E+ is as follows − E+ = E =EA ...
Read MoreWhat is tier-2 architecture in DBMS?
The overall design of the Database Management System (DBMS) depends on its architecture. A large amount of data on web servers, Personal Computers (PC) and other elements are linked with networks with the help of basic client or server architecture.PCs and workstations are part of Client architecture that are connected over the network. The architecture of DBMS depends on how the users are linked to the database.There are three kinds of DBMS Architecture, which are as follows −Tier-1 Architecture.Tier-2 Architecture.Tier-3 Architecture.Tier-2 ArchitectureThe 2-tier Architecture is based on a client-server machine.In this type of architecture, the applications on client-side interact directly ...
Read MoreWhat is tier-1 architecture in DBMS?
The overall design of the Database Management System (DBMS) depends on its architecture. A large amount of data on web servers, Personal Computers (PC) and other elements are linked with networks with the help of basic client or server architecture.PCs and workstations are part of Client architecture that are connected over the network. The architecture of DBMS depends on how the users are linked to the database.There are three kinds of DBMS Architecture, which are as follows −Tier-1 Architecture.Tier-2 Architecture.Tier-3 Architecture.Tier is a physical unit where the program code or a process is run.For example − data base server, application ...
Read MoreWhat are the most used SQL clauses in DBMS?
SQL is a Structured Query Language which is the standard and most widely used programming language for relational databases. It is used to manage and organize data in all sorts of systems where all varieties of data relationships exist.Structured Query Language (SQL) ClausesThe SQL clauses are of three types as shown below−Let us learn about them one by one.GROUP BY CLAUSESQL GROUP BY is used to arrange identical data into groups. It is used with the SQL SELECT statement. The GROUP BY statement follows the WHERE clause in a SELECT statement and precedes the ORDER BY clause. It is also ...
Read MoreExplain the difference between a table, view and synonym in SQL
Let us understand what table, view and synonym in the structured query language (SQL) are.Table, view and synonymA table is a repository of data, where in the table it is a physical entity. A table resides physically in the database.A view is not a part of the database’s physical representation. It is precompiled, so that data retrieval behaves faster and also provides a secure accessibility mechanism.A synonym is an alternate name assigned to a table, view, sequence or program unit.ExampleCreate table employee (empID integer primary key, name varchar2(30), skill varchar2(30), salary number(20), DOB datetime).Let’s say there is a scenario where ...
Read MoreExplain the concept of the traditional file system in DBMS?
A file system is a method of storing and organizing the computer files and the data they contain to make it easy to find and access them.Characteristics of file systemThe characteristics of file system are as follows −It is a group of files for storing the data of an organization.Each file is independent from one another.Each file is called a flat file.Files are designed by using the program written in programming languages such as C, C++.Disadvantages of file processing systemThere are so many disadvantages in the file processing system. These are explained below −Separated and isolated data.Duplication of data − ...
Read MoreWhat is the difference between data and information in DBMS?
Before understanding the difference between data and information, let’s have a look at the definitions of data and information with an example.DataData is the raw material that can be processed for any computing machine.For example − Employee name, Product name, Name of the student, Marks of the student, Mobile number, Image etc.InformationInformation is the data that has been converted into more useful or intelligent form.For example: Report card sheet.The information is needed for the following reasons −To gain knowledge about the surroundings.To keep the system up to date.To know about the rules and regulations of the society.KnowledgeThe human mind purposefully ...
Read MoreDistinguish between flat files and databases (dbms)?
Let’s discuss flat and database definition before understanding the difference between flat files and databases.Flat filesA flat file contains records which have no structured interrelationship. They are typically called as a text file, where all word processing, structure characters and markup have been removed. A flat file represents a table with a single record per line. Generally, it is a type of database that stores data in a plain text format.DatabaseThe related information when placed in an organized form that makes a database or an organized collection of related information is called a database.For example − Dictionary, Telephone directory etc.DifferencesFollowing ...
Read MoreDifference Between ROLAP and MOLAP
In this post, we will understand the difference between ROLAP and MOLAP.ROLAPIt stands for Relational Online Analytical Processing.It is used for large volumes of data.The access time in ROLAP is slow.It stores data in the form of relation tables.The data in ROLAP is fetched from a data warehouse.It uses complex SQL queries.A static multidimensional view of the data is created in ROLAP.MOLAPIt stands for Multidimensional Online Analytical Processing.It is used for less/limited volumes of data.The access time is quick in MOLAP.Data is stored in a multidimensional array.Data is fetched from the MDDBs database.A sparse matrix is used in MOLAP.Dynamic multidimensional ...
Read MoreDifference Between T-SQL and PL-SQL
In this post, we will understand the difference between T-SQL and PL-SQL.T-SQLIt is a Microsoft product.It is known as Transact Structure Query language.It gives a high degree of control to the developers/programmers.It works its best, and provides good performance with Microsoft SQL server.It is easy.It is simple to understand.It allows the insertion of multiple rows into a table.This is done with the help of the ‘BULK INSERT’ statement.The ‘SELECT INTO’ statement is used in T-SQLIn this, the ‘NOT EXISTS’ clause can be used with the ‘SELECT’ statements.PL-SQLIt is an Oracle product.It is known as Procedural Language Structural Query Language.It is ...
Read More