module 8

28問 • 1年前

Lml rys

通報

問題一覧

a class of person place object events or concept about which we need to capture and store data

entity

five categories of entities

person place objects events concept

a single occurrence of an entity

entity instance

a descriptive property or characteristic of an entity

attributes

an attribute that contains of other attributes

compound attributes

one of a number of keys that may serve as primary key

candidate key

a candidate key used to uniquely identify a single entity instance

primary key

candidate key not selected to become the primary

alternate key

an attribute whose finite values divide all entity instance into useful subset

subsetting criteria

a natural business association that exist between one or more entities

relationship

relationship that exist between instances of the same entity

recursive relationship

the minimum and maximum number of occurrence of one entity that may be related to single occurrence of the other entity

cardinality

another measure of the complexity of a data relationship

degree

entity that inherits its primary key from more one other entity

associative entity

it connects three entities and it resolves a specific relationship by providing structure and ambiguous data association

ternary relationship

relationship in which the parent entity key is also part of the primary key of the child entity

identifying relationship

is a relationship where each participating entity has its own independent primary

non identifying relationship

a primary key of an entity that is used in another entity or identifying instance of a relationship

foreign key

is an entity whose instance store attributes that are common to one or more entity subtypes

supertype

an entity whose instance may inherit common attributes from its entity super type and then and other attributes unique to the subtype

subtype entity

analyzes used to improve a data model for implementation as a database

data analysis

three characteristic of a good data model

a good data model is simple a good data model is essentially non-redundant a good data model should be flexible and adaptable to future needs

three steps of normalization

first normal form second normal form third normal form

a calculated attribute derived from other attributes within the same entity

derived attribute

is the process of creating a visual representation of an information system to communicate the connections between data points and structures.

data modeling

where many instance of an entity are associated with many instance of other entity is also called many to many relationship

non-specific relationship

Data entity that contributes one or more attribute to other entity

parent entity

Entity that derives one or more attributes from other entity

child entity

CC101 chapter 1

CC101 chapter 1

CC101 chapter 1

CC101 chapter 1

chapter3

chapter3

cc102 chapter1 Quizlet

Lml rys · 25問 · 3年前

cc102 chapter1 Quizlet

CC101 chapter 1

CC101 chapter 1

CC101 chapter 1

CC101 chapter 1

cc101 chapter1 Quizlet

Lml rys · 25問 · 3年前

cc101 chapter1 Quizlet

GE5

GE5

Chapters 2

Chapters 2

Module1

Module1

Module2

Module2

Midterm

Midterm

midterm

midterm

module2

module2

Module 9

Module 9

Module 10

Module 10

module 11

module 11

module 12

module 12

FINALS💀

FINALS💀

問題一覧

a class of person place object events or concept about which we need to capture and store data

entity

five categories of entities

person place objects events concept

a single occurrence of an entity

entity instance

a descriptive property or characteristic of an entity

attributes

an attribute that contains of other attributes

compound attributes

one of a number of keys that may serve as primary key

candidate key

a candidate key used to uniquely identify a single entity instance

primary key

candidate key not selected to become the primary

alternate key

an attribute whose finite values divide all entity instance into useful subset

subsetting criteria

a natural business association that exist between one or more entities

relationship

relationship that exist between instances of the same entity

recursive relationship

the minimum and maximum number of occurrence of one entity that may be related to single occurrence of the other entity

cardinality

another measure of the complexity of a data relationship

degree

entity that inherits its primary key from more one other entity

associative entity

it connects three entities and it resolves a specific relationship by providing structure and ambiguous data association

ternary relationship

relationship in which the parent entity key is also part of the primary key of the child entity

identifying relationship

is a relationship where each participating entity has its own independent primary

non identifying relationship

a primary key of an entity that is used in another entity or identifying instance of a relationship

foreign key

is an entity whose instance store attributes that are common to one or more entity subtypes

supertype

an entity whose instance may inherit common attributes from its entity super type and then and other attributes unique to the subtype

subtype entity

analyzes used to improve a data model for implementation as a database

data analysis

three characteristic of a good data model

a good data model is simple a good data model is essentially non-redundant a good data model should be flexible and adaptable to future needs

three steps of normalization

first normal form second normal form third normal form

a calculated attribute derived from other attributes within the same entity

derived attribute

is the process of creating a visual representation of an information system to communicate the connections between data points and structures.

data modeling

where many instance of an entity are associated with many instance of other entity is also called many to many relationship

non-specific relationship

Data entity that contributes one or more attribute to other entity

parent entity

Entity that derives one or more attributes from other entity

child entity