Prerequisites : Basics of SQL
 
In nested queries, a query is written inside a query. The result of inner query is used in execution of outer query. We will use ...
Share
Important Terminology
Database: Database is a collection of inter-related data which helps in efficient retrieval, insertion and deletion of data from database a...
Share
A database object is any defined object in a database that is used to store or reference data.Anything which we make from create command is known as Database Object.I...
Share
Database Management System – Introduction | Set 1
DBMS 3-tier Architecture
DBMS 3-tier architecture divides the complete system into three inter-related but in...
Share
Two tier architecture:
Two tier architecture is similar to a basic client-server model. The application at the client end directly communicates with the database at t...
Share
A Data Base Management System is a system software for easy, efficient and reliable data processing and management. It can be used for:
Creation of a database.
Retri...
Share
End users are basically those people whose jobs require access to the database for querying, updating and generating reports. The database primarily exists for their ...
Share
Basically, the choice of a DBMS is governed by a number of factors such as:
Technical
Economics
Politics of Organization
Here we will basically discuss Non-techn...
Share
Multimedia database is the collection of interrelated multimedia data that includes text, graphics (sketches, drawings), images, animations, video, audio etc and have...
Share
A database management system (DBMS) interface is a user interface which allows for the ability to input queries to a database without using the query language itself....
Share