stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
DBMS Module 2 Assessment Flashcards | StudBud
Explore
/
DBMS Module 2 Assessment
DBMS Module 2 Assessment
34 terms
·
StudBud Administration
·
7 plays
2.1 - 2.3 Oracle
Flashcards
34 cards
F
Practice quiz
P
Host live
L
Questions
34
Answers
1
Process of capturing important concepts & rules that shape a business & depicting them visually on a conceptual model is
Data modeling
Data modeling
data modeling
d a t a m o d e l i n g
2
What is an instance defined as?
A diagram showing the relationships between entities
a model of the database structure
a specific occurrence of an entity, containing values for its attributes
A set of rules governing data integrity
3
which of the following best describes an attribute?
A character or property of an entity
An instance of an entity
A collection of data
The relationship between two entities
4
Can only have one value at any point for each instance in the entity is known as:
Physical model
Data type
Null
Single valued
5
ERD stands for Entity Relationship Diagram
False
True
6
Conceptual model is the thought and the physical model includes implementation details of the thought.
True
False
7
Nonvolatile attributes will rarely change.
True
False
8
What is the relationship between entities and attributes?
Entities are a subset of attributes
Attributes provide context and info about an entity.
Entities are defined by their instances
Attributes are separate from entities and can't be used together
9
Shoe size is an example of an:
Attribute
Instance
Entity
10
"Age" would be labeled as an________.
Entity
Attribute
11
All of the following are true about the purpose of entities except for:
Our tech-rich world produces vast amounts of facts in need of structure
Knowing how to organize data helps draw conclusions about random facts
Entities are the things about which we store data.
Entities help distinguish from one instance & another
12
"Email" is considered an attribute.
True
False
13
Which is an attribute of an entity called "Student"?
A classroom
All students enrolled
Student ID
All students in a club
14
The majority of ER Models lead to relational database implementations.
False
True
15
What is an entity?
A set of attributes
A thing or object that can be distinctly identified
A specific piece of data
16
Data type identifies one type of data, the possible values, the operations that can be done, and the way they're stored
True
False
17
"Car" is an example of an attribute.
True
False
18
(choose one) The three database types are:
Network
Active
Hierarchical
Relational
19
A conceptual model is the result of completing the data modeling process
False
True
20
All are true regarding logical models except:
also called an entity relatinship model (ERM)
includes all entities and the relationships among them.
is the result of physical modeling
specifies all attributes and UIDs for each entity
21
Implementation free =
Dependent on the physical model
Not dependent on the physical model
22
"Customer" would be labeled as an entity.
True
False
23
"Order date" is considered an entity.
True
False
24
If "Employee" is an entity, which of the following could be an instance of that entity?
The concept of employment
A description of an employee's role
An individual employee name "Jane Doe" with her details.
The list of all employees in the company
25
Intangible means:
Physical things that can be touched.
Can't be perceived by the senses. Can't be touched.
26
Do entities change depending on the type of database, computer or programming language being used?
Yes
Occasionally
No
27
Null = Value that is unavailable, unassigned, unknown or empty. However it is not zero nor a space.
False
True
28
If the entity is "EMPLOYEE", a UID is a single attribute/combo of multiple, that distinguish an employee from another.
True
False
29
Volatile attributes are constantly changing.
False
True
30
Physical models define definitions, data types, and precision and show all table structures; like columns & primary keys
False
True
31
"Job" is an example of an entity.
True
False
32
to be considered implementation-free, a data model must be changed to accommodate the database system.
False
True
33
a unique identifier (UID) is:
A named thing or category of things that is significant to the business.
A value that is unavailable, unassigned, or empty.
Combo of attributes or relationships that identify an instance of an entity
An occurrence or example of an entity.
34
Physical model = Extension to a logical data model, describes how the objects should be implemented in a database.
False
True
