IT 330 Quiz 2 – Flashcards
30 test answers
Unlock all answers in this set
Unlock answers 30question
A(n) ____ is bidirectional.
answer
Relationship
Unlock the answer
question
A(n) ____ is a restriction placed on the data.
answer
Constraint
Unlock the answer
question
____ are important because they help to ensure data integrity.
answer
Constraints
Unlock the answer
question
____ are normally expressed in the form of rules.
answer
Constraints
Unlock the answer
question
Students and classes have a ____ relationship.
answer
Many-to-Many
Unlock the answer
question
Business rules are derived from ____.
answer
A detailed description of an organization's operations
Unlock the answer
question
Which of the following is true of business rules?
answer
They can serve as a communication tool between the users and designers.
Unlock the answer
question
A noun in a business rule translates to a(n) ____ in the data model.
answer
Entity
Unlock the answer
question
A verb associating two nouns in a business rule translates to a(n) ____ in the data model.
answer
Relationship
Unlock the answer
question
The hierarchical data model was developed in the ____.
answer
1960's
Unlock the answer
question
The object-oriented data model was developed in the ____.
answer
1980's
Unlock the answer
question
VMS/VSAM is an example of a(n) ____.
answer
File System Data Model
Unlock the answer
question
Oracle 11g is an example of a(n) ____.
answer
XML/Hybrid Data Model
Unlock the answer
question
MySQL is an example of a(n) ____.
answer
Relational Data Model
Unlock the answer
question
In the ____ model, the basic logical structure is represented as an upside-down tree.
answer
Hierarchical
Unlock the answer
question
In the ____ model, each parent can have many children, but each child has only one parent.
answer
Hierarchical
Unlock the answer
question
The relational data model was developed in the ____.
answer
1970's
Unlock the answer
question
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.
answer
Network
Unlock the answer
question
A(n) ____ enables a database administrator to define schema components.
answer
Data Definition Language (DDL)
Unlock the answer
question
The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text.
answer
Entity Relationship
Unlock the answer
question
The ____ model uses the term connectivity to label the relationship types.
answer
Entity Relationship
Unlock the answer
question
The ____ model is said to be a semantic data model.
answer
Object Oriented
Unlock the answer
question
The ____ model uses the concept of inheritance.
answer
Object Oriented
Unlock the answer
question
One of the limitations of the ____ model is that there is a lack of standards.
answer
Hierarchical
Unlock the answer
question
Which data model has the highest level of abstraction?
answer
Entity Relationship
Unlock the answer
question
A(n) ____ model represents a global view of the database as viewed by the entire organization.
answer
Conceptual
Unlock the answer
