Reshma shaik 
Introduction The E.F. Codd rules were discussed in the last article. The final point, if we recall correctly, was to validate the data before putting it in a table by assigning: Now, we will discuss datatypes and constraints, how they validate the data, their uses in real-world applications, advantages, and disadvantages. What is a Datatype? … Read more
In the previous article we discussed some of the data models like hierarchy, object, ER, there we left out with one data model that is Relational data model. Brief History of the Relational Data Model The relational data model was first introduced in 1970 by a computer scientist and a mathematician named Edgar Frank Codd, … Read more
Overview of Data Models Data models are the underlying structure of a database. They serve as conceptual tools to describe the data, the relationships among data, data semantics, and constraints. Since a database is a collection of interrelated data, it is essential to handle data semantics and constraints effectively. Data models assist in designing databases … Read more
What is a Relational Database Management System RDBMS? A Relational Database Management System RDBMS is a fancy way of saying a database that is used to organize things in the form of tables. RDBMS is like having several spreadsheets that are linked to each other. They use primary keys and foreign keys to link them … Read more
Introduction to Database Management System (DBMS) In the previous article, we have seen databases. Now you guys are good at databases, if I am not wrong few of you might doubt how these databases are managed, who is managing them, and how they are managed. Here is the answer to that question: we have software … Read more
In the previous article, we have seen different databases such as relational, non-relational, hierarchical, etc. Few might doubt what this database is exactly, why we require it, how it is useful, and how we are utilizing it in our application like this. Most of your doubts regarding these databases are going to be resolved in … Read more
In our daily lives, we use Structured Query Language every day, knowingly or unknowingly. Let’s take a few examples: Not just these, but there are many more real-life applications of SQL. Let’s see a few more: What is a Database? By now, you might have heard the term database multiple times. You must be wondering—what … Read more