diff options
| author | mo khan <mo.khan@gmail.com> | 2020-01-01 14:00:30 -0700 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2020-01-01 14:00:30 -0700 |
| commit | 44f1230cdbbf0dbab5763984b416949ee64b5016 (patch) | |
| tree | 4df1fa78be8a27f5c9c53a106ce8e98468557ec6 /assignments/1 | |
| parent | 73df5eb617680181b3ad82bb2a6606566e094a5b (diff) | |
Provide example of an associative entity
Diffstat (limited to 'assignments/1')
| -rw-r--r-- | assignments/1/README.md | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/assignments/1/README.md b/assignments/1/README.md index c3b284d..f2e1989 100644 --- a/assignments/1/README.md +++ b/assignments/1/README.md @@ -44,6 +44,31 @@ An `entity instance` is a specific occurrence of the `entity type`. .i.e. a spec Give a simple example of an E-R diagram for each of the following concepts: a. Associative entity + > An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances. + + Project ||-<- Policy ->-|| SoftwareLicense + ```plantuml + @startuml + entity 'Project' as project { + *id: number + *name: varchar(255) + } + entity 'Policy' as policy { + *id: number + *classification: number + *project_id: number + *software_license_id: number + } + entity 'SoftwareLicense' as license { + *id: number + *spdx_id: varchar(255) + *name: varchar(255) + } + project ||..|{ policy + license ||..|{ policy + @enduml + ``` + b. Weak entity c. Unary relationship |
