Chapter 2 Flashcards
A data model is usually graphical.
True
An implementation-ready data model should contain a description of the data structure that will store the end-user data.
True
Data modeling starts with a very complex representation, and as knowledge of the problem is gained, the model is simplified.
False
Database designers determine the data and information that yield the required understanding of the entire business.
False
Business rules must be rendered in writing.
True
In an SQL-based relational database, rows in different tables are related based on common values in common attributes.
True
Each row in the relational table is known as an entity instance or entity occurrence in the ER model.
True
M:N relationships are not appropriate in a relational model.
True
The network model has structural level dependence.
True
The hierarchical model is software-independent.
False
A(n) ____’s main function is to help you understand the complexities of the real-world environment.
Model
A(n) ____ is anything about which data are to be collected and stored.
Entity
A(n) ____ is bidirectional.
Relationship
____ are important because they help to ensure data integrity.
Constraints
Students and classes have a ____ relationship.
Many to many
Which of the following is true of business rules?
They allow the designer to set company policies with regard to data.
They allow the designer to develop business processes.
-They can serve as a communication tool between the users and designers.
They provide a framework for the company’s self actualization.
A verb associating two nouns in a business rule translates to a(n) ____ in the data model.
Relationship
The object-oriented data model was developed in the ____.
1980s
Oracle 11g is an example of a(n) ____.
XML/Hybrid data model
In the ____ model, the basic logical structure is represented as an upside-down tree.
Hierarchichal
The relational data model was developed in the ____.
1970s
A(n) ____ enables a database administrator to define schema components.
Data definition language (DDL)
The ____ model uses the term connectivity to label the relationship types.
Entity relationship
The ____ data model uses the concept of inheritance.
Object-oriented