100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
CIS 2010 FINAL EXAM || WITH A+ GRADED SOLUTIONS!! $11.09   Add to cart

Exam (elaborations)

CIS 2010 FINAL EXAM || WITH A+ GRADED SOLUTIONS!!

 7 views  0 purchase
  • Course
  • CIS
  • Institution
  • CIS

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...

[Show more]

Preview 2 out of 6  pages

  • September 17, 2024
  • 6
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • CIS
  • CIS
avatar-seller
ProPerfomer
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

External Databases correct answers Competitor inf, industry info, mailing lists, stock market
analysis.

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

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

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

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.09. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

82191 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$11.09
  • (0)
  Add to cart