INSY3304: Quiz- Chapter 2

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

The hierarchical data model was developed in the _____.

1960s

The relational data model was developed in the _____.

1970s

The object-oriented data model was developed in the _____.

1980s

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 with text.

entity relationship

VMS/VSAM is an example of the _____.

file system data model

In the _____ model, each parent can have many children, but each child has only one parent.

hierarchical

In the _____ model, the basic logical structure is represented as an upside-down tree.

hierarchical

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

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

The _____ data model is said to be a semantic data model.

object-oriented

The _____ data model uses the concept of inheritance.

object-oriented

MySQL is an example of the _____.

relational data model

A verb associating two nouns in a business rule translates to a(n) _____ in the data model.

relationship

A(n) _____ is bidirectional.

relationship

Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS?

Client node

_____ are important because they help to ensure data integrity.

Constraints

_____ are normally expressed in the form of rules.

Constraints

A(n) _____ enables a database administrator to describe schema components.

Data definition language(DDL)

A(n) _____ represents a particular type of object in the real world.

Enity

A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user.

False

An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data.

False

Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.

False

Database designers determine the data and information that yield the required understanding of the entire business.

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

In Chen notation, entities and relationships have to be oriented horizontally; not vertically.

False

In an SQL-based relational database, each table is dependent on every other table.

False

The external model is the representation of the database as "seen" by the DBMS.

False

The hierarchical model is software-independent.

False

The relational model is hardware-dependent and software-independent.

False

Which of the following types of HDFS nodes stores all the metadata about a file system?

Name node

Which of the following is true of NoSQL databases?

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.

A data model is usually graphical.

True

An implementation-ready data model should contain a description of the data structure that will store the end-user data.

True

Business rules must be rendered in writing.

True

Each row in the relational table is known as an entity instance or entity occurrence in the ER model.

True

In an SQL-based relational database, rows in different tables are related based on common values in common attributes.

True

In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored.

True

M:N relationships are not appropriate in a relational model.

True

The network model has structural level dependence.

True

Today, most relational database products can be classified as object/relational.

True

Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain.

True

Oracle 12c, MS SQL Server, and Tamino are examples of _____ data models.

XML Hybrid

A(n) _____ is the equivalent of a field in a file system.

attribute

A(n) _____ is a restriction placed on the data.

constraint

A(n) _______ enables a database administrator to describe schema components.

data definition language (DDL)

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


Kaugnay na mga set ng pag-aaral

Unit 9 Recovery, Recycle, reclaim

View Set

Chapter 14 - Inflammation and Wound Healing (Questions)

View Set

Basic Electronic Components and What They Do

View Set

HSDF 183" Quiz 2.1: Thinking Money

View Set

Math 262 Intro to Linear Algebra Final Exam

View Set

Data, Security, and Network Test

View Set

Microecon Exam (ch. 14, 15, 16, 17, 18)

View Set

AP Human Geography Midterm Review

View Set

Chapter 9: Outlining Your Speech

View Set