Topic 2 Flashcards
A (n) _____’s main function is to help one understand the complexities of the real-world environment
a. node
b. entity
c. model
d. database
model
A (n) _____ is anything about which data are to be collected and stored
a. attribute
b. entity
c. relationship
d. constraint
entity
A (n) _____ represents a particular type of object in the real world
a. attribute
b. entity
c. relationship
d. node
entity
A (n) _____ is the equivalent of a field in a file system
a. attribute
b. entity
c. relationship
d. constraint
attribute
A (n) _____ is bidirectional
a. attribute
b. entity
c. relationship
d. constraint
relationship
A (n) _____ is a restriction placed on the data
a. attribute
b. entity
c. relationship
d. constraint
constraint
_____ are important because they help to ensure data integrity
a. Attributes
b. Entities
c. Relationships
d. Constraints
Constraints
_____ are normally expressed in the form of rules
a. Attributes
b. Entities
c. Relationships
d. Constraints
Constraints
Students and classes have a _____ relationship
a. one-to-one
b. one-to-many
c. many-to-one
d. many-to-many
many-to-many
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.
They can serve as a communication tool between the users and designers
A noun in a business rule translates to a (n) _____ in the data model
a. entity
b. attribute
c. relationship
d. constraint
entity
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
relationship
In the _____ model, the basic logical structure is represented as an upside-down tree
a. hierarchical
b. network
c. relational
d. entity relationship
hierarchical
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
hierarchical
The hierarchical data model was developed in the _____
a. 1960s
b. 1970s
c. 1980s
d. 1990s
1960s
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
network
The object-oriented data model was developed in the _____
a. 1960s
b. 1970s
c. 1980s
d. 1990s
1980s
VMS/VSAM is an example of the _____
a. hierarchical model
b. file system data model
c. relational data model
d. XML data model
file system data model
Oracle 12c, MS SQL Server, and Tamino are examples of _____ data models
a. hierarchical
b. file system
c. relational
d. XML Hybrid
XML Hybrid
MySQL is an example of the _____
a. hierarchical model
b. file system data model
c. relational data model
d. XML data model
relational data model
A (n) _____ enables a database administrator to describe schema components
a. extensible markup language (XML)
b. data definition language (DDL)
c. unified modeling language (UML)
d. query language
data definition language (DDL)
The relational data model was developed in the _____
a. 1960s
b. 1970s
c. 1980s
d. 1990s
1970s
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
entity relationship
A (n) _______ enables a database administrator to describe schema components
a. extensible markup language (XML)
b. data definition language (DDL)
c. unified modeling language (UML)
d. query language
data definition language (DDL)
