Database Fundamentals test
questions and answers.
DEF: Redundancy - n
Ans✔
Duplication of data, or the storing of the same data in more than one place.
Qs
DEF: Entity - n
Ans✔
A person, place, object, event, or idea for which you want to store and process data
Qs
DEF: Attribute - n
Ans✔
A characteristic or property of an entity
Qs
DEF: Field - n
Ans✔
A characteristic or property of an entity
Qs
DEF: Column - n
Ans✔
A Characteristic or property of an entity
Qs
DEF: Relationship - n
Ans✔
,An association between entities
Qs
DEF: One-to-Many Relationship - n
Ans✔
A relationship between two entities in which each occurrence of the first entity is
related to many occurrences of the second entity, and each occurrence of the
second entity is related to, at most, one occurrence of the first entity
Qs
DEF: Data File - n
Ans✔
A file used to store data about a single entity. Such a file can be thought of as a
table.
Qs
DEF: Database - n
Ans✔
A structure that can store information about multiple types of entities, the attributes
of these entities and the relationships among those entities
Qs
DEF: Entity-Relationship (E-R) Diagram - n
Ans✔
A graphic model for database design in which entities are represented as rectangles
and relationships are represented as either arrows or diamonds connected to the
entities they relate
Qs
DEF: Database Management System (DBMS) - n
Ans✔
, A program, or a collection of programs, through which users interact with a
database
Qs
DEF: Database Design - n
Ans✔
The process of determining the content and structure of data in a database in order
to support some activity on behalf of a user or group of users
Qs
DEF: Form - n
Ans✔
A screen object you use to maintain, view, and print data from a database
Qs
LIST: 9 Advantages of Database Processing - n
Ans✔
Facilitating Consistency
Improving Integrity
More information from the same amount of data
Balancing conflicting requirements
Increasing productivity
Controlling redundancy
Expanding Security
Providing data Independence
Sharing Data
Acronym: FIM BICEPS
questions and answers.
DEF: Redundancy - n
Ans✔
Duplication of data, or the storing of the same data in more than one place.
Qs
DEF: Entity - n
Ans✔
A person, place, object, event, or idea for which you want to store and process data
Qs
DEF: Attribute - n
Ans✔
A characteristic or property of an entity
Qs
DEF: Field - n
Ans✔
A characteristic or property of an entity
Qs
DEF: Column - n
Ans✔
A Characteristic or property of an entity
Qs
DEF: Relationship - n
Ans✔
,An association between entities
Qs
DEF: One-to-Many Relationship - n
Ans✔
A relationship between two entities in which each occurrence of the first entity is
related to many occurrences of the second entity, and each occurrence of the
second entity is related to, at most, one occurrence of the first entity
Qs
DEF: Data File - n
Ans✔
A file used to store data about a single entity. Such a file can be thought of as a
table.
Qs
DEF: Database - n
Ans✔
A structure that can store information about multiple types of entities, the attributes
of these entities and the relationships among those entities
Qs
DEF: Entity-Relationship (E-R) Diagram - n
Ans✔
A graphic model for database design in which entities are represented as rectangles
and relationships are represented as either arrows or diamonds connected to the
entities they relate
Qs
DEF: Database Management System (DBMS) - n
Ans✔
, A program, or a collection of programs, through which users interact with a
database
Qs
DEF: Database Design - n
Ans✔
The process of determining the content and structure of data in a database in order
to support some activity on behalf of a user or group of users
Qs
DEF: Form - n
Ans✔
A screen object you use to maintain, view, and print data from a database
Qs
LIST: 9 Advantages of Database Processing - n
Ans✔
Facilitating Consistency
Improving Integrity
More information from the same amount of data
Balancing conflicting requirements
Increasing productivity
Controlling redundancy
Expanding Security
Providing data Independence
Sharing Data
Acronym: FIM BICEPS
