Your browser does not support JavaScript!
ImmenseFowl just signed up and they study Human Resource Management 🫂
ImmediateMastodon just signed up and they study Psychology 😌
LiveBandicoot just signed up and they study Information Technology 👩‍💻
SourTapir just signed up and they study Information Technology 👩‍💻
NumerousLeopard just signed up and they study Psychology 😌
PetiteCatshark just signed up and they study Psychology 😌
GreenLadybug just signed up and they study Marketing Management 📈
IsraeliOrangutan just signed up and they study Psychology 😌
RespectableSalamander just signed up and they study Psychology 😌
ElegantLynx just signed up and they study Psychology 😌
AMA University Answers
Login Register

Fundamentals of Database System

52 answers

A computerized system that permits users to create and maintain a database.
  • database management system Correct
430
A displayed schema is called Schema figure.
  • False Correct
297
A process of producing a set of tables (relations) with a proper attribute.
  • Normalization Correct
199
A single entity instance of one entity class is related to a multiple entity instance of another entity class
  • One-to-Many Correct
126
A single entity instance of one entity class is related to a single entity instance of another entity class.
  • One-to-One Correct
400
All possible column values
  • Domain Correct
425
Attribute is a name for a set of similar things that you can list. Like objects, events, people.
  • False Correct
147
Column header / field A
  • Attributes Correct
307
Controlling Redundancy is used to improve the performance of queries.
  • True Correct
43
Data abstraction is the data type, relationships and constraints that apply to the data.
  • False Correct
398
Data Manipulation Language is use for manipulating data in a database.
  • True Correct
298
Data model is a collection of concepts that is used to describe the structure of a database.
  • True Correct
177
Database System automatically takes care of backup and recovery.
  • True Correct
289
Describes how entities are related.
  • relationships Correct
170
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
46
Entities can be related indirectly by two (2) relationships.
  • Transitive Relationship Correct
309
Facts that can be recorded and that have implicit meaning.
  • data Correct
252
Indirect relationship causes functional dependency.
  • transitive dependency Correct
255
Internal Level describes the physical storage structure of the database.
  • True Correct
357
It is a collection of related data.
  • database Correct
370
It is a question or an inquiry, sometimes loosely used for all types of interactions with databases
  • query Correct
356
It is a stricter form of 2 nd and 3 rd normal form
  • Boyce Codd Normal Form (BC/NF) Correct
272
It is between high-level and low-level data models.
  • implementation data models Correct
236
It is the number of attributes in a relation.
  • Degree of Relation Correct
41
It is the number of tuples in a relation.
  • Cardinality of relation Correct
384
Its is one or more columns of a relation or table that is used to identify a record.
  • Key Correct
274
Matching Type Common Data Types
  • Matching Type Common Data Types Correct
461
9
Matching Type Relational database schema commonly defines:
  • Matching Type Relational database schema commonly defines: Correct
418
5
Maximum Cardinality describes the maximum number of entity instances in the relationship.
  • True Correct
355
Minimum Cardinality describes the minimum number of entity instances that must participate in a relationship
  • True Correct
356
Multi-value dependency
  • 4th Normal Form (4NF) Correct
316
NO “repeating groups” (columns)
  • 1st Normal Form (1NF) Correct
56
NO Partial Dependency
  • 2nd Normal Form (2NF) Correct
349
No primary key can be null.
  • True Correct
35
NO Transitive Dependency
  • 3rd Normal Form (3NF) Correct
376
Null means a value is unknown.
  • True Correct
251
Null means zero
  • False Correct
189
People whose jobs require access to the database for querying, updating, and generating reports
  • end users Correct
76
Physical data models is a concept that shows how the data is stored on the computer.
  • True Correct
47
Relational Model is a table with columns and rows.
  • True Correct
45
Relationships can't have attributes.
  • False Correct
171
Table definition
  • Schema of relation Correct
357
The participation of an entity in the relationship is mandatory.
  • Mandatory Correct
184
The participation of an entity in the relationship is optional.
  • Optional Correct
124
The relational model (RM) was first described by Edgar F. Codd
  • True Correct
94
The table is in a 1NF if It satisfies the definition of a relation.
  • True Correct
57
The table is in a 2NF if there's NO Partial Dependency.
  • True Correct
158
There’s no difference between the description of database and the database itself.
  • False Correct
147
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
51
This relationship exists if they are independent or different to each other.
  • Multiple Relationship Correct
67
We call the database and DBMS software together as a
  • database system Correct
45
Who is responsible in administering the primary and secondary resource in the database?
  • database administrator Correct
45
Search
All courses