Question

In: Computer Science

In a N:M relationship which entity is the parent? Why?

In a N:M relationship which entity is the parent? Why?

Solutions

Expert Solution

In an N : M relationship, both of the entities may be the parent.

Explanation:

An ER model is not a complete model and there is no database available that is completely based on the ER model. Generally, the high-level design is done in the ER model and implementation is done in the relational model.

A relationship is an association, link, or connection between the instance of the different entity types.

Cardinality means the number of instances of one entity type that can possibly be related to the maximum of how many instances of another entity type.

Many to many(N:M) means one to many from both sides.

Let us suppose we have two entities A and B and the cardinality of these entities is N: M.

If the instance of entity A is associated with many of the instances of entity B then entity A is the parent entity and entity B is the child entity.

If the instance of entity B is associated with many of the instances of the entity A then entity B is the parent entity and the entity A is the child entity.

So, both of the entities may be the parent entity or child entity.


Related Solutions

In the following independent situations, discuss and determine whether a parent–subsidiary relationship exists, and which entity,...
In the following independent situations, discuss and determine whether a parent–subsidiary relationship exists, and which entity, if any, is a parent. You must fully explain and support your answer. This includes identifying and discussing each of the important facts or considerations in each case. (a). Tom Ltd is a company that was hurt by a major downturn in the economy. It previously obtained a significant loan from Jenson Bank, and when Tom Ltd was unable to make its loan repayments,...
In the following independent situations, discuss and determine whether a parent–subsidiary relationship exists, and which entity,...
In the following independent situations, discuss and determine whether a parent–subsidiary relationship exists, and which entity, if any, is a parent. You must fully explain and support your answer. This includes identifying and discussing each of the important facts or considerations in each case. Sawyer Ltd is a major financing company whose interest in investing is return on the investment. Sawyer Ltd does not get involved in the management of its investments. If an investee is not managed properly, Sawyer...
In the following independent situations, discuss and determine whether a parent–subsidiary relationship exists, and which entity,...
In the following independent situations, discuss and determine whether a parent–subsidiary relationship exists, and which entity, if any, is a parent. You must fully explain and support your answer. This includes identifying and discussing each of the important facts or considerations in each case. 1.Bernadette Ltd and Howard Ltd each hold 50% of the shares in Jerry Ltd, all companies being involved in the computer software industry. Bernadette Ltd agrees that Howard Ltd should provide the management of Jerry Ltd...
Which of the following statements is incorrect? Where the parent entity has acquired its investment in...
Which of the following statements is incorrect? Where the parent entity has acquired its investment in the subsidiary for a cost less than the fair value of the subsidiary’s identifiable net assets acquired, the goodwill should be recognised in consolidated assets. Consolidation adjusting entries are not posted to the accounts of either the parent entity or its subsidiaries. Where consolidation worksheet adjusting entries from the previous reporting period are still relevant in the current reporting period, they are repeated in...
Which option below provides the best description of the relationship between a quadratic parent function and a square root parent function?
Which option below provides the best description of the relationship between a quadratic parent function and a square root parent function?  A. The square root function is the quadratic function reflected across the y-axis.  B. The quadratic function and square root functions have no inverse.  C. The square root function is the quadratic function reflected across the line y = x, with a limited domain.  D. The square root function is the quadratic function reflected across the x-axis
Case Study 8: Parent-subsidiary relationship (AASB10) In the following independent situations, determine whether a parent–subsidiary relationship...
Case Study 8: Parent-subsidiary relationship (AASB10) In the following independent situations, determine whether a parent–subsidiary relationship exists, and which entity, if any, is a parent. 1. Road Ltd is a company that was hurt by a major downturn in the economy. It previously obtained a significant loan from Wile E. Bank, and when Road Ltd was unable to make its loan repayments, the bank made an agreement with Road Ltd to become involved in the management of that company. Under...
An entity licenses customer relationship management software to a customer. In addition, the entity promises to...
An entity licenses customer relationship management software to a customer. In addition, the entity promises to provide consulting services to significantly customize the software to the customer’s information technology environment for total consideration of $ 600,000 Are the software and consulting services on performance obligation or two?
Multiple Choice Investor is not a parent entity if The investor has power over the investee...
Multiple Choice Investor is not a parent entity if The investor has power over the investee Investors have the ability to influence investment returns The investor has the right to the investee's variable returns The investor has significant influence over the investee The accounting method applied for business combinations in accordance with PSAK 22 / IFRS 3 is: Acquisition method The pooling of ownership method Proportional consolidation method Equity method A is a newly formed entity to acquire B and...
c) HI, a parent entity, is planning to acquire a shareholding in ABC. The following alternative...
c) HI, a parent entity, is planning to acquire a shareholding in ABC. The following alternative investment strategies are being considered: (i) HI can purchase 80,000 preferred shares in ABC; (ii) HI can purchase 40,000 equity shares and 50,000 preferred shares in ABC; (iii) HI can purchase 70,000 equity shares in ABC and no preferred shares. ABC has the following issued share capital: R R1 Equity shares 100,000 R1 10% Preferred Shares 100,000 Holders of preferred shares do not have...
In regards to both US accounting standards and IFRS- Does a U.S. parent entity need to...
In regards to both US accounting standards and IFRS- Does a U.S. parent entity need to report and consolidate a VIE when the parent has very little control?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT