Exam 3 IST359

5.0(1)
studied byStudied by 4 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Get a hint
Hint

Entity Mapping

Get a hint
Hint

translates to a relational table

Get a hint
Hint

Bridge Table

Get a hint
Hint

this is required to map a many-to-many relationship

Card Sorting

1/35

Anonymous user
Anonymous user
flashcard set

Earn XP

Description and Tags

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

36 Terms

1
New cards

Entity Mapping

translates to a relational table

2
New cards

Bridge Table

this is required to map a many-to-many relationship

3
New cards

Mapping

the process of transforming a conceptual model into a logical model

4
New cards

Attribute Mapping

translates to relational tables or columns within a table

5
New cards

Analysis

the process of componentizing a complicated problem to achieve a better understanding of it

6
New cards

Relationship Mapping

translates to foreign key placement

7
New cards

Unique Attribute Type Mapping

translates to setting a unique key constraint

8
New cards

Entity

a thing for which you need to store data

9
New cards

Attributes

characteristics or descriptors of an entity

10
New cards

Relationships

business rules which connect entities together

11
New cards

Required Attribute Type Mapping

translates to not allowing null on the table’s column

12
New cards

Composite Attribute Type Mapping

translates to breaking down the attribute into more than one table column

13
New cards

NOT NULL Foreign Key

this is required to map a weak entity

14
New cards

Unique

an attribute value should be different for each entity

15
New cards

Foreign Key

this is required to map a one to many relationship

16
New cards

Foreign Key w/ Unique Constraint

this is required to map a one to one relationship

17
New cards

Required

an attribute value is mandatory

18
New cards

Normalization

a process applied to relational tables which improves logical design by eliminating data redundancy and inconsistency

19
New cards

Minimal Candidate Key

the smallest number of columns from a data set which can act as primary key

20
New cards

Derived

an attribute value can be calculated from one or more other attributes

21
New cards

Prime Attribute

a column which is key or is part of the key

22
New cards

Composite

an attribute is complex and should be sub-divided in its implementation

23
New cards

Non-Prime Attribute

a column which is not part of the key

24
New cards

Multi-Valued

an attribute contains more than one value

25
New cards

Cardinality

the number of occurrences at minimum and maximum of one entity as it relates to another

26
New cards

Functional Dependence

the key attribute can be used to retrieve one and only one attribute for each non-key column

27
New cards

Partial Functional Dependence

in a key containing more than one column

28
New cards

Transitive Functional Dependence

a non-key column acting as key for another non-key column

29
New cards

Data Migration

the process of transferring data from one source to another

30
New cards

Data Extraction

the process of retrieving data from its source as part of a migration

31
New cards

Weak Entity

an entity which cannot exist without another entity

32
New cards

Data Cleansing

the process of fixing mistakes or cleaning up source data

33
New cards

Data Transformation

the process of breaking up source data into a structure suitable for a target structure

34
New cards

Data Loading

the importation of transformed data into a target data structure

35
New cards

Data Verification

the process of checking whether a migration was successful

36
New cards

Logical Data Model

a relationally-dependent, but DBSM independent model