Components of a table and Terminologies in RDBMS

Byte : A byte is a group of eight bits and is used to store a character.Data Item : A data item is the smallest unit of named data. It may consist of any number of bits and bytes.Field: A data item represents on type of information and often referred to as field or data...

Relational Database Model

In relational database model, the data is organized into tables(i.e. , rows and columns). These table are called relations. A row in a table represents a relationship among a set of values. Since a table is a collection of such relationships, it is generally referred to using the mathematical term, relation, from which the relational...

DBMS

Introduction A database can be defined as a collection of interrelated data stored together to serve multiple actions. It is basically a computer based record keeping system. The collection of data usually referred to as the database, contains information about one particular enterprise. The data is stored in a such a way that it is...

MySQL

Introduction to MySQL MySQL is a freely available open source Relational Database Management System (RDBMS) which uses Structured Query Language (SQL). User can store the information in the form of tables in a MySQL databases. One database can have as many tables as the user wants to store, and each table can have as many...