Primary key constraint :In ER diagram it is a force to set limitation for primary key constraint .for example in ER Modeling you should learn to people to set just one primary key for each entity and it is different from composite primary key .I Think for distinguish between these two concept it is better to set a separate syntax for setting composite primary key
(references to fig.3-1)
Fig.3-1: screenshot of BigER : Primary Key Constraint does not Consider
Current Behavior
user can add more than primary key and there is no distinction between composite primary key and unique primary key .
Fig.3-1: screenshot of BigER : Primary Key Constraint does not Consider
Expected Behavior
limitation for setting more than one primary key for each entity should be consider and
the structure of setting one primary key for each entity and setting a composite primary key for each entity should be distinguish .
Steps to Reproduce
1-implement a simple ER with two entity
2-set just one primary key for each entity
3-you can see the problem is here : you can add more than one primary key for each entity
Description
Primary key constraint :In ER diagram it is a force to set limitation for primary key constraint .for example in ER Modeling you should learn to people to set just one primary key for each entity and it is different from composite primary key .I Think for distinguish between these two concept it is better to set a separate syntax for setting composite primary key (references to fig.3-1)
Fig.3-1: screenshot of BigER : Primary Key Constraint does not Consider
Current Behavior
user can add more than primary key and there is no distinction between composite primary key and unique primary key .
Expected Behavior
limitation for setting more than one primary key for each entity should be consider and the structure of setting one primary key for each entity and setting a composite primary key for each entity should be distinguish .
Steps to Reproduce
1-implement a simple ER with two entity 2-set just one primary key for each entity 3-you can see the problem is here : you can add more than one primary key for each entity
Environment
No response
Additional Information
No response