49 Questions
Which of the following best describes data modeling?
Creating a specific data model for a determined problem domain
What is the importance of data modeling?
All of the above
How can data models be classified?
By their level of abstraction
Which level of abstraction does the physical model operate at?
Low
What is the main focus of the conceptual model?
Global view of data
What is the main characteristic of the internal schema?
Software and hardware dependence
What is the purpose of the physical model?
To describe the way data are saved on storage media
Which model was developed to manage large amounts of data for complex manufacturing projects?
Hierarchical model
Which model allows a record to have more than one parent?
Network model
Which model uses a graphical representation to model database components?
Entity Relationship model
Which model allows a record to have more than one parent?
Network Model
Which model contains data and their relationships in a single structure known as an object?
Object-Oriented Data model
Which model promotes structural independence using independent tables?
Relational Model
Which model has limited constraint representation and limited relationship representation?
Entity Relationship Model
Which model represents a global view of the entire database by the entire organization?
Conceptual Model
Which of the following is NOT one of the basic building blocks of a data model?
Constraint
What is the purpose of business rules in an organization?
To create and enforce actions within the organization's environment
Which of the following is a source for discovering business rules?
All of the above
What is the role of naming conventions in data modeling?
All of the above
Which model was created to represent complex data relationships effectively?
Network model
Which model uses a graphical representation to model database components?
Entity Relationship model
Which model allows a record to have more than one parent?
Network model
Which model promotes data sharing and conceptual simplicity with its parent/child relationship?
Hierarchical model
Which model contains data and their relationships in a single structure known as an object?
Object-Oriented Data model
Which model is an SQL-based relational database application?
Relational model
Which model operates at the lowest level of abstraction and describes the way data is saved on storage media?
Physical model
What type of independence is achieved when changes in the physical model do not affect the internal model?
Physical independence
Which model represents a global view of the entire database by the entire organization?
Conceptual model
What is the main focus of the logical model?
Global view of data
Which type of data model is an abstraction of a complex real-world data environment?
Relational model
What type of independence is achieved when changing the internal model does not affect the conceptual model?
Logical independence
Which model allows a record to have more than one parent?
Network Model
Which model promotes structural independence using independent tables?
Relational Model
Which model uses a graphical representation to model database components?
Entity Relationship Model
Which model has limited constraint representation and limited relationship representation?
Entity Relationship Model
What is the main focus of the conceptual model?
High-level description of data objects
Which level of abstraction does the physical model operate at?
Low-level
Which of the following is NOT a basic building block of a data model?
Constraint
What is the purpose of business rules in an organization?
To create and enforce actions within the organization's environment
Which of the following is NOT a source for discovering business rules?
Written documentation
How do nouns translate into data model components?
Nouns translate into entities
What is the main purpose of naming conventions in data modeling?
To promote self-documentation
Which of the following examples represents a one-to-many relationship?
Each customer can place one or many orders
Which one of the following is NOT a reason why data modeling is important?
Provides an abstraction for the creation of a good database
What is the purpose of data modeling?
To represent complex real-world data structures
Which of the following is NOT a level of abstraction at which data models can be classified?
Structural
What is a data model?
A simple representation of complex real-world data structures
Which model allows a record to have more than one parent?
Network model
What are business rules and how do they influence database design?
Business rules are rules that govern the operation of a business and they influence the design of a database
Quiz on Hierarchical Models in Bowling Applications
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
