answersLogoWhite

0

Many to many relationship in DBMS is usually a mirror of the real-life relationship between objects that tables represent.

User Avatar

Wiki User

10y ago

What else can I help you with?

Continue Learning about Algebra

What is the most common type of relationship you will encounter between tables?

one-to-many relationships


What is post relational data model?

A number of extensions to the relational data model have been proposed in the three decades or so since its invention. Many of these extensions have been implemented in commercial DBMS. What is termed the post-relational data model here is not strictly a data model in that no coherent theory has been developed. Nevertheless it is useful to discuss it here in terms of a set of mech- anisms found in many contemporary DBMS. Such a data model is also referred to by the terms extended-relational and object-relational data model. In Chapter 18 we discuss how the proposed SQL3 standard addresses many of these features. In Chapter 34 we also consider how the ORACLE DBMS supports some of these features. In the first half of the chapter we consider two extensions to the data defin- ition part of the relational data model: abstract data types and nested relations. In the second half of the chapter we consider two constructs - triggers and stored procedures - that have been used both for data manipulation and data integrity purposes. The incorporation of these features into a relational DBMS provides it with the ability to handle complex objects and behaviour. Hence many of the DBMS with these features have termed themselves object-rela- tional systems.


What is the most common type of relationship between tables in a relational database?

one-to-many relationship


What is one to many relationship in database er diagram?

A one-to-many relationship means that one row in one of the tables will relate directly to many rows in the other table.


What is the Difference between relation schema and relation instance?

difference between relation sehema and relation instance in dbms