WGU C175 Study Guide Questions with 100%
Correct Answers
Data
Facts gathered together for analysis
1640-Blaise Pascal
adding machine similar to odometer
1805-Joseph Marie Jacquard
punch card for textile weaving patterns (Loom)
1833-Charles Babbage
loom records patterns in punch cards
1890-Herman Hollerith
tabulator/sorter punch cards Amercian census-ABM
1911-James Powers
automatic feeders Powers tabulators machine comp>UNIVAC>UnisysCorp
1930's
Erasable magnetic tape for storage
1940's
magnetic drum's begin prototype
Flat Files
A file having no internal hierarchy
,Hashed Files
A file that has been encrypted for security purposes
Heap Files
An unsorted set of records
Information
The transformation of raw data into useful facts
indexed-sequential file
an index built over a field
Punch Card
A card that is perforated and can hold commands or data
Structured Data
Information with a high degree of organization, organized in rows and columns
Unstructured Data
Information that does not have structure (such as text) cannot be stored in rows and text such
as email, sticky notes, business cards IM's...
Big Data
structured and unstructured data, large amount of data to handle
Digital Data
stored as strips of binary numbers
Binary relationship
, It is a relationship between two entity types. (simplest relationship)
Cardinality
(Means Count) It is the maximum number of entities that can be involved in a particular
relationship ie: one-one, one-many, many-many (Closest to entity cannot be zero, crows foot)
E-R Model (entity-relationship)
It is well named, as it diagrams entities (together with their attributes) and the relationships
among them
Intersection data
It is a data that describes a many-to-many relationship.
Modality
It is a minimum number of entity occurrences that can be involved in a relationship. (farthest
from entity can be zero)
One-to-One Binary Relationship
It means that a single occurrence of one entity type can be associated with a single occurrence
of the other entity type and vice versa.
Simple Linear Index
very close in structure to the index in the back of a book.
Ternary relationship
A relationship that involves three different entity types.
Unary relationship
It is an associate occurrence of an entity type with other occurrences of the same entity type.
Correct Answers
Data
Facts gathered together for analysis
1640-Blaise Pascal
adding machine similar to odometer
1805-Joseph Marie Jacquard
punch card for textile weaving patterns (Loom)
1833-Charles Babbage
loom records patterns in punch cards
1890-Herman Hollerith
tabulator/sorter punch cards Amercian census-ABM
1911-James Powers
automatic feeders Powers tabulators machine comp>UNIVAC>UnisysCorp
1930's
Erasable magnetic tape for storage
1940's
magnetic drum's begin prototype
Flat Files
A file having no internal hierarchy
,Hashed Files
A file that has been encrypted for security purposes
Heap Files
An unsorted set of records
Information
The transformation of raw data into useful facts
indexed-sequential file
an index built over a field
Punch Card
A card that is perforated and can hold commands or data
Structured Data
Information with a high degree of organization, organized in rows and columns
Unstructured Data
Information that does not have structure (such as text) cannot be stored in rows and text such
as email, sticky notes, business cards IM's...
Big Data
structured and unstructured data, large amount of data to handle
Digital Data
stored as strips of binary numbers
Binary relationship
, It is a relationship between two entity types. (simplest relationship)
Cardinality
(Means Count) It is the maximum number of entities that can be involved in a particular
relationship ie: one-one, one-many, many-many (Closest to entity cannot be zero, crows foot)
E-R Model (entity-relationship)
It is well named, as it diagrams entities (together with their attributes) and the relationships
among them
Intersection data
It is a data that describes a many-to-many relationship.
Modality
It is a minimum number of entity occurrences that can be involved in a relationship. (farthest
from entity can be zero)
One-to-One Binary Relationship
It means that a single occurrence of one entity type can be associated with a single occurrence
of the other entity type and vice versa.
Simple Linear Index
very close in structure to the index in the back of a book.
Ternary relationship
A relationship that involves three different entity types.
Unary relationship
It is an associate occurrence of an entity type with other occurrences of the same entity type.
