Exam (elaborations)
Management 3300 Exam 2 Mizzou Questions and Answers
- Course
- Institution
Management 3300 Exam 2 Mizzou Questions and Answers
[Show more]
Content preview
Management 3300 Exam 2 MizzouQuestions and Answers
structured information - Answers -usually considered to be facts and data
it is reasonably orderly, and can be broken down into component parts and organized
into hierarchies
unstructured information - Answers -has no inherent structure or order, and the parts
can't be easily linked together
it is more difficult to break down, categorize, organize, and query
metadata - Answers -data about data
clarifies the nature of the information
for structured information, it describes the definitions for each field, table and their
relationships
for unstructured or semi-structured info it describes properties of a document or other
resource
five advantages of databases - Answers -1. reduce redundancy
2. increase information quality
3. flexibility
4. increase information security
5. scalability
relational integrity constraint - Answers -rule that enforces basic and fundamental
information-based constraints (ensure accuracy and consistency of data)
business-critical integrity constraint - Answers -rule that enforce business rules vital to
an organization's success and often require more insight and knowledge than relational
integrity constraints
password - Answers -provides authentication of the user
access level - Answers -determines who has access to the different types of information
access control - Answers -determines types of user access, such as read-only access
,entity - Answers -object, concept or event (subject)
ex. Customer
attributes - Answers -a characteristic of an entity
ex. Customer ID, Customer Name, Contact Name, Phone #
record - Answers -the specific characteristics of one entity also called a row or tuple
ex. 314-882-2409 or David Logan
A representation of an entity in a meaningful way, which includes the attributes of the
entity, is called a ________.
table - Answers -a collection of records
ex. all the information
database - Answers -a collection of tables
stores info for a single application
primary key - Answers -indicates uniqueness within records or rows in a table
foreign key - Answers -the primary key from another table, this is the only way join
relationships can be established
The Entity Relationship (ER) Model - Answers -forms the basis of an ER diagram
ERD (entity relationship diagram) - Answers -represents conceptual database as
viewed by end user
depicts: entities, attributes, and relationships
cardinality - Answers -the count of records that are allowed or are necessary between
entity relationship
tells us how many rows we need from one table before we can link it to another table
"number of elements of the set"
Structured query language (SQL) - Answers -uses queries to retrieve records, insert
and edit data, and delete records.
widely used to manipulate information in relational databases
, IVR - Answers -interactive voice response
null value - Answers -cases where an attribute does not have an applicable value for an
attribute
never allowed in KEY fields
derived attribute - Answers -if an attribute can be calculated using the value of another
attribute
not stored in the file, but can be ___________ when needed from the stored attributes
stored attributes - Answers -the attribute that is used to derive the attribute
composite attributes - Answers -can be divided into smaller subparts, which represent
more basic attributes that have their own meanings
ex. Address
-can be broken down into a number of subparts, such as street, city, state, zip code
simple attributes - Answers -cannot be divisible into subparts
data dictionary - Answers -stores definitions of information types, identifies the primary
and foreign keys, and maintains the relationships among the tables.
database administrator (DBA) - Answers -the role may include capacity planning,
installation, configuration, database design, migration, performance monitoring, security,
troubleshooting, as well as backup and data recovery
big data - Answers -an accumulation of data from:
company employees entering data
users entering their own data
machines/computers are accumulating data
collections of data that are so enormous in size, so varied in content, and so fast to
accumulate that they are difficult to store and analyze transitional approaches
parallel processing - Answers -so much data is being generated that it can't load the
dataset on one computer, server. In order to compensate we use this
hadoop - Answers -an open source platform, allows parallel processing of big data
created by doug cutting
MapReduce - Answers -provides a table of contents for our data
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 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 millyphilip. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
67096 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now