Database - What is an Entity-Relationship diagram?

What is an Entity-Relationship diagram?

- It is a graphical representation of tables with the relationship between them.

What is an Entity-Relationship diagram?

ER diagram is a conceptual and abstract representation of data and entities. ER is a data modeling process, which is to produce a conceptual schema of a system, often an RDBMS and the needs in top down fashion. ER diagrams are derived by using this model.
Database - Define referential integrity
Referential integrity is a RDBMS concept and ensures the relationships among tables remain consistent.....
Database - Define Primary key and Foreign key
A column or combination of columns that identify a row of data in a table is Primary Key.....
Database - Define alternate key
There can be a key apart from primary key in a table that can also be a key. This key may or may not be a unique key.....
Post your comment