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
The ____ model is the end users’ view of the data environment.
External
The terms data model and database model are often used interchangeably.
True
A manager and a programmer usually have the same view of the same data.
False
In an SQL-based relational database, each table is dependent on another.
False
In Chen notation, entities and relationships must be oriented horizontally.
False
The entity relationship model is limited to conceptual modeling, with no implementation component.
True
A(n) ____ represents a particular type of object in the real world.
Entity
Business rules are derived from ____.
-a detailed description of an organization’s operations
standards and practices developed over the years
managers’ recommendations
governmental oversight organization standards
MySQL is an example of a(n) ____.
a relational data model
In the ____ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent.
Network
The ____ data model is said to be a semantic data model.
Object-oriented
A(n) ____ model represents a global view of the database as viewed by the entire organization.
Conceptual
