answersLogoWhite

0

Composition is a term that comes from object oriented design. It is a relationship in which a number of parts comprise a whole, and these parts can only be part of one whole.

There is no direct translation of this concept to database design, but there are some situations in the database world that represent the concept of composition.

Field to record

A record is composed of fields and these fields are part of only one record. When the record is removed, the fields are also removed. So, each field has a composition relation with its record. This means that when you store a collection (a comma separated list of names for example) in a database field, this is in fact a composition relationship.

Record to record from other table

If you want to create a composition relation between records from a table A and records from another table B, where A is the whole and B the parts you must ensure that

1. There is a one-to-many relationship between table A and B. This is done by adding a foreign key to table B.
2. That all part records in B are deleted when the whole record in table A is deleted. This can be done by setting ON DELETE CACADE on the foreign key relationship.
3. That the records in table B don't become part of another composition relationship. But this restriction cannot be enforced by the database to my knowledge.
User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What information can be found in the protein complex database?

The protein complex database contains information about the structures and interactions of protein complexes, including their composition, function, and biological significance.


What kind of application in MS Access?

It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.It is a database application.


Enter on the database or in the database?

We would use in rather than on. Data is stored in a database, not on a database. Data is entered into a database not onto a database.


What is a derived database?

We know what is database, it is a collection records. When a database is created from the existing database it is known as derived database.


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.


What is the range of database application?

The range of database application are given below: 1- Personal Database 2- Workgroup Database 3- Department Database 4- Enterprise Database


What is active database and cloud database?

The database we use in our daily life is called as active database . The data that is stored in the database which is further stored on the cloud is called cloud database.


How is a database structured?

database structure depends on the business requirement and size of database. database structure depends on the business requirement and size of database.


Is a dhcp database a distributed database similar to a dns database?

no


Is the relational database an example of oracle database?

A relational database is a type of database design. Oracle is a brand of database. You can create a relational database using Oracle. You can also create relational databases using other database applications.


Why do Database Management is related to MS Access?

Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.Access is a Database Management System, so it is related to the management of data. It is what a database is for.


Is SQL a Database?

SQL is not Database, it is a Language used to communicate with Database...