UML for Database Design(2019)

Question 1

UML for

Database Design

Overview

Answer 1

Unified Modeling Language

• Has no multiway relationships
• Allows attributes
• Uses similar format to a Class Diagram
  
  • Entities represented like classes
    
    • Entities contain Attributes
  • Association Lines drawn between Entities
  • Association Attributes in their own Association classes

Question 2

UML for Database Design:

Associations

Answer 2

• Same association types as in E/R Model
• Represented with Association Lines between “classes”
• Range is set on each end: “low..high”

Question 3

UML for Database Design:

Associations:

Many to Many Representation

Answer 3

Both sides of Association Line

between classes labeled with

0..*

Question 4

UML for Database Design:

Associations:

One to Many Representation

Answer 4

One of Association Line

between classes labeled with

0..1

The other labeled with

0..*

Question 5

UML for Database Design:

Associations:

One to One Representation

Answer 5

Both sides of Association Line

between classes labeled with

0..1

Question 6

UML for Database Design:

Association Attributes

Answer 6

• Represented with an Association Class
• Similar to the Relationship in ER Model
• The Association Class is placed just below an Association Line between two Entity Classes

Question 7

UML for Database Design:

Entity Class

Answer 7

• Similar to UML Class Diagram representation of classes
  
  • Only has attributes, no “methods” section
• Class name on top
• Attributes in box
• Primary Key indicated with “PK” prefix