DATABASE CONCEPTS AND DESIGNS

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

Unit 1: Civil War and Reconstruction (Module 1, Lessons 5/6/7)

View Set

World History CST Review World War 1

View Set

Organic Chemistry II - Lab Final

View Set

MGT/312T Apply 3 Employee Performance and Operations

View Set

Lección 9: Estructura: 9.1, 9.2, 9.3, y 9.4

View Set