In a one-to-one identifying relationship, an entity may be a subordinate of the related entity; that is, the subordinate entity has columns which also belong to its superior entity in the real world situation. Visual Paradigm promotes the idea of Split Table with stereotype of Partial which allows developers to optimize the size of database, and minimizes the redundant persistent classes for handling one-to-one identifying relationship. In order to reduce the risk of appending a new column to an existing database table, Split table supports developers to add new columns to the partial table with a one-to-one identifying relationship linked to the existing table. Visual Paradigm allows you to split the entity into two and convert the subordinate entity to be a Partial Table in a one-to-one identifying relationship.
You can split an entity into two associated entities with a one-to-one identifying relationship. There are two ways you can take to split a table.
Using popup menu
- Right click on an entity.
- Select Split Table from the popup menu.
Using Resource Catalog
- Move the mosue pointer over an entity.
- Press on the Resource Catalog button and drag it out.
- Release the mouse button and select One-to-One Relationship -> Partial Table from Resource Catalog.
Both ways will result in popping up the Split Table window. In the window, enter the name of the new entity and select the columns from the list of Original to Partial, and click OK.
An entity stereotyped <<Partial>> is created.
Converting to a Partial table
You can convert an entity to a Partial Table in a one-to-one identifying relationship.
- Right click on the entity.
- Select Convert to Partial Table from the popup menu.
The entity is stereotyped <<Partial>>.