©THESTAR 2024/2025 ALL RIGHTS RESERVED 12:43 PM.
Management 3300 mizzou Christianson
Exam 2 Questions With Correct Answers
100% Verified.
Structured information - Answer✔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 - Answer✔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 - Answer✔shows at least some structure.
Meta Data - Answer✔- 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 - Answer✔rule that enforces basic and fundamental information
based constraints
Business-critical integrity constraint - Answer✔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 - Answer✔• Users cannot create an
order for a nonexistent
customer
• An order cannot be shipped without an address
1
, ©THESTAR 2024/2025 ALL RIGHTS RESERVED 12:43 PM.
two business-critical integrity constraints for an ordering system - Answer✔• Product returns
are not accepted for fresh
product 15 days after purchase
• A discount maximum of 20 percent
Password - Answer✔provides authentication of the user
Access level - Answer✔determines who has access to the different types of information
Access control - Answer✔determines types of user access, such as read-only access
Edgar F. Codd - Answer✔Relational Databases
Primary Key - Answer✔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 - Answer✔the Primary key from another table, this is the only way join
relationships can be established.
The Entity Relationship (ER) Model - Answer✔• 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 - Answer✔• 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
2
Management 3300 mizzou Christianson
Exam 2 Questions With Correct Answers
100% Verified.
Structured information - Answer✔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 - Answer✔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 - Answer✔shows at least some structure.
Meta Data - Answer✔- 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 - Answer✔rule that enforces basic and fundamental information
based constraints
Business-critical integrity constraint - Answer✔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 - Answer✔• Users cannot create an
order for a nonexistent
customer
• An order cannot be shipped without an address
1
, ©THESTAR 2024/2025 ALL RIGHTS RESERVED 12:43 PM.
two business-critical integrity constraints for an ordering system - Answer✔• Product returns
are not accepted for fresh
product 15 days after purchase
• A discount maximum of 20 percent
Password - Answer✔provides authentication of the user
Access level - Answer✔determines who has access to the different types of information
Access control - Answer✔determines types of user access, such as read-only access
Edgar F. Codd - Answer✔Relational Databases
Primary Key - Answer✔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 - Answer✔the Primary key from another table, this is the only way join
relationships can be established.
The Entity Relationship (ER) Model - Answer✔• 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 - Answer✔• 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
2
