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