0
What is the difference between relation and relationship in database?
Wiki User
∙ 11y ago
Relation:
In Database a relation represents a table or an entity that contain diffrenet attributes.An Entity constructs a relation(table) in DBMS .
Relationship:
In Data base relationship is that how the two entities are connected to each other ,i.e what kind of relationship type they hold between them.Primary/Foreign key is used to specify or hold this relationship.
By
Tanzeel Ur Rahman Bhatti
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
Distinguish between a relation and a relationship in database?
Relation is one record in the database or a tuple. Relationship is that how tables are connected to each other.
What is the difference between cardinality and degree of relationship in relations in database management?
bal amar
What is the difference between relation and relationship in dbms?
In a database management system (DBMS), a relation refers to a table that stores data in rows and columns, representing an entity or concept. A relationship, on the other hand, defines the connection between tables based on common fields, such as primary and foreign keys, to establish associations between different entities in the database. Relations are used to store data, while relationships define how data in different tables are related to each other.
What is the Difference between relation schema and relation instance?
difference between relation sehema and relation instance in dbms
What is relation in terms of database management system?
A relation is an assciation between two or more entities.
What is Difference between real time database and simple database?
the difference is about the transactions. the normal database is not included deadline, but the real time database is.
What is the difference between relation and table in data base?
Table is where the data is stored and in a well designed schema a table represents some real world object such as CUSTOMER, ORDER, etc., Now the real world objects have relationships. For example, a CUSTOMER has many ORDERS. To represent this relationship a database relationship was invented.
What is the relation between the path difference and phase difference?
Relation between phase difference and path difference is path difference/wavelength=phase difference/2*pi
What is the difference between having a friendly relationship and having a true and lasting friendship?
A friendly relationship is like an aquiantance relation ship, but true friendship is something you will have forever.
What is the difference between database and database administrator?
Database is the data stored in the server and Database administrator is the person who designs the database.
An association between entities is known as?
A relationship.
What is difference between primary key and foreign key?
A primary key is an attribute (or combination of attributes) that uniquely identifies each row in a relation. A primary key is designated by underlining the attribute name. The primary key of an entity set allows us to distinguish among the various entities of the set. A foreign key is an attribute in a relation of database that serves as the primary key of another relation in the same database.
