Chapter 3: Data modeling

studied byStudied by 0 people
0.0(0)
learn
LearnA personalized and smart learning plan
exam
Practice TestTake a test on your terms and definitions
spaced repetition
Spaced RepetitionScientifically backed study method
heart puzzle
Matching GameHow quick can you match all your cards?
flashcards
FlashcardsStudy terms and definitions
Get a hint
Hint

aggregation relationship

1 / 15

encourage image

There's no tags or description

Looks like no one added any tags here yet for you.

16 Terms

1

aggregation relationship

A special-purpose UML notation representing the relationship between two classes that are often considered together, such as when a sports league is made up of a collection of teams.

New cards
2

association

UML symbol that depicts the relationship between two classes; it is modeled as a solid line that connects two classes in a model.

New cards
3

attributes

Data elements that describe instances in a class, very much like fields in a database table; characteristics, properties, or adjectives that describe each class.

New cards
4

business rule

Succinct statements of constraints on business processes; they provide the logic that guides the behavior of the business in specific situations.

New cards
5

class

Any separately identifiable collection of things (objects) about which the organization wants to collect and store information.

can represent organization resources (e.g., trucks, machines, buildings, cash, investments), persons (e.g., customers, employees), events (e.g., sales, purchases, cash disbursements, cash receipts), and conceptual structures (e.g., accounts, product categories, budgets).

are typically implemented as tables in a relational database, where individual instances of the class are represented as rows in the table.

New cards
6

class diagrams

Structure models prepared using UML notation.

New cards
7

composition relationship

A special-purpose UML notation representing the relationship between two classes that are often considered together, similar to aggregation relationships, except in composition relationships, one class cannot exist without the other, such as a book and the chapters that compose the book.

New cards
8

constraints

Optional or mandatory guidance about how a process should perform in certain situations.

New cards
9

data models

A graphic representation of the conceptual contents of databases; data models support communication about database contents between users and designers of the database.

New cards
10

entities

The people, things, and events in the domain of interest; in UML notation, entities are modeled as classes.

New cards
11

foreign key (FK)

Attribute that allows database tables to be linked together; foreign keys are the primary keys of other tables placed in the current table to support the link between the two tables.

New cards
12

generalization relationship

A special-purpose UML symbol that supports grouping of things that share common characteristics; it reduces redundancy because the shared characteristics need only be modeled once.

New cards
13

multiplicities , (cardinalities)

UML symbols that describe the minimum and maximum number of times an instance of one class can be associated with instances of another class for a specific association between those two classes; they indicate whether the two classes are part of one-to-one, one-to-many, or many-to-many relationships.

New cards
14

primary key (PK)

An attribute or a combination of attributes that uniquely identifies an instance of a class in a data model or a specific row in a table.

New cards
15

relationship

The business purpose for the association between two classes or two database tables; see association.

New cards
16

structure model

A conceptual depiction of a database, such as a UML class model or an entity-relationship model.

New cards

Explore top notes

note Note
studied byStudied by 12 people
320 days ago
5.0(1)
note Note
studied byStudied by 7 people
908 days ago
5.0(1)
note Note
studied byStudied by 49 people
245 days ago
5.0(1)
note Note
studied byStudied by 11 people
770 days ago
5.0(1)
note Note
studied byStudied by 55 people
648 days ago
4.0(2)
note Note
studied byStudied by 17 people
1009 days ago
5.0(1)
note Note
studied byStudied by 25132 people
647 days ago
4.5(106)

Explore top flashcards

flashcards Flashcard (114)
studied byStudied by 275 people
244 days ago
5.0(3)
flashcards Flashcard (50)
studied byStudied by 11 people
145 days ago
5.0(1)
flashcards Flashcard (69)
studied byStudied by 52 people
506 days ago
5.0(1)
flashcards Flashcard (93)
studied byStudied by 1 person
75 days ago
5.0(1)
flashcards Flashcard (34)
studied byStudied by 7 people
721 days ago
5.0(2)
flashcards Flashcard (48)
studied byStudied by 194 people
67 days ago
5.0(1)
flashcards Flashcard (58)
studied byStudied by 11 people
344 days ago
5.0(2)
flashcards Flashcard (553)
studied byStudied by 479 people
27 minutes ago
5.0(4)
robot