Section 2 Quiz Practice
Each column in a relation is called _______.
An attribute
From a database point of view, the collection of data becomes meaningful only when it reflects properly defined _____.
Business rules
A(n) ____ is a restriction based on the data.
Constraint
____ are important because they help to ensure data integrity.
Constraints
In ____, a three-pronged symbol represents the "many" side of a relationship.
Crow foot notation
T/F: A disadvantage of the relational database management system is its inability to hide the complexities of the relational model from the user.
F
T/F: Business rules apply to business and govt groups, but not other types or organizations such as religious or research groups.
F
T/F: Database designers determine the data and information that yield the required understanding of the entire business.
F
T/F: Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end-user.
F
T/F: In Chen notation, entities and relationships have to be oriented horizontally.
F
T/F: In a SQL-based relational database, each table is dependent on every other table.
F
T/F: The hierarchical model is software-independent.
F
T/F: The relational model is hardware and software-independent.
F
One of the limitations of the _____ model is that there is a lack of standards.
Hierarchical
What is a disadvantage of the hierarchical data model?
It doesn't have standards
Students and classes have a ____ relationship.
Many-to-many
The ___ data model is said to be a semantic data model.
Object-oriented
The ____ data model uses the concept of inheritance.
Object-oriented
A(n) ____ is bidirectional.
Relationship
T/F: A data model is usually graphical.
T
T/F: An implementation-ready data model should contain a description of the data structure that will store the end-user data
T
T/F: Business rules must be rendered in writing.
T
T/F: Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain.
T
Each row in a relation is called a(n) _____.
Tuple
The hierarchical data model was developed in the ____.
1960s-1970s
The relational data model was developed in the ____.
1970s
A(n) ____ is the equivalent of a field in a file system.
Attribute
A noun in a business rule translates to a(n) ____ in the data model.
Entity
MySQL is an example of the _____.
Relational data model
A(n) ____ in a hierarchical model is the equivalent of a record in a file system.
Segment
T/F: M:N relationships are not appropriate in a relational model.
T
T/F: The network model has structural level dependence.
T
What is true of business rules?
They serve as a communication tool between the users and the designers.
Oracle 12c is an example of the ____.
XML/Hybrid data model
The object-oriented data model was developed in the ____.
1980s
A(n) ____ is a brief, precise, and unambiguous description of a policy, procedure, or principle w/in a specific organization.
Business rule
A(n) ____ is a collection of similar objects with a stared structure and behavior.
Class
A(n) ____ enables a database admin to describe schema components.
Data Definition Language, DDL
A ____ defines the environment in which data can be managed and is used to work with data in the database.
Data Manipulation Language, DML
What type of HDFS node stores all the metadata about a file system?
Name node
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.
Network
T/F: In an SQL-based relational database, rows in different tables are related based on common values in common attributes.
T
T/F: In data models, an entity is a noun about which data will be collected and stored.
T
T/F: Today most relational database products can be classified as object/relational.
T
What is true of NoSQL databases?
They're not based on the relational model.
Which type of HDFS node acts as the interface between the user application and the HDFS?
Client node
____ are normally expressed in the form of rules.
Constraints
A(n) ___ is a relatively simple representation of more complex real-world data structures.
Data model
A(n) ____ is anything about which data are to be collected and stored.
Entity
A(n) ____ represents a particular type of object in the real world.
Entity
Each row in the relational table is called a(n) _____.
Entity instance
The ___ model uses the term "connectivity" to label the relationship types.
Entity relationship
The ___ model was developed to allow designers to use a graphical tool to examine structures rather than describing them w/ text.
Entity relationship.
T/F: An implementation-ready data model should contain a description of the data structure that will store the end-user data
F
VMS/VSAM is an example of the _____.
File system data model or First Generation
In the ____ model, each parent can have many children, but each child only has one parent.
Hierarchical
In the ____ model, the basic logical structure is represented as an upside-down tree.
Hierarchical
In object-oriented terms, a(n) ____ defines an object's behavior.
Method
A(n) ____'s main function is to help one understand the complexities of the real-world environment.
Model
NoSQL databases...
Provide fault tolerance
The relational model's foundation is a math concept known as a ____.
Relation
A verb associating two nouns in a business rule translates to a(n) _____ in the data model.
Relationship
A(n) ____ is the conceptual organization of an entire database as viewed by a database administrator.
Schema
