summaryrefslogtreecommitdiff
path: root/assignments/1
diff options
context:
space:
mode:
authormo khan <mo.khan@gmail.com>2020-01-01 14:00:30 -0700
committermo khan <mo.khan@gmail.com>2020-01-01 14:00:30 -0700
commit44f1230cdbbf0dbab5763984b416949ee64b5016 (patch)
tree4df1fa78be8a27f5c9c53a106ce8e98468557ec6 /assignments/1
parent73df5eb617680181b3ad82bb2a6606566e094a5b (diff)
Provide example of an associative entity
Diffstat (limited to 'assignments/1')
-rw-r--r--assignments/1/README.md25
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