Menampilkan postingan yang diurutkan menurut relevansi untuk kueri erm. Urutkan menurut tanggal Tampilkan semua postingan

Selasa, 08 Oktober 2024

Entity Relationship Diagram ( ERD ) Notation In PlantUML

Entity : entity Entity_Name

for example:

entity Entity01

Attribute / Column / Field:
* identifying attribute: field_type(size_number or length_number)

* mandatory_attribute: field_type(size_number or length_number)
optional_attribute: field_type(size_number or length_number)

Stereotype:
<<PK>>, <<FK>>, <<generated>>

field type: text, number

ERD Relations Name and ERD Relation Symbol

ERD Relations Name : ERD Relation Symbol on the left and ERD Relation Symbol on the right.

Zero or One: |o-- and --o|

Exactly One: ||-- and --||

Zero or Many: }o-- and --o{

One or Many: }|-- and --|{

< Previous PlantUML Local Installation

Next >

Bibliography:

https://github.com/

https://medium.com/

https://plantuml.com/

https://stackoverflow.com/

https://windowsreport.com/

https://www.conceptdraw.com/

https://www.lucidchart.com/

https://www.smartdraw.com/

https://www.visual-paradigm.com/

erm, entity relationship modeling, erd, entity relationship diagram, er-m, information engineering relations, plant uml

Rabu, 05 Juni 2024

Microsoft Visio Diagram And Chart List

Microsoft Office Visio 2007

Open Microsoft Visio then from menu bar:

Template Categories:

File > New > Flowchart > Basic Flowchart ( Algorithm Chart, Process/System Flow Chart )

File > New > Flowchart > Cross Functional Flowchart ( Swimlane Diagram - BPMN Diagram )

File > New > Flowchart > Data Flow Diagram ( DFD - DeMarco and Yourdon )

File > New > Business > Organization Chart

File > New > Business > Brainstorming Diagram ( MindMap )

File > New > Software and Database > Database Model Diagram ( ERD/ERM - Entity Relationship Diagram / Entity Relationship Modelling )

File > New > Software and Database > Data Flow Model Diagram ( DFD - Gane Sarson )

File > New > Software and Database > UML Model Diagram ( Unified Modelling Language )

Shapes ( Stencil )

Visio stencil file format: *.vss

File > Shapes > Flowchart > Basic Flowchart Shapes ( Algorithm Chart, Process/System Flow Chart )

File > Shapes > Flowchart > Cross Functional Flowchart

File > Shapes > Flowchart > Data Flow Diagram Shapes ( DFD - DeMarco and Yourdon )

File > Shapes > Business > Organization Chart > Organization Chart Shapes

File > Shapes > Business > Brainstorming Shapes ( MindMap )

File > Shapes > Software and Database > Database > Entity Relationship ( ERD/ERM - Entity Relationship Diagram / Entity Relationship Modelling )

File > Shapes > Software and Database > Software > Gane Sarson ( DFD - Gane Sarson )

File > Shapes > Software and Database > Software > UML Activity

File > Shapes > Software and Database > Software > UML Collaboration

File > Shapes > Software and Database > Software > UML Component

File > Shapes > Software and Database > Software > UML Deployment

File > Shapes > Software and Database > Software > UML Sequence

File > Shapes > Software and Database > Software > UML Statechart

File > Shapes > Software and Database > Software > UML Static Structure ( Class, Object, Package )

File > Shapes > Software and Database > Software > UML Use Case

Bibliography

https://en.wikipedia.org/

https://medium.com/

https://support.microsoft.com/

State Diagram ( UML ) 2

State Diagram consist of:

State drawn as rounded rectangle.

Starting Point drawn as a filled circle.

Ending Point drawn as two concentric circles with a filled inner circle.

Transition drawn as arrow.

Event / Trigger is text that written along the Transition arrow.

Internal Behavior is any behavior that happens while the object is in a state. Internal behavior is written as label / behavior. The label indicates when the behavior executes in other words, events or circumstances causing the behavior. There are three special labels: entry, exit, and do.

Internal transition is a transition that causes a reaction within a state, but doesn't cause the object to change states. Internal transitions are written as trigger [guard] / behavior, and they are listed inside a state.

Composite States

Concurent States

< Previous State Diagram ( UML )

Selasa, 03 September 2024

PlantUML Local Installation

Local Installation Procedure

PlantUML Installation requirements:

Java

Requires Java (certain version) to be installed on your machine.
Check if Java is already installed, click How To Check Your Java Version.
If not installed, download and install it from the official Java website or through package managers e.g. apt for Ubuntu, brew for macOS, etc.

GraphViz

Needed only for some diagrams:

Usecase diagrams
Class diagrams
Object diagrams
Component diagrams
Deployment diagram
State diagrams
Legacy activity diagrams

PlantUML

Once ready, download the plantuml.jar file.
No further unpacking or installation procedures are needed.

Notes

If you want to Check PlantUML Installation.

If you want to initial explore to PlantUML, use the PlantUML online editor, search in the search engine (e.g. Google) or use PlantUML official online editor.

plant uml, unified modelling language, system analyst and design, textual diagram, text to diagram, textual modelling

Bibliography:

https://graphviz.org/

https://plantuml.com/ ( manual ebook )

https://www.oracle.com/

Rabu, 08 Oktober 2025

Simple ERD Table Design In AsciiDoctor

1. Open the AsciiDoctor editor.

2. Type this following Asciidoctor code sample about simple ERD/ERM Database Table Design in Asciidoctor editor:

==== ERD ( Entity Relationship Diagram )

:author: AsciiDoctor

:co-author: Tutor Course and After School Course

:revnumber: 1.0

:revdate: June 6th, 2007

:doctype: article

:toc:

:icons:

:lang: en

.Database Table Design: adminacc

[options="header"]

|===

|Field Name |Type |Size

|Username* |Text |50

|password |Text |50

3+|* _Primary Key_ ||

|===

.Database Table Design: record

[options="header"]

|===

|Field Name |Type |Size

|stud_ID* |Text |50

|fname |Text |50

|mname |Text |50

|lname |Text |50

|email |Text |50

3+|* _Primary Key_ ||

|===

3. Result Asciidoctor code after rendering, similar like this:

ERD ( Entity Relationship Diagram )

Table 1. Database Table Design: adminacc
Field Name	Type	Size
Username*	Text	50
password	Text	50
* Primary Key

Table 2. Database Table Design: record
Field Name	Type	Size
stud_ID*	Text	50
fname	Text	50
mname	Text	50
lname	Text	50
email	Text	50
* Primary Key

Notes

3+| is for merge three cells in one row as one cell.

<< back to Study About AsciiDoctor

Rabu, 10 Juli 2024

UML Vocabulary List

These are UML ( Unified Modelling Language ) Vocabulary List:

Basic Components:

Structure

Use Case
Class
Active Class
Interface
Component
Collaboration
Node

Component

Interaction Diagram
State Machine Diagram

Group

Model Geographic Boundaries ( Activity Partition )
Worker Responsibilities ( Swim Lanes )
Complex Transactions ( State Chart / State Chart Machine Diagram )
Package
Model
Sub system
Framework

Annotation

Notes

Relations:

Dependencies
Associations
Generalisation

Diagrams
Extention Mechanisms

unified modelling language, business process modelling

Jumat, 04 Oktober 2024

View Of State Chart Diagram

Table View State And Transitions Of State Chart Diagram On UML:

Table 1. Table View Of States And Transitions on UML Notation
State/Trigger	Trigger 1	Trigger 2
State name 1	Transition 1	Transition 2
State name 2	Transition 3	Transition 4

Next State Diagram ( UML ) >

program design, software design, low-code application development, software requirement specification document, srs document

Sabtu, 22 Juni 2024

ER-Model Of A Database

The purpose of a database is to store information about certain types of objects or entities.

Entity Class = Table name.

Entity=a data / row of a table.

Entity Set = set of data / rows In table.

Attributes are used to include information that we want in the database. Attributes = Field, Columns

The Entity-Relationship Model Of A Database Sample

LIBRARY database

Books entity class.

ISBN attribute.
Title attribute.
Price attribute.

Authors entity class.

Author_Id attribute.
Author_Name attribute.
Author_Phone attribute.

Publishers entity class.

Publisher_Id attribute.
Publisher_Name attribute.
Publisher_Phone attribute.

Contributors entity class.

Contributor_Id attribute.
Contributor_Name attribute.
Contributor_Phone attribute.

Table Scheme

Syntax:

Table_Name ( Field_Name_1, Field_Name_2, ... )

Example:

Entities And Attributes List:

Authors (AuID#,AuName,AuPhone)

BookAuthor (ISBN,AuID)

Books(ISBN#,Title,PubID,Price)

Publishers (PubID#, PubName, PubPhone)

Contributors (Contributor_Id#, Contributor_Name, Contributor_Phone)

# is notation to primary key

to read about foreign key notation, click : Entity Relationship Diagram ( ERD ) 2 >

to read about DDL, DQL, DML, DCL and TCL Commands, click : DDL, DQL, DML, DCL and TCL Commands >

Next: Entity Relationship Diagram ( ERD ) 2 >

Bibliography

Introduction To Database Management System;Dr. Satinder Bal Gupta et. al.;University Science Press

Access Database Design & Programming;Steven Roman;O'Reilly

ERM, Entity Relationship Diagram, erd, data column, data row, program design, table sample, software design, application design

Search In This Website

Selasa, 08 Oktober 2024

Entity Relationship Diagram ( ERD ) Notation In PlantUML

ERD Relations Name and ERD Relation Symbol

Bibliography:

Related Post

Rabu, 05 Juni 2024

Template Categories:

Shapes ( Stencil )

Bibliography

Related Post:

Related Post

Selasa, 03 September 2024

Local Installation Procedure

Java

GraphViz

PlantUML

Notes

Bibliography:

Related Post

Rabu, 08 Oktober 2025

ERD ( Entity Relationship Diagram )

Notes

Rabu, 10 Juli 2024

Related Post

Jumat, 04 Oktober 2024

Related Post

Sabtu, 22 Juni 2024

The Entity-Relationship Model Of A Database Sample

Table Scheme

Bibliography

Related Post