What is RDBMS or terms of Database? (Relational Database Management System)

RDBMS Stands for "Relational Database Management System." An RDBMS is a DBMS designed specifically for relational databases.

A relational database refers to a database that stores data in a structured format, using rows and columns. This makes it easy to locate and access specific values within the database. 

A relational database has following major components (terms):- 

1. Relation or Table 

2. Record or Tuple 

3. Field or Column name or Attribute 

4. Domain 

5. Keys 

1. Relation (Table):- All data and relationships are represented in a two dimensional table called a relation. A relation consists of number of records or row-wise information and column-wise information. For example, the following table “STUDENT” stores the information of students in database.

 2. Record or Tuple:- Each row of a table is known as record. It is also known as tuple. 

3.Field or Column name or Attribute:- An attribute is a named column of a relation. A relation is represented as a two-dimensional table in which the rows of the table correspond to individual records and the table columns correspond to attributes. 

4.Domain: A domain is the set of allowed values for one or more attributes. A domain defines the kind of data represented by an attribute.

5. Key :- Key plays an important role in relational database; it is used for identifying unique rows from table. It also establishes relationship among tables.

Read More

What is DBMS (Database Management system)?

DBMS stands for Database Management System. 

Database is a collection of data and Management System is a set of programs to store and retrieve those data. 

DBMS is a collection of inter-related data and set of programs to store & access those data in an easy and effective manner. The data stores in database in two different ways. 

They are:- 

1. Flat file database 

2. Relational database 

A flat file database stores data in a single table structure. A relational database uses multiple table structures, cross-referencing records between tables.

Read More

What is Database and advantages of Database?

 A database is an organized collection of data, generally stored and accessed electronically from a computer system. For example, a company database may include tables for products, employees, and financial records. Each of these tables would have different fields that are relevant to the information stored in the table. The some common advantages of database are:-

1. Ability to store large amounts of information:-

This ability is essential for large companies with a large number of customers and this volume of information must be handled very precisely.

2. Sharing information:-

Databases allow users to share common information. Therefore, if you have a business with different company locations you can share your data at same time with the different business locations.

3. Having quick access to information:-

The information is obtained quickly and easily, which greatly facilitates the work and allows you having better customer service.

4. Easy maintenance:-

As the information is digitized it is easier and economical to carry out any maintenance.

5. Information Security:-

A database can have several parts depending on users. You can limit certain access to certain parts of the data for certain users. That way the security and confidentiality of data will be guaranteed and secured.

Read More

What is Data and Information?

Data is the raw material that can be processed by any computing machine. When data are processed, interpreted, organized, structured or presented so as to make them meaningful or useful, they are called information. 

Information provides context for data. Data is a individual unit which contains raw material and doesn't carry any meaning. Information is the product and group of data which collectively carry a logical meaning.

Read More