Entity correct answers Attributes, columns, fields, keys stores info about a person, place , thing , transaction , or event
Database Management System correct answers Deletes, creates, updates, and reads data
Relation Database Model correct answers Stores info in the form of logically related...
CIS 2010 GSU FINAL || WITH ANSWERS ALL
PASSED!!
Entity correct answers Attributes, columns, fields, keys stores info about a person, place ,
thing , transaction , or event
Database Management System correct answers Deletes, creates, updates, and reads data
Relation Database Model correct answers Stores info in the form of logically related 2-d
labels
Primary Key correct answers Is a field (or group of fields) that uniquely identifies a given
record in a table
Query-by-example correct answers Helps users graphically design the answer to questions
against database
Record correct answers Collection of data elements
Database correct answers Maintains information about various types of objects, inventory,
events (transactions), people (employees) and place (warehouses)
Foreign key correct answers Primary key of one table that appears as an attribute on another
table and acts to provide a logical relationship between 2 tables
Relational database correct answers Increased information security increased information
integrity
Integrity constraints correct answers Rules that help ensure the quality of information
Data Dictionary correct answers Compiles all of the meta data about the data about the data
elements in a data model
Information Redundancy correct answers Is the duplication of data or the storage of some
data in multiple places
Metadata correct answers Provides details about data
Relational Integrity Constraint correct answers Rules that enforce basic and fundamental
information-based constraints
Data models correct answers Data structures that details the real action ship between
graphical elements in pictures or data
Structured Query Language correct answers Tool where users write order of data
Information Integrity correct answers Measure of the quality of information
Dirty Data correct answers Flawed or erroneous data
, Infographics correct answers Presents the results of data analysis
Information scrubbing correct answers Weeding out, fixing or discarding inconsistent,
incorrect or incomplete data
Classification correct answers Assigns records to one of pre-defined set of classes
Estimation correct answers Determines values for an unknown continuous variables behavior
or estimated future value
Affinity Group correct answers Determines what things go where
Clustering correct answers Segments to heterogeneous population of records into a number of
more homogeneous subgroups
Data warehouse correct answers Is a logical collection of information gathered from many
operational databases, that supports business analysis activities and decision making tasks
Data mining correct answers To analyze date and extract info
Machine generated data correct answers Created by a machine without human interaction
Advanced Analytics correct answers Forcasting future trends and producing insights
Distributed computing correct answers Processes and manages algorithms
Web analytics correct answers Analyazes unstructured data to identify consumer behavior
Variety correct answers Different forms of structured and unstructured data
Veracity correct answers The uncertainty of data, including invoices and abnormalities
Volume correct answers The scale of data, enormous values of data generated daily by
machines and networks
Structured data correct answers Data with defined length type, and formats and includes
numbers, data, or strings such as customer address
Data mart correct answers Contains a subset of data of a data warehouse
Data scientist correct answers Extracts data by performing statistical analysis
Text analytics correct answers Analyzes unstructured data from sentences and texts
Cluster analysis correct answers Divides information sets into mutually exclusive groups
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller ProPerfomer. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.39. You're not tied to anything after your purchase.
