AFM341 Lecture Notes - Lecture 8: Unique Key, Unified Modeling Language, Class Diagram
28 Jun 2018
School
Department
Course
Professor
To develop a relationship database to support the collection, aggregation, and
communication of process information
â—‹
They are tools for planning, documenting, discussing, and implementing databases and
facilitate the use of it after
â—‹
Structured models describe the data and information structures inherent in a business process or
processes
•
Data models have been used to represent the conceptual contents of databases to communicate
with the users of those database
•
The entities or things in the domain of interestâ—‹
The relationship among those thingsâ—‹
The cardinalities that describe how many instances of one entity can be related to anotherâ—‹
The attributes or characteristics of the entities and relationships â—‹
A model of logical database structures must describe•
Structured models
This textbook employs the Unified Modeling Language (UML) class diagram notation for structure
models
•
Class diagrams are UML type diagram and are similar in many ways to entity-relationship
diagrams
•
e.g. organization resources such as a truck, persons such as employees, events such as
purchases, conceptual structures such as accounts
â—‹
Classes are implemented as tables in a relational database and individual instances of
objects are represented as rows in the table.
â—‹
A class is any separately identifiable collection of things (objects) about which the organization
wants to collect and store information
•
•
Building blocks for UML class diagrams
In this class we will omit the attributes and operations and only use class symbol with name only •
An association depicts the relationship between two classes •
Chapter 3
-
Data modeling
January 8, 2018 7:23 PM
AFM 341 Page 1
Document Summary
Structured models describe the data and information structures inherent in a business process or processes. To develop a relationship database to support the collection, aggregation, and communication of process information. They are tools for planning, documenting, discussing, and implementing databases and facilitate the use of it after. Data models have been used to represent the conceptual contents of databases to communicate with the users of those database. A model of logical database structures must describe. The entities or things in the domain of interest. The cardinalities that describe how many instances of one entity can be related to another. The attributes or characteristics of the entities and relationships. This textbook employs the unified modeling language (uml) class diagram notation for structure models. Class diagrams are uml type diagram and are similar in many ways to entity-relationship diagrams. Classes are implemented as tables in a relational database and individual instances of objects are represented as rows in the table.
