Discuss how to map a unary one-to-many relationship

What will be an ideal response?

A unary relationship has only one entity type, and this entity type will become a relation in the conversion process. As with any relation, the identifier of the relation will become the primary key and the other attributes of the entity type will become other attributes of the relation. We next add a foreign key attribute, which maps back to the primary key. This is called a recursive foreign key. For example, if we had a relation such as a person supervising one or more persons, the PersonID would be a primary key. In addition, the relation would have a foreign key SupervisorID, which points back to PersonID.

Business

You might also like to view...

________ of the UCC covers the topic of sales of goods

Fill in the blanks with correct word

Business

An information systems plan contains a statement of corporate goals and specifies how information technology will support the attainment of those goals

Indicate whether the statement is true or false

Business