Deck 2: Data Models

Question 1

A manager and a programmer usually have the same view of the same data.

Answer 1

False

Question 2

An implementation-ready data model should contain a description of the data structure that will store the end-user data.

Answer 2

True

Question 3

A data model is usually graphical.

Answer 3

True

Question 4

M:N relationships are not appropriate in a relational model.

Question 5

In an SQL-based relational database,rows in different tables are related based on common values in common attributes.

Question 6

In Chen notation,entities and relationships must be oriented horizontally.

Question 7

The entity relationship model is limited to conceptual modeling,with no implementation component.

Question 8

Within the database environment,a data model represents data structures with the purpose of supporting a specific problem domain.

Question 9

Business rules must be rendered in writing.

Question 10

Data modeling starts with a very complex representation,and as knowledge of the problem is gained,the model is simplified.

Question 11

Each row in the relational table is known as an entity instance or entity occurrence in the ER model.

Question 12

The hierarchical model is software-independent.

Question 13

Use of the relational model has declined because of the difficulty in incorporating features from the object-oriented (OO)data model.

Question 14

End-user interfaces require the end user to manually generate SQL code.

Question 15

The relational model is hardware-dependent and software-independent.

Question 16

Business rules apply to businesses and government groups,but not to other types of organizations such as religious groups or research laboratories.

Question 17

Database designers determine the data and information that yield the required understanding of the entire business.

Question 18

In an SQL-based relational database,each table is dependent on another.

Question 19

The network model has structural level dependence.

Question 20

The terms data model and database model are often used interchangeably.

Question 21

A(n)____ is bidirectional.

A) attribute
B) entity
C) relationship
D) constraint

Question 22

A(n)____ is a restriction placed on the data.

A) attribute
B) entity
C) relationship
D) constraint

Question 23

____ are important because they help to ensure data integrity.

A) Attributes
B) Entities
C) Relationships
D) Constraints

Question 24

The hierarchical data model was developed in the ____.

A) 1960s
B) 1970s
C) 1980s
D) 1990s

Question 25

Students and classes have a ____ relationship.

A) one-to-one
B) one-to-many
C) many-to-one
D) many-to-many

Question 26

Which of the following is true of business rules?

A) They allow the designer to set company policies with regard to data.
B) They allow the designer to develop business processes.
C) They can serve as a communication tool between the users and designers.
D) They provide a framework for the company's self actualization.

Question 27

A verb associating two nouns in a business rule translates to a(n)____ in the data model.

A) entity
B) attribute
C) relationship
D) constraint

Question 28

A(n)____ represents a particular type of object in the real world.

A) attribute
B) entity
C) relationship
D) constraint

Question 29

A(n)____ is anything about which data are to be collected and stored.

A) attribute
B) entity
C) relationship
D) constraint

Question 30

____ are normally expressed in the form of rules.

A) Attributes
B) Entities
C) Relationships
D) Constraints

Question 31

A(n)____ is the equivalent of a field in a file system.

A) attribute
B) entity
C) relationship
D) constraint

Question 32

A noun in a business rule translates to a(n)____ in the data model.

A) entity
B) attribute
C) relationship
D) constraint

Question 33

In the ____ model,each parent can have many children,but each child has only one parent.

A) hierarchical
B) network
C) relational
D) entity relationship

Question 34

VMS/VSAM is an example of a(n)____.

A) hierarchical model
B) file system data model
C) relational data model
D) XML data model

Question 35

Business rules are derived from ____.

A) a detailed description of an organization's operations
B) standards and practices developed over the years
C) managers' recommendations
D) governmental oversight organization standards

Question 36

MySQL is an example of a(n)____.

A) hierarchical model
B) file system data model
C) relational data model
D) XML data model

Question 37

Oracle 11g is an example of a(n)____.

A) hierarchical model
B) file system data model
C) relational data model
D) XML/Hybrid data model

Question 38

In the ____ model,the basic logical structure is represented as an upside-down tree.

A) hierarchical
B) network
C) relational
D) entity relationship

Question 39

Which of the following is a basic building block of all data models?

A) category
B) class
C) constraint
D) customer

Question 40

The object-oriented data model was developed in the ____.

A) 1960s
B) 1970s
C) 1980s
D) 1990s

Question 41

The ____ model uses the term connectivity to label the relationship types.

A) relational
B) network
C) object-oriented
D) entity relationship

Question 42

Which data model has the highest level of abstraction?

A) Object-oriented
B) Entity relationship
C) Relational
D) Hierarchical

Question 43

A(n)____ model represents a global view of the database as viewed by the entire organization.

A) external
B) conceptual
C) internal
D) physical

Question 44

Each column in a relation represents a(n)____________________.

Question 45

Each row in a relation is called a(n)____________________.

Question 46

The ____________________ is the conceptual organization of the entire database as viewed by the database administrator.

Question 47

A(n)____________________ is a relatively simple representation of more complex real-world data structures.

Question 48

The ____ model is said to be a semantic data model.

A) relational
B) network
C) object-oriented
D) entity relationship

Question 49

In ____________________,relationships are represented by a diamond connected to the related entities through a relationship line.

Question 50

The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.

A) hierarchical
B) network
C) object-oriented
D) entity relationship

Question 51

In _________________________,a three-pronged symbol represents the "many" side of the relationship.

Question 52

The ____ model uses the concept of inheritance.

A) relational
B) network
C) object-oriented
D) entity relationship

Question 53

A(n)____________________ is a brief,precise,and unambiguous description of a policy,procedure,or principle within a specific organization.

Question 54

The ____________________ defines the portion of the database "seen" by the application programs that produce information from the data.

Question 55

One of the limitations of the ____ model is that there is a lack of standards.

A) hierarchical
B) network
C) relational
D) entity relationship

Question 56

The relational data model was developed in the ____.

A) 1960s
B) 1970s
C) 1980s
D) 1990s

Question 57

A(n)____________________ is a representation of the relational database's entities,the attributes within those entities and the relationships between those entities.

Question 58

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.

A) hierarchical
B) network
C) object-oriented
D) entity relationship

Question 59

A(n)____ enables a database administrator to define schema components.

A) extensible markup language (XML)
B) data definition language (DDL)
C) unified modeling language (UML)
D) query language

Question 60

A(n)____________________ in a hierarchical model is the equivalent of a record in a file system.

Question 61

A(n)____________________ is a collection of similar objects with a shared structure and behavior.

Question 62

Describe a conceptual model and its advantages.What is the most widely used conceptual model?

Question 63

Describe the three parts involved in any SQL-based relational database application.

Question 64

___________________________________ is a language based on OO concepts that describes a set of diagrams and symbols used to graphically model a system.

Question 65

When you can change the internal model without affecting the conceptual model,you have ____________________ independence.

Question 66

The term ____________________ is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS.

Question 67

What components should an implementation-ready data model contain?

Question 68

In object-oriented terms,a(n)____________________ defines an object's behavior.

Question 69

What are the sources of business rules,and what is the database designer's role with regard to business rules?

Question 70

What do business rules require to be effective?