Your browser does not support JavaScript!
InnovativePiranha just signed up and they study Computer Science 💻
CommunistHornet just signed up and they study Computer Science 💻
LtdPerch just signed up and they study Hotel Management 🏨
SacredPeafowl downvoted the question #9433.
SacredPeafowl downvoted the question #9433.
MildHedgehog just signed up and they study Marketing Management 📈
UnusualDingo upvoted the question #14778.
WillingKrill downvoted the question #9055.
WillingKrill downvoted the question #3402.
WickedHawk downvoted the question #18072.
AMA University Answers
Earn money Login Register

Fundamentals of Database System

52 answers

A computerized system that permits users to create and maintain a database.
  • database management system Correct
321
A displayed schema is called Schema figure.
  • False Correct
194
A process of producing a set of tables (relations) with a proper attribute.
  • Normalization Correct
179
A single entity instance of one entity class is related to a multiple entity instance of another entity class
  • One-to-Many Correct
108
A single entity instance of one entity class is related to a single entity instance of another entity class.
  • One-to-One Correct
304
All possible column values
  • Domain Correct
310
Attribute is a name for a set of similar things that you can list. Like objects, events, people.
  • False Correct
112
Column header / field A
  • Attributes Correct
224
Controlling Redundancy is used to improve the performance of queries.
  • True Correct
28
Data abstraction is the data type, relationships and constraints that apply to the data.
  • False Correct
302
Data Manipulation Language is use for manipulating data in a database.
  • True Correct
241
Data model is a collection of concepts that is used to describe the structure of a database.
  • True Correct
159
Database System automatically takes care of backup and recovery.
  • True Correct
251
Describes how entities are related.
  • relationships Correct
156
Each entity instance of one entity class is related to a multiple entity instance of another entity class; and vice versa.
  • Many-to-Many Correct
29
Entities can be related indirectly by two (2) relationships.
  • Transitive Relationship Correct
255
Facts that can be recorded and that have implicit meaning.
  • data Correct
164
Indirect relationship causes functional dependency.
  • transitive dependency Correct
217
Internal Level describes the physical storage structure of the database.
  • True Correct
259
It is a collection of related data.
  • database Correct
265
It is a question or an inquiry, sometimes loosely used for all types of interactions with databases
  • query Correct
273
It is a stricter form of 2 nd and 3 rd normal form
  • Boyce Codd Normal Form (BC/NF) Correct
214
It is between high-level and low-level data models.
  • implementation data models Correct
221
It is the number of attributes in a relation.
  • Degree of Relation Correct
27
It is the number of tuples in a relation.
  • Cardinality of relation Correct
281
Its is one or more columns of a relation or table that is used to identify a record.
  • Key Correct
188
Matching Type Common Data Types
  • Matching Type Common Data Types Correct
367
9
Matching Type Relational database schema commonly defines:
  • Matching Type Relational database schema commonly defines: Correct
352
5
Maximum Cardinality describes the maximum number of entity instances in the relationship.
  • True Correct
261
Minimum Cardinality describes the minimum number of entity instances that must participate in a relationship
  • True Correct
293
Multi-value dependency
  • 4th Normal Form (4NF) Correct
243
NO “repeating groups” (columns)
  • 1st Normal Form (1NF) Correct
28
NO Partial Dependency
  • 2nd Normal Form (2NF) Correct
275
No primary key can be null.
  • True Correct
24
NO Transitive Dependency
  • 3rd Normal Form (3NF) Correct
282
Null means a value is unknown.
  • True Correct
233
Null means zero
  • False Correct
177
People whose jobs require access to the database for querying, updating, and generating reports
  • end users Correct
53
Physical data models is a concept that shows how the data is stored on the computer.
  • True Correct
24
Relational Model is a table with columns and rows.
  • True Correct
25
Relationships can't have attributes.
  • False Correct
130
Table definition
  • Schema of relation Correct
259
The participation of an entity in the relationship is mandatory.
  • Mandatory Correct
147
The participation of an entity in the relationship is optional.
  • Optional Correct
105
The relational model (RM) was first described by Edgar F. Codd
  • True Correct
70
The table is in a 1NF if It satisfies the definition of a relation.
  • True Correct
29
The table is in a 2NF if there's NO Partial Dependency.
  • True Correct
144
There’s no difference between the description of database and the database itself.
  • False Correct
125
They are liable for identifying the data to be stored within the database and for selecting appropriate structures to represent and store this data
  • database designers Correct
30
This relationship exists if they are independent or different to each other.
  • Multiple Relationship Correct
48
We call the database and DBMS software together as a
  • database system Correct
33
Who is responsible in administering the primary and secondary resource in the database?
  • database administrator Correct
28
Search
Need to search and CTRL+F on AMA modules?
All courses