Exam (elaborations)
Exam 2 Management 3300 mizzou Christianson Questions and Answers
- Course
- Institution
Exam 2 Management 3300 mizzou Christianson Questions and Answers
[Show more]
Content preview
Exam 2 Management 3300 mizzouChristianson Questions 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. Drawing information out of unstructured collections presents challenges.
semi-structured information - Answers -shows at least some structure.
Meta Data - Answers -- Where you took a photo
• Who you called and for how long
• Who did you send an email to and when did you send it.
• When you login to facebook, snapchat or tinder.
• How long your car was turned on
• etc, etc, etc.
Relational integrity constraint - Answers -rule that enforces basic and fundamental
information based constraints
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
two relational integrity constraints for an ordering system - Answers -• Users cannot
create an order for a nonexistent
customer
• An order cannot be shipped without an address
two business-critical integrity constraints for an ordering system - Answers -• Product
returns are not accepted for fresh
product 15 days after purchase
• A discount maximum of 20 percent
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
Edgar F. Codd - Answers -Relational Databases
Primary Key - Answers -Indicates uniqueness within records or rows in a table.
-Primary keys ideally composed of only single
attribute
attribute
• Modern Database Management Software can
auto-number Primary Keys (1,2,3,4....) and
make sure they are unique
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 -• ER model forms the basis of an ER
diagram
• ERD represents conceptual database as viewed by
end user
• ERDs depict database's main components:
- Entities
- Attributes
- Relationships
Cardinality - Answers -• Cardinality expresses the number of records in an entity to
which other record(s) in a different entity can be associated via the relationship between
the two entities
• Cardinality Constrains - The number of records of one entity that can or must be
associated with each record of another entity.
• Minimum Cardinality
• If zero, then optional
• If one or more, then mandatory
• Maximum Cardinality
• The maximum number of records in an entity that relate to one record in another
entity.
Many-to-Many - Answers -• Many-to-many 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 relation between entities
5. Determine any Cardinality constraints (optional vs
mandatory)
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.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
71498 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now