DATABASE CONCEPTS AND DESIGNS
The hierarchical data model was developed in the
1960's
The relational data model was developed in the ___
1970s
A___ might be written by a programmer or it might be created through a BDMS utility program.
Application
A _____ database is used by an organization and supports many users across many departments
Enterprise
A (n) _____ represents a particular type of object in the real word
Entity
The _____ model uses the term connectivity to label the relationship types
Entity relationship
An advantage of database systems is that you needn't perform frequent updates and apply latest patches
False
______ provide a description of the data characteristics and the set of relationship that link the data found within the database
Metadata
A workgroup database is a ______ database
Multiuser
Business rules must be rendered in writing
True
In an SQL-based relational database, rows in different tables are related based on common values in common attributes
True
M:N relationships are not appropriate in a relational model
True
Metadata described the data characteristics and the set of relationship that link the data found within the database
True
One disadvantage of a database system over previous data management approaches is increased costs
True
Structures is a based on the type of processing to be performed on the data
True
The network model has structural level dependence
True
The only way to access the data in a database is through the DBMS
True
Today, most relational database products can be classified as object/relational
True
an implementation ready data model should contain a description of the data structure that will store the end user data
True
____ data exist in the format in which they are collected
Unstructured
A(n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization
Workgroup
______ are normally expressed in the form of rules
constraints
A (n) ______ enables a database administrator to describe schema components
data definition language
_____ is the result of revealing the meaning of raw fact
information
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
My SQL is an example of the ______
relational data model
A data model is usually graphical
true
An implementation ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data
true
the object oriented data model was developed in the ______
1980s
A(n) _____ is the equivalent of a field in a file system
Attribute
Which of the following types of HDFS nodes acts as the interface between the user application and the HSFS?
Client node
The database structure in a DBMS is stored as a _____.
Collection of files
The database structure in a DBMS is stored as a ______
Collection of files
A(n) _______ is a restriction places on the data
Constraint
_____ are important because they help to ensure data integrity
Constraints
____ serve as the intermediary between the user and the database
DBMSs
A (n) _______ enables a database administrator to describe schema components
Data definition language
_____ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions
Data integrity
Which of the following refers to the situation where different versions of the same data are stored at different places because they weren't updated consistently?
Data redundancy
The term _____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.
Database system
Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.
FALSE
A disadvantage of the relational database management system is its inability to hide the complexities of the relational model from the user
False
An operational database is sometimes referred to as an enterprise database.
False
Business rules apply to business and government groups, but not to other types of organization such as religious groups or research laboratories
False
Corporations use only structured data
False
Data and information are essentially the same thing
False
Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions
False
Data is the result of processing raw facts to reveal its meaning.
False
Database designers determine the data and information that yield the required understanding of the entire business
False
Database programming language receive all application request and translate them into the complex operations requires to fulfil those requests
False
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
False
Field refers to a collection of related records
False
In Chen notation, entities and relationships have to be oriented horizontality; no vertically
False
In an SQL-bases relational database, each table is dependent on every other table
False
One advantage of a database system over previous data management approaches is that the database system is considerably less complex
False
One disadvantage of the DBMS is that it increases the risk of data security breaches
False
Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data
False
The DBMS reveals much of the database's internal complexity to the application programs and users
False
The external model is the representation of the database as "seen" by the DBMS
False
The hierarchical mode is software independent
False
The relational model is hardware-dependent an software independent
False
When data are entered into a form and saved, they are placed in the underlying database as knowledge
False
A _____ is a character or group of characters that has a specific meaning
Field
A _____ is a collection of related records
File
Accurate, relevant, and timely information is the key to ____.
Good decision making
In the ____ model, the basic logical structure is represented as an upside down tree
Hierarchical
In the ______ model, each parent can have many children, but each child has only one parent
Hierarchical
The organization of data within folders in a manual file system is determine by ______
Its expected use
Students and classes have a ____ relationship
Many to many
A (n)_____'s main function is to help one understand the complexities of the real world environment
Model
which of the following types of HDFS nodes stores all the metadata about a file system?
Name node
The ____ data model is said to be a sematic data model
Object oriented
A data warehouse contains historical data obtained from the _____.
Operational database
The response of the DMBS to a s quarry is the ______
Query result set
End-user data is_____
Raw facts of interest to the end user
A ____ is a logically connected set of one or more fields that describes a person, place, or thing
Record
A(N) _______ is bidirectional
Relationship
An XML database supports the storage and management of _____ XML data.
Semi structured
Most data that can be encountered are best classified as _____.
Semi structured
A desktop database is a ______ database
Single-user
______ are the result of formatting disorganized data in order to facilitate storage, use and generation of information.
Structured data
Data is said to be variable if:
The data always yields consistent results
Which of the following is true of NoSQL database?
They are not based on the relational model
Which of the following is true of business rules?
They can serve as a communication tool between the users and designers
Which of the following is true of spreadsheet applications?
They enhance the user's ability to understand the data
A data warehouse can store data derived from many sources
True
Data constitute the building blocks of information
True
Data processing can be as simple as organizing data to reveal patters
True
Each row in the relational table is known as an entity instance or entity occurrence in the ER model
True
Oracle 12c, MS SQL server, and tamino are examples of _____ data models
XML hybrid
___ exists when different version of the same data appear in different places
data inconsistency
A noun in a business rule translates to a(n) _____ in the data model
entity
A(n) ______ is anything about which data are to be collected and stored
entity
The _____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text
entity relationship
VMS/VSAM is an example of the ______
file system data model
the _____ data model uses the concept of inheritance
object- oriented
_____ relates to the activates that make the database execute transactions more efficiently in terms of storage and access speed
performance tuning
A verb associating two nouns in a business rule translates to a (n) _____ in the data model
relationship
In the context of data models, an entity is a person, place, thing, or even about which data will be collected and stored
true
Within the database environment, a data model represents data structures with the purpose of supporting a specific problems domain
true
