What are E-R diagrams?

An Entity Relationship Diagram shows the relationship of entity sets stored in a database. An entity in this context is an object, a component of data.

An entity set is a collection of similar entities. These entities can have attributes that defines its properties.

By defining the entities, their attributes and showing the relationship between them, an E-R diagram
illustrates the logical structure of databases.

E-R diagrams are used to sketch out the design of a database.

What is the main difference between ACCESS and sql server?

The major difference between the two is in how the software is used.

Microsoft ACCESS is used in home or small business application.

Microsoft Access is not able to handle large quantities of database calls.

Microsoft SQL Server is for medium to large businesses that need a solution for better data processing.

What is the Difference between DBMS and RDBMS?

DBMS(Database management system) and RDBMS(Relational database management system) both are used to store information in physical database but are some remarkable difference between them.

The main difference between DBMS and RDBMS are below.

DBMS application store data as files. while RDBMS application store data in a tabular form.

In DBMS, data in generally stored in either a hierarchical form or a navigational form. In RDBMS
the tables have an identifier called primary key and the data values are stored in the from of tables.

Normalization is not present in DBMS. Normalization is present in RDBMS.

DBMS dose not support distributed system. RDBMS supports distributed system.

DBMS is meant to be small organization and deal with small data.it support single user. RDBMS is designed to handle large amount of data.It supports multiple users.

Examples of DBMS are file system, xml etc. Examples of RDBMS are mysql, postgres, sql server,oracle etc.

What is database or database management system(DBMS)?

What is database or database management system(DBMS)?

A database is an organized collection of data, generally stored and accessed electronically from
a computer system.

A database management system(DBMS) is a software package designed to define,manipulate,
retrieve and manage data in a database.

A DBMS generally manipulates the data itself, the data format,field names,record structure and file structure.

Examples of DBMS are:

mysql
access data
sql server
oracle
mongodb
postgres

What is the Difference between DBMS and RDBMS?