MIS 3140 Chap 2
The ____ model is the end users' view of the data environment. a. abstract b. external c. conceptual d. internal
External
A manager and a programmer usually have the same view of the same data. True or False
False
Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories. True or False
False
End-user interfaces require the end user to manually generate SQL code. True or False
False
A noun in a business rule translates to a(n) ____ in the data model. a. entity b. attribute c. relationship d. constraint
Entity
In Chen notation, entities and relationships must be oriented horizontally. True or False
False
In an SQL-based relational database, rows in different tables are related based on common values in common attributes. True or False
False
The hierarchical model is software-independent. True or False
False
MySQL is an example of a(n) ____. a. hierarchical model b. file system data model c. relational data model d. XML data model
Relational data model
A(n) ____ is bidirectional. a. attribute b. entity c. relationship d. constraint
Relationship
A data model is usually graphical. True or False
True
An implementation-ready data model should contain a description of the data structure that will store the end-user data. True or False
True
Business rules must be rendered in writing. True or False
True
Data modeling starts with a very complex representation, and as knowledge of the problem is gained, the model is simplified. True or False
True
Each row in the relational table is known as an entity instance or entity occurrence in the ER model. True or False
True
The entity relationship model is limited to conceptual modeling, with no implementation component. True or False
True
The network model has structural level dependence. True or False
True
The terms data model and database model are often used interchangeably. True or False
True
Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain. True or False
True
A(n) ____ is the equivalent of a field in a file system. a. attribute b. entity c. relationship d. constraint
attribute
