BTE 210 Exam 2 Questions with Correct Answers Latest Update () Already Passed
Data increases ______ with time? - Answers exponentially
what is Data Degradation? - Answers Issues that happen with the quality of data. Is the data correct?
customers move to new addresses, change their names
wh...
Data increases ______ with time? - Answers exponentially
what is Data Degradation? - Answers Issues that happen with the quality of data. Is the data correct?
customers move to new addresses, change their names
what is data rot? - Answers worthless data. Data that no longer is useful or exists. Maybe a flashdrive
went through the washing machine
physical problems with storage media and thus make it difficult to access
what are the 3 sources of data? - Answers 1) internal data sources
2) personal data sources
3) external data sources
what are Internal Data Sources? - Answers corporate databases and company documents
what are personal data sources? - Answers personal thoughts, opinions, experiences
Professor perez worked in sales and she recorded info about all her clients, like what drink they like.
Only she has this information
what are external data sources? - Answers commercial databases, government reports, and corporate
web sites
what is data governance? - Answers managing data information across an entire organization
what is master data? - Answers core data (e.g., customer, product, employee, vendor, geographic
location, etc.) that spans the entire enterprise information systems
what are 5 components of high quality data? - Answers Accurate
complete
,timely
accessible (you need to be able to access data anywhere, anytime, at any moment)
relevant (is it relevant at the time of the report)
these characteristics make data valuable
what would Umiamis master data be? - Answers address, birthday, c number, social security number,
email
Stuff like which club you were a part of freshman year wouldn't be master data
what is master data management? - Answers provides the ability to store, maintain, and manage a
consistent, accurate, and timely version of the company's master data
a process that spans all organizational business processes
databases minimize three main problems. what are they? - Answers 1) data redundancy
2) data isolation
3) data inconsistency
what is data redundancy? - Answers The same data are stored in many places
what is data isolation? - Answers Applications cannot access data associated with other applications
The opposite of data redundancy
what is data inconsistency? - Answers Various copies of the data do not agree
databases maximize three main things. What are they? - Answers 1) data security
2) data integrity
3) data independence
, what is data security? - Answers Keeping the organization's data safe from theft
what is data integrity? - Answers data must meet organizational constraints
Example: social security number can only have numbers
what is data independence? - Answers Applications and data are independent of one another
Each individual column in a database is called an? - Answers attribute
(column for student last name)
Each row for each student is called an? - Answers instance (or record)
last name, first name, c #, class part grade, exam grade for an individual student
Each individual cell in the spreadsheet is called? - Answers a field
example: "25" is in the field for class participation
what is a data file? - Answers grouping of related records
similar in appearance to an excel spreadsheet
what is a database? - Answers grouping of related data files
what is the relational database model? - Answers based on the concept of two-dimensional tables
designed with a number of related tables with each of these tables containing rows and columns
what is structured query language (SQL)? - Answers language used for interacting with a database
SQL allows people to perform complicated searches by using relatively simple statements or key words
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 TutorJosh. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £6.69. You're not tied to anything after your purchase.
