A collection of similar objects with shared structure and behavior

An example of a 1:1 relationship is...

A school is managed by one principal, and a principal manages one school.

the conceptual organization of the entire database as viewed by the databa

An example of a 1:M relationship is...

A teacher teaches many courses, and a course is taught by 1 teacher.

An example of a M:N relationship is...

A teacher teaches many courses, and a course is taught by many teachers.

The equivalent of a file system's record type.

The Hierarchical model is......

Data is grouped into clusters at one or more levels

studbud

M02 Data Models

23 termsStudBud Administration9 plays

Imported from external platform

Flashcards23 cardsFPractice quizPHost liveL

Questions 23

Answers

1
This model represents the database as "seen" by the DBMS.
External model
Conceptual model
Physical model
Internal model
2
This model is the end user's view of the data environment.
External model
Conceptual model
Physical model
Internal model
3
Constraints are...
Attributes
Expressed in the form of rules
Entities
Relationships
4
A class is....
A collection of similar objects with shared structure and behavior
A movement to find new and better ways to manage large amounts of data
data model whose basic modeling structure is an object
A model that includes that object-oriented model's best features
5
An entity is usually expressed as a noun in a data model.
True
False
6
What programming language is Hadoop based on?
C++
Cobol
Java
Python
7
ERD stands for...
Entity Reporting Diagram
Entity Relationship Diagram
Entity Relational Design
Entity Relational Draft
8
How does Crow's Foot notation represent the many side of a relationship in an ERD
N
M
Infinity symbol
three-pronged symbol
9
An example of a 1:1 relationship is...
A teacher teaches many courses, and a course is taught by 1 teacher.
A school is managed by one principal, and a principal manages one school.
A student takes many courses, and a course is taken by many students.
A teacher teaches many courses, and a course is taught by many teachers.
10
Schema is...
the environment in which data can be managed and is used to work with the
a graphical tool in which entities and their relationships are pictured
the conceptual organization of the entire database as viewed by the databa
a two-dimensional structure composed of intersecting rows and columns
11
An example of a 1:M relationship is...
A student takes many courses, and a course is taken by many students.
A school is managed by one principal, and a principal manages many schools.
A teacher teaches many courses, and a course is taught by 1 teacher.
A teacher teaches many courses, and a course is taught by many teachers.
12
UML is based on object-oriented concepts that provides tools such as diagrams and symbols to graphically model a system
True
False
13
XML stands for ...
Extensible Markup Language
Extended Manipulation Language
Extensive Modelling Language
14
A relationship is an association (usually a verb) of two nouns in a data model.
False
True
15
This model represents the global view of the entire database by the entire organization
External model
Internal model
Physical model
Conceptual model
16
This Hierarchical model was developed to manage large amounts of data for complex manufacturing.
False
True
17
An example of a M:N relationship is...
A teacher teaches many courses, and a course is taught by 1 teacher.
A school is managed by one principal, and a principal manages many schools.
A student takes many courses, and a course is taken by one student
A teacher teaches many courses, and a course is taught by many teachers.
18
The physical model operates at the lowest level of abstraction.
True
False
19
What is a segment?
the conceptual organization of the entire database
The equivalent of a file system's record type.
a two-dimensional structure composed of intersecting rows and columns
a representation of the relational database’s entities,
20
NoSQL is a new generation of database management systems that is not based on the traditional relational database model.
False
True
21
What are the three levels of data abstraction defined by ANSI?
External, Physical, Conceptual
External, Internal, Physical
Internal, External, Logical
Internal, External, Conceptual
22
The Hierarchical model is......
collection of records in 1:M relationships
Data is grouped into clusters at one or more levels
database with conceptual simplicity
a two-dimensional structure composed of intersecting rows and columns
23
Which model's basic modeling structure is an object?
Hierarchical model
Network model
OODM
Relational model

M02 Data Models Flashcards | StudBud