What are the roles of aggregation and association in relational database?

What will be an ideal response?


To map to a relational database, aggregation must be flattened into association; that is, the relational model is flat: tables do not own each other and are not composed of each other. This means that aggregation and composition relationships must be changed to association to map to tables. The task is not complicated: the table for the aggregate class provides the primary key, the tables for aggregating classes implement the foreign keys, and the multiplicity stays the same.

Business

You might also like to view...

Water Tower Place on Michigan Avenue in Chicago has many high-quality boutiques, amongst office space and residential condominiums. It is an example of a(n)

A. price-oriented center. B. off-price center. C. outlet center. D. lifestyle center. E. mixed-use development.

Business

Exploratory research is typically large scale and more expensive than other research techniques

Indicate whether the statement is true or false

Business

The purpose of adding a graph in a report is to _____

A) allow the reader to identify trends B) determine exact values C) arrange data in columns and rows D) to see relationships be reading down or across E) to replace the written word

Business

What are the minutes and agenda of a meeting? How do they benefit organizations?

What will be an ideal response?

Business