Tentamen (uitwerkingen)
Mizzou Management 3300 Exam 2 Christianson Questions and Answers
- Vak
- Instelling
Mizzou Management 3300 Exam 2 Christianson Questions and Answers
[Meer zien]Voorbeeld 3 van de 16 pagina's
Voorbeeld 3 van de 16 pagina's
In winkelwagen
In winkelwagen
gesponsord bericht van onze partner
Verkoper
Volgen
millyphilip
Ontvangen beoordelingen
Voorbeeld van de inhoud
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
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper millyphilip. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €11,65. Je zit daarna nergens aan vast.
Is Stuvia te vertrouwen?
4,6 sterren op Google & Trustpilot (+1000 reviews)
Afgelopen 30 dagen zijn er 75323 samenvattingen verkocht
Opgericht in 2010, al 14 jaar dé plek om samenvattingen te kopen