Chapter 3 - Data modeling. After reading this chapter, you should be able to: Understand the purpose of structure models, understand and apply the building blocks for UML class (structure) diagrams, describe multiplicities for a UML class diagram, understand how to implement a relational database from a UML class diagram, describe business rules and the various forms of rules. | Chapter 3 Data Modeling Copyright © 2014 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education. 1 Learning Objectives 3-2 LO#1 Understand the purpose of structure models. LO#2 Understand and apply the building blocks for UML Class (structure) Diagrams. LO#3 Describe multiplicities for a UML Class Diagram. LO#4 Understand how to implement a relational database from a UML Class Diagram. LO#5 Describe business rules and various forms of rules. Structure Models Describe the data and information structures inherent in a business process Create a blueprint for the development of a relational database to support the collection, aggregation, and communication of process information Facilitate the use of databases after they are implemented 3-3 LO# 1 Unified Modeling Language (UML) UML class diagram notation for structure models Specifications for UML maintained by the Object Management Group, a not-for-profit consortium of computer industry members UML also includes notation for several other types of diagrams, including several structure diagrams, behavior diagrams, and interaction diagrams Class diagrams describe the logical structure of a database system 3-4 LO# 2 UML Class Diagram – Building Blocks Classes are separately identifiable collections of things about which the organization wants to collect and store information Associations depict the relationship between two classes. Multiplicities describe the minimum and maximum number of times instances of one class can be associated with instances in another class 3-5 LO# 2 UML Class Diagram - Classes 3-6 LO# 2 Classes can represent organization resources (., trucks, machines, buildings, cash, investments) persons (., customers, employees) events (., sales, purchases, cash disbursements, cash receipts), and conceptual structures (., accounts, product categories, budgets) UML Class Diagram - Associations Associations depict the | Chapter 3 Data Modeling Copyright © 2014 McGraw-Hill Education. All rights reserved. No reproduction or distribution without the prior written consent of McGraw-Hill Education. 1 Learning Objectives 3-2 LO#1 Understand the purpose of structure models. LO#2 Understand and apply the building blocks for UML Class (structure) Diagrams. LO#3 Describe multiplicities for a UML Class Diagram. LO#4 Understand how to implement a relational database from a UML Class Diagram. LO#5 Describe business rules and various forms of rules. Structure Models Describe the data and information structures inherent in a business process Create a blueprint for the development of a relational database to support the collection, aggregation, and communication of process information Facilitate the use of databases after they are implemented 3-3 LO# 1 Unified Modeling Language (UML) UML class diagram notation for structure models Specifications for UML maintained by the Object Management Group, a not-for-profit .
