Exam (elaborations)
Mizzou Management 3300 Exam 2 Christianson Questions and Answers
- Course
- Institution
Mizzou Management 3300 Exam 2 Christianson Questions and Answers
[Show more]
Content preview
Mizzou Management 3300 Exam 2Christianson Questions and Answers
Structured Information - Answers -Considered to be facts and data. Reasonably
ordered. can be broken down into competent parts and organized into hierarchies.
Unstructured Information - Answers -No inherent structure or oder. Parts cant be easily
linked together. More difficult to break down, categorize, organize, and query. Presents
challenges.
Metadata - Answers -data about data, clarifies the nature of the information
Structured Data - describes the definitions of for each field, table, and their
relationships.
Semi structured / Unstructured Data - Describe properties of a document or other
resource.
Flickr - popular photo sharing website. relies on metadata to search its enormous photo
collection.
Accuracy - Answers -Mistakes reduce the quality of information
Precision - Answers -Rounding might not reduce quality in some settings, but would be
unacceptable in other settings.
completeness - Answers -While omitting the zip code on the customers address record
might not be a problem because the zip can be determined by the address, leaving off
the house number would delay the order
Consistency - Answers -Reports that show that what appears to be the same
information may conflict because the people generating the reports are slightly different
definitions.
Using the same value of measure. How we format.
Timeless - Answers -Outdated information has less value then up-to-date information,
and thus is lower quality unless you are specifically looking for historical trends.
Bias - Answers -Information thats is ____________ lacks objectivity, a feature that
reduces its value and quality.
,Duplication - Answers -Information can be redundant, resulting in misleading and
exaggerated summaries.
Five Advantages of Databases - Answers -1. Reduce Redundancy
2. Increase Information Quality
3. Flexibility
4. Scalability
5. Increase Information Security
relational integrity constraints - Answers -Rule that enforce basic and fundamental
information-based constraints.
Business-critical integrity constraints - Answers -Enforces business rules vital to an
organization's success and often requires 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.
Acces control - Answers -determines type of use access, such as read-only access.
Edgar F. Codd - Answers -Developed the Relational Database Model,
Revolutionized the way data is stored and retrieved.
Entity - Answers -Object, Concept or event ( subject )
Attribute - Answers -a characteristic of an entity
Record, or Row - Answers -specific characteristic of one entity, also called a Tuple
Table - Answers -a collection of records
Database - Answers -a collection of tables
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.
ERDs (Entity Relation Diagrams) - Answers -Represents the conceptual database as
viewed by the end user.
Depict databases main components
Entities - Attributes - Relationships
, Crow's Foot Model - Answers -Entity is represented by rectangle containing entity's
name.
Entity name written in capital letters
Attributes are written in attribute box below entity rectangle
cardinality - Answers -Expresses the number of records in an entity to which other
records in a different entity can be associated via the relationship between the two
entities.
In mathematics, the cardinality of a set is a measure of the "number of elements of the
set"
Cardinality Constraints - Answers -the number of instances of one entity that can or
must be associated with each instance of another entity.
Minimum Cardinality - Answers -If zero, then optional
If one or more, then mandatory
Maximun Cardinality - Answers -Maximum numbers of records in an entity that relate to
one record in another entity
Circular Reference - Answers -should never be used in creating ERDs
Many-to-Many Relationship - Answers -these relationships need to be replaced with a
collection of one-to-many relationships.
An entity must represent the relationship.
Steps to Creating an ERD - Answers -1. Identify entities (tables)
2. Identify attributes for each entity
3. Identify Or create primary Key fields
4. Determine the relationship between entities
5. Determine an Carnality Contraints
(optional vs. Mandatory)
6. Draw the ERD (in pencil)
7. Check ERD (write out what the diagram is telling you
and make sure that was what you wanted)
Retrieving Information - Answers -Structured query language (SQL)
Interactive voice response (IVR)
Natural language interfaces
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 $11.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now