Structured Query Language -SQL
The most popular and widely accepted query language is Structured Query Language-SQL. SQL is used in the design and management of data held in RDBMS.
Database
Constraints and Keys in Database Management System
Constraints and Keys in Database Management System are similar, but they are not the same. However, keys and constraints in Database Management System are same they are not interchangeable.
Loading Data in the Database
It is always a hassle and time consuming to create a table in the database and insert the values in it manually. Most of the time we want a predefined data to be used for analyzing the database queries This article describes how to load data with Oracle Database 10g Express Edition. Furthermore, loading data …
Top 10 Dataset Repositories
Most of the time we want a predefined dataset to be used for analyzing the database queries. It is quite hard to find a good dataset repository for different projects like database, data science, machine learning. If you have ever worked on some database project, you’ve probably have spent most of your time browsing the …
Conversion of E-R Diagram into Relational Model
Conversion of an E-R diagram into a relational model is required because E-R diagrams represent the conceptual level of the database design while the relational model represents the logical level.
Relationships in the E-R Diagram
Relationships in the E-R diagram play a very vital role as they are the ones with the help of which one can convert any E-R diagram into database tables
Entity-Relationship Model: E-R Diagrams
Entity-Relationship Diagrams is a visual tool which is helpful to represent the Entity-Relationship model. It was proposed by Dr. Peter Chen in 1971.
Introduction to Database Management system
Database management system is required to create, manage and delete database. It helps in efficient retrieval, insertion and deletion of data in the database.