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