Entities correct answers Stores info about a person, place, thing, idea, transaction or event (table).
Attributes correct answers Data element associated with an entity.
Records correct answers Collection of data elements
Database Management System (DBMS) correct answers Creates, reads, up...
CIS 2010 FINAL EXAM || WITH A+ GRADED
SOLUTIONS!!
Entities correct answers Stores info about a person, place, thing, idea, transaction or event
(table).
Attributes correct answers Data element associated with an entity.
Records correct answers Collection of data elements
Database Management System (DBMS) correct answers Creates, reads, updates, and deletes
data in a database while controlling access and security
Relational Databases correct answers DBMS data model for organizing information. Stores
info in the form of logically related two dimensional tables.
Advantages of relational databases correct answers 1. Increased flexibility
2. Increased info integrity
3. increased scalability and performance
4. increased info security
5. Reduced info redundancy
Redundant Data correct answers The duplication of data or the storage of the same data in
multiple places.
Can cause issues as well as data integrity issues making it difficult to determine which values
are the most current and accurate.
Metadata correct answers Provides details about data
i.e. Metadata for an image could be the image size. Metadata for a text document could be the
document length, data created, author, ect.
Data element (Data field) correct answers the smallest most basic unit of info. Can include
customer name, address, email, discount rate, preferred shipping method, product names, ect.
Foreign Key correct answers A primary key of one table that appears as an attribute in
another table and acts to provide a logical relationship between the two tables
Metadata correct answers Provides data about data
Primary Key correct answers A field (or group of fields) that uniquely identifies a given
entity in a table
Redundant Data correct answers Can cause storage issues as well as data integrity issues
making it difficult to determine which values are the most accurate and current
Structured Query Language (SQL) correct answers asks users to write lines of code to answer
questions against a database
, Blockchain correct answers a distributed ledger that provides a way for information to be
recorded and shared by a community. Each member maintains his or her own copy of the info
and all members must validate any updates collectively. The information could represent
transactions, contracts, assets, identities, or anything that can be described in digital form.
Bitcoin correct answers The primary instance of blockchain tech is found in bitcoin. It has
been around the longest, has greatest market share and is supported the most.
advantages of blockchain/bitcoin correct answers collection of cryptographic hash, public key
encryption, merkle tree data structures or proof of work.
Hash correct answers Computer science and advanced mathematics protect the blockchains
integrity and anonymity. Each transaction has a digital has calculated and attached. The hash
includes digital signatures from the blockchain as well as the new transaction.
Internal databases correct answers Marketing, sales, inventory, and billing
Data warehouses correct answers Combines info more specifically strategic info throughout
an organization into a single repository so that ppl who need that info can make a decision
and undertake business analysis.
Dirty data correct answers flawed data
Info Scrubbing correct answers process that weeds out and fixes or discards inconsistent,
incorrect, or incomplete info.
ETL correct answers extraction, transformation, and loading. A process that extracts info
from internal and external databases. Transforms the info using a common set of enterprise
definitions, and loads the info into data warehouse.
Data warehouse correct answers Logical collection of info gathered from many different
operational databases and supports business analytics activities and decision making tasks.
Virtualization correct answers Creation of a virtual version of computing resources, such as
an operating system, server, storage device, or network resources
Info cube correct answers representation of multidimensional info. Once the cube is created,
user can slice the cube to drill down the info.
Analytics correct answers science of fact based decision making. uses software based
algorithms and stats to derive meaning from data.
data visualization correct answers describes tech that allow users to see or visualize data to
transform info into a business perspective
Data analytics correct answers process of inspecting, cleansing, transforming, and modeling
data with the goal of discovering useful info for better decision making
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
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 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 £8.71. You're not tied to anything after your purchase.