Your browser does not support JavaScript!

Fundamentals of Database System

52 answers

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