Advertisements
Advertisements
Question
What is a relationship in databases? List its types.
Advertisements
Solution
There exists a relationship between two tables when the foreign key of one table references the primary key of other tables.
The Entity-Relationship(ER) diagram is based on the three types listed below.
- One-to-One relationship
- One-to-Many relationship
- Many-to-Many relationship
APPEARS IN
RELATED QUESTIONS
What is the use of legends in a chart?
What is the difference between .importing and exporting of a database?
Write the steps to filter a table.
What symbol is used for the SELECT statement?
Which language is used to request information from a Database?
The ______ diagram gives a logical structure of the database graphically?
What are the ACID properties?
Give the term for the following:
DBMS creates a file that contains a description of the data stored in the database.
State the following rules of DBMS.
Entity Integrity
State the following rules of DBMS.
Referential Integrity
