Data Model

Multiple Choice

Which of the following is NOT a typical objective when learning about data models in database systems?

• To understand how major data models evolved

• To describe the basic data-modeling building blocks

• To memorize the names of all database vendors

• To explain how data models can be classified by their level of abstraction

Open Ended

Why do you think data models are important in the context of database systems?

Multiple Choice

Which of the following is an example of semi-structured data?

• Excel spreadsheets

• Comma-separated value file (.csv)

• Hypertext Markup Language (HTML) files

• Images such as .jpeg or .png files

Multiple Select

Which characteristics are true for unstructured data?

• Easily machine-readable and analyzed without major pre-processing

• Tags or markers separate elements and enforce hierarchies

• Can take any form and is often easily consumable for humans

• Most of the data created today is unstructured

Open Ended

Explain the main differences between structured, semi-structured, and unstructured data in terms of organization and example formats.

Open Ended

Why is data modeling important in database design?

Multiple Choice

Which of the following best describes the conceptual data model?

• Describes how data is stored on physical storage

• Provides concepts close to the way users perceive data

• Hides details of data storage disk

• For computer specialists

Multiple Choice

Which of the following best describes a 'relationship' in the context of data model basic building blocks?

• A characteristic of an entity

• A restriction placed on data

• An association among entities

• A person, place, thing, or event about which data is collected

Open Ended

Explain how business rules help in establishing entities, relationships, and constraints within an organization.

Multiple Choice

Which of the following are sources of business rules?

• Company managers

• Policy makers

• Department managers

• All of the above

Open Ended

Identify two reasons for documenting business rules.

Multiple Select

Which of the following are requirements for proper entity naming conventions?

• Be descriptive of the objects in the business environment

• Use terminology familiar to users

• Be required to be descriptive of the data represented by the attribute

• Facilitate communication between parties

Multiple Choice

Which concepts introduced by the network model are still used by modern data models?

• Schema and subschema

• Tuples and attributes

• Primary and foreign keys

• Normalization

Open Ended

What are the advantages of using a relational database management system (RDBMS) over hierarchical and network DBMS systems?

Multiple Choice

In the relational model, which field is used to connect the AGENT and CUSTOMER tables, and what type of relationship does it represent?

• AGENT_NAME, 1:1

• AGENT_CODE, 1:M

• CUS_PHONE, M:N

• AGENT_ADDRESS, 1:1

Open Ended

Explain how SQL contributes to the flexibility and power of the relational data model.

Multiple Choice

Which of the following is NOT a component of a SQL-based relational database application?

• End-user interface

• Collection of tables stored in the database

• SQL engine

• Entity relationship diagram

Multiple Choice

Which of the following terms is used to label the relationship types in an Entity Relationship Model?

• Entity

• Attribute

• Connectivity

• Instance

Multiple Select

Match the following ER model notations with their relationship types: One-to-Many, Many-to-Many, One-to-One.

• Chen Notation - One-to-Many, Crow's Foot Notation - Many-to-Many, UML Class Diagram - One-to-One

• Chen Notation - Many-to-Many, Crow's Foot Notation - One-to-One, UML Class Diagram - One-to-Many

• Chen Notation - One-to-One, Crow's Foot Notation - One-to-Many, UML Class Diagram - Many-to-Many

• Chen Notation - One-to-Many, Crow's Foot Notation - One-to-Many, UML Class Diagram - One-to-One

Multiple Choice

Which of the following is NOT a learning objective for this chapter?

• Discuss data modeling and why data models are important

• Describe the basic data-modeling building blocks

• Explain the process of database normalization

• List emerging alternative data models and the needs they fulfill

Open Ended

Reflecting on today's lesson about data models, what is one concept you found most interesting or would like to learn more about?