FINALS💀

final julio

FINALS💀

50問 • 1年前final julio

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

a pictorial representation of reality.

model

– a nontechnical pictorial representation that depicts what a system is or does. Synonyms for essential model, conceptual model, and business model

logical model

a technical pictorial representation that depicts what a system is or does and how the system is implemented.

physical model

a technique used to organize and document a system’s processes

process modeling

a process model used to depict the flow of data through a system and the work or processing performed by the system.

data flow diagram

What is dfd

data flow diagram

an outside person, unit, system, or organization that interacts with a system. Also called an external entity.

external agent

stored data intended for later use. Synonyms are file and database.

data store

work performed by a system in response to incoming data flows or conditions. A synonym is transform.

process

the act of breaking a system into sub-components. Each level of abstraction reveals more or less detail about the overall system or a subset of that system.

process decomposition

a tool used to depict the decomposition of a system. Also called hierarchy chart.

decomposition diagrams

a set of related and ongoing activities of a business.

function

a discrete, detailed activity or task required to complete the response to an event. Also called a primitive process

elementary process

data that is input to or output from a process

data flow

a data flow that consists of other data flows

composite data flow

a condition or nondata event that triggers a process.

control flow

the smallest piece of data that has meaning to the users and the business.

data attributes

a specific arrangement of data attributes that defines an instance of a data flow.

data structure

- a class of data that be stored in an attribute

data type

the legitimate values for an attribute.

domain

a data flow that splits into multiple data flows.

diverging data flow

the merger of multiple data flows into a single packet.

converging data flow

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 8

module 8

Module 9

Module 9

Module 10

Module 10

module 11

module 11

module 12

module 12

問題一覧

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

a pictorial representation of reality.

model

– a nontechnical pictorial representation that depicts what a system is or does. Synonyms for essential model, conceptual model, and business model

logical model

a technical pictorial representation that depicts what a system is or does and how the system is implemented.

physical model

a technique used to organize and document a system’s processes

process modeling

a process model used to depict the flow of data through a system and the work or processing performed by the system.

data flow diagram

What is dfd

data flow diagram

an outside person, unit, system, or organization that interacts with a system. Also called an external entity.

external agent

stored data intended for later use. Synonyms are file and database.

data store

work performed by a system in response to incoming data flows or conditions. A synonym is transform.

process

the act of breaking a system into sub-components. Each level of abstraction reveals more or less detail about the overall system or a subset of that system.

process decomposition

a tool used to depict the decomposition of a system. Also called hierarchy chart.

decomposition diagrams

a set of related and ongoing activities of a business.

function

a discrete, detailed activity or task required to complete the response to an event. Also called a primitive process

elementary process

data that is input to or output from a process

data flow

a data flow that consists of other data flows

composite data flow

a condition or nondata event that triggers a process.

control flow

the smallest piece of data that has meaning to the users and the business.

data attributes

a specific arrangement of data attributes that defines an instance of a data flow.

data structure

- a class of data that be stored in an attribute

data type

the legitimate values for an attribute.

domain

a data flow that splits into multiple data flows.

diverging data flow

the merger of multiple data flows into a single packet.

converging data flow